Topics
Started by
Posts
Last post
Can anyone shed any light on the following error message: Server: Msg 8152, Level 16, State 9, Line…
4 replies
I have a over one hundred fifty tables that share a column name. I want to query each of…
6 replies
'SELECT c1,c2,c3,c4,c5,c6 INTO #emp_temp1 FROM #emp_temp order by ' +@col_name+'…
5 replies
I have 50 rows in my sumary table.I wantted to show them in the front end with pagination,means i w…
3 replies
Hi, My returns result set like this: Case_No Case_Line_No &nbs…
8 replies
I need to make a dynamic SQL query passed as a select statement in cursor mode in MSSQl. e.g DECLAR…
4 replies
I want to get the maximum of sum with one select statement. The database is NorhtWind and this is t…
5 replies
Hi, Any idea why when using xp_cmdshell to write to a text file (Exec master..xp_cmdShell 'ECHO thi…
3 replies
Why would this script no correctly rank the product field. (dept nbr and product have the sam…
1 replies
hey guys, just a quicky, i can't remember for the life of me how to programmatically turn off the (…
2 replies
Hi everyone, I'm trying to execute the following T-SQL Statement but it's not working. Could anyone…
6 replies
I have a procedure that is taking 100 minute to return. It's basically inserting data into tw…
18 replies
Hi friends I've some piece of code in stored proc that takes couple of minutes to complete.ofcourse…
4 replies
Hello all, Can someone suggests the following: I have an Employee table with 3 fields: Client_Rep, …
20 replies
Anyone have a good idea on renumbering rows in a column that might have been misnumbered by an appl…
4 replies
Viewing 15 topics - 12,766 through 12,780 (of 17,082 total)
You must be logged in to create new topics.