Topics
Started by
Posts
Last post
I have data in a table as below. IDData 1A 1B 1A 2C 3A 3A I want to return this IDData 1A…
4 replies
Hi to everyone I am using ms sql 2000 db i am retriving data at run time so i have used T-sql selec…
15 replies
Now I was asked to run a compare on the data. I created a table and ran the cursor. It stored dat…
23 replies
Hi All I got this code from:http://www.sqlservercentral.com/scripts/Miscellaneous/31574/ But this s…
5 replies
Hi All I have a problem, I need to be able to write a loop that will loop through all databases and…
2 replies
Hi - I need to change a collation of a field. The field is varchar(20). I need to change it, from …
4 replies
I have a script similar to the below example in prod example: select tt.t1, tt.t2, tt.t3 from tes…
4 replies
Hi All, I have one scenario. create table #temp ( week1 decimal(16,8), week2 decimal(16,8), week3 d…
21 replies
If a table having both clustered index and non clustered index on same columns,,, It has any proble…
1 replies
I have a flattened out data mart table like: Id int Name varchar Address varchar .... ServiceNumber…
7 replies
Hello, I wrote a script to run a trace but the files created are only 128KB. It will not cycle to …
5 replies
My database server (Sql server2005)is having disk space problem and it contains some data which is…
1 replies
Hi, How you do the following? what would be the correct syntax for the last line will not work dec…
7 replies
Is there a way to start a SQL Server 2000 job and then monitor it to completion? Has some one alre…
20 replies
Greetings. I was able to add a tab delimited text file as a linked server, basically copying and p…
1 replies
Viewing 15 topics - 1,681 through 1,695 (of 17,082 total)
You must be logged in to create new topics.