Topics
Started by
Posts
Last post
Does anybody have idea why code below doesn't work correctly with order by substring() ? declare @…
1 replies
Hi, I am trying to replace the character I with 1 in one of our tables. For eg: I have a column …
1 replies
I have a proc that does a whole lot of things. SO i am not gonna go into its detail. I will defanet…
8 replies
Hello All, To give a brief description of the problem. I had configured a "Job" on SQL Serv…
2 replies
Hello All, To give a brief description of the problem. I had configured a "Job" on SQL Serv…
1 replies
Hi Guru's I can understand without sample data it's hard but I am sure for below issue, you guys do…
2 replies
i have table like this. id schooltname state distict city ----------------------------…
2 replies
hi, i have a table from which i am using 3 fields, i want to transpose these fields, sample da…
7 replies
So I have a fairly complicated peice of code. When executed without hints, takes roughly 18 minutes…
4 replies
Hi! I was wondering if table alias' are allowed on multiple table joins? Somthing like this: FROM …
3 replies
SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=\\9.10.11.100\Test\Test.xls…
1 replies
Hi All, I have an SQL Agent script that runs at Midnight GMT every day. The script will send an em…
10 replies
Hi I have a table ,Table1 - with col's - ID,Name,desc. If there a duplicate name I am trying to get…
4 replies
I hope somebody could jump into this and advice me . I have a (SQL server 2000 )table with 800,000…
2 replies
I was going to submit this as a QOTD, however our browsers are totally locked down here, so ... I h…
18 replies
Viewing 15 topics - 5,266 through 5,280 (of 12,231 total)
You must be logged in to create new topics.