Topics
Started by
Posts
Last post
Hi All, What I am trying to achieve is to obtain the difference b/w two tables. Rather than using t…
6 replies
Dear All, I am a j2ee developer.I don’t know much more knowledge about sql query except Simple Inse…
2 replies
declare @Items table(ItemID int,ItemName varchar(20)) declare @ItemValues table(ItemID int,ItemVal…
1 replies
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
Viewing 15 topics - 5,266 through 5,280 (of 12,234 total)
You must be logged in to create new topics.