Topics
Started by
Posts
Last post
1) What's the best way to create a temp table in a proc? I need the proc to return results from the…
8 replies
I am running time diffrences in the following MAX inner queries, as you can see the first and last …
13 replies
How can I determine the number of times a certain day occurs in a month? i.e, there are 4…
2 replies
Hi, I have a scenario where I have to have a unique combination on two columns and One of the colum…
4 replies
I have two servers. a production server, and a backup server. Both have sql server inst…
4 replies
Hai All, Is ther any way to get the Standard Deviation of numbers in a table row (i mean STDEV funt…
6 replies
I have a multi-company environment, where each company has a related table inside one database. So,…
8 replies
Kind people, I need to switch off column header and that annoying dash line when Dumping the output…
3 replies
i would like to create a temp table and insert values into the temp table in a store procedure…
3 replies
Hi, I observed a very curious situation today while translating a query from old *= syntax to ANSI …
6 replies
HI , I am updating a sql server table ( 7.0) through an asp page ( using dsn). ( Table has on…
3 replies
When I run the query below in Query Analyzer on my MSSQL/2000 server I get a blank nt_username. How…
15 replies
I want to create a table that has an identity key that rotates once the top-end of a range is reach…
9 replies
Does any one know what sp_prepexec extended stord procedure does? We find it running on serve…
4 replies
I have a very larre (and growing) table which contains a PK and another column of the type text. Th…
1 replies
Viewing 15 topics - 13,396 through 13,410 (of 17,082 total)
You must be logged in to create new topics.