You searched for the word(s): userid:667155

More Search Options

RSS Available

• SQL help

  HI,I have a sql query like this, SELECT TEAM, RESULT, COUNT(RESULT) AS COUNT FROM TABLE1 GROUP BY TEAM, RESULT ORDER BY TEAM which gives me the resultset like the TEAM RESULT COUNT BAN w 10 BAN l 3 BAN T 2 BAN U 1 DRI w 7 DRI L 3 DRI T 1 DRI U 0 i am trying to get my result like the following, team w l t u BAN 10 2 2 1 DRI 7 3 1 0 can someone help me please with this?SQL PIVOT?thanks in advance

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by nb123 on 11/30/2009

• sql query count help

  i have a table like this, NAME TYPE 18 BAN U 19 EDE W 20 BAN W 21 DRI L 22 BAN T 23 BAN U 24 ASH U 25 BOE U 26 DRI U 27 EAG U i need to find out,total number of each type against each name. For example, name BAN , type U = 2 Type W = 1 Type T = 1 can i have one query to all this?

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by nb123 on 10/8/2009

• Re: prod database backup

  i am stuck at point 2,i try to backup using sql server mgt studio on the server but i am unable to specify the loocation where i can save it.Nothing shows up there for me to select where i want to save...

  Posted to Data Presentation Controls (Forum) by nb123 on 9/14/2009

• prod database backup

  hi,i have my website hosted on shared hosting server. I am using sql server 2005.I want to backup my prod database from host server to my local pc but it does not let me specify the location so i can backup .Can anyone help me with this please? thanks

  Posted to Data Presentation Controls (Forum) by nb123 on 9/13/2009

• combining 2 rows of data into 1 row

  I have a table like this id1 id2 col3 1983 2 val2 1983 2 val3 1984 3 x1 1984 3 x2 i want to combine two rows into 1 ,like this ,how do i achieve this? id1 id2 col3 1983 2 val2-val3 1984 3 x1-x2

  Posted to Data Presentation Controls (Forum) by nb123 on 8/29/2009

• grid view subtotal data row

  i need to display the data like this in grid view ,where i am subtotaling the data after say every year and displaying grand total at the end,how do i display the total at the end of the year row and grand total at the very end? (using .net 2.0) year col1 col2 1983 1 2 1983 2 3 total 1983 3 5 1984 5 6 1984 4 6 total 1984 9 12 grand total 12 17

  Posted to Data Presentation Controls (Forum) by nb123 on 8/28/2009

• login question

  i am testing a login system.Problem is,currently many people can log on using the same login id on different computer or( even in same computer opening multiple browser).How do i make sure that it doesn't allow multiple login using same loginId at the same time?

  Posted to Security (Forum) by nb123 on 8/12/2009

• color choice control or dropdownlist of colors?

  Does anyone have a simple solution: which allows user to pick up the color they want?i want to be able to save that color choice in db for further use in app. -Is it possible to populate the dropdownlist with all the possible colors available for use?I want to be able to show the dropdown color choice with background color in it.Something simple and easy to implement...thanks

  Posted to Web Forms (Forum) by nb123 on 8/9/2009

• catching database error

  how do u catch the database error,during due to say -passing the wrong parameter name -passing the null values as parameter -data values which is causing say arithmatic error i have a try-catch block set up,but it appears to me that when the error occurs due to above reasons,its not going to catch block.I want to log this kind of error to some table (directly from stored procedure) and display friendly message to the user.thanks a lot

  Posted to Data Presentation Controls (Forum) by nb123 on 8/7/2009

• Login failed for user after deploying the site on host server

  Can someone explain this to me,why i keep getting this error when trying to load up the page my website on internet.Everything works gr8 in development . -Login failed for user 'myHostName\IUSR_myUserNameOnHost -i have provided the user name and pwd in conn string,trying to connect to sql server 05,thats what host server -i have impersonation "false" -authentication mode="forms" ,i tried with "none" as well. -If i try to add 'myUserNameOnHost" on prod server

  Posted to Configuration and Deployment (Forum) by nb123 on 8/6/2009