Topics
Started by
Posts
Last post
This statement renders 2 years ago today: SELECT DATEADD(dd, DATEDIFF(dd,0,GETDATE()) -730, 0) How …
11 replies
The 2 following statements don't give the same result.Why is it so ? SELECT id FROM a except sele…
6 replies
Today I came up with strage problem. I have a query like below: exec @return_value=my_proc @paramet…
11 replies
Hi Guys, There is a particular statement in one of my stored procedures that is causing me a headac…
6 replies
Hi all, sometimes I found queries in the profiler with sort warnings like this example: exec sp_exe…
4 replies
Hi Good people, I have a stock table. Kindly see below select INDEX_CODE ,INDEX_DATE ,[OPEN] ,HIGH …
3 replies
Below are my two queries that I am working with. In Query A I get all the chargecodes that have Rev…
6 replies
Is it possible to debug a stored procedure using Management Studio?? Thanaks
4 replies
I have a database which is 1.5 GB. Recently I deleted some data(one third data in the entire databa…
11 replies
hi i wrote query like this.. select COUNT(u.userid) from users u inner join status s on (u.userid=…
2 replies
I am showing you dummy data select A,B,C from TEST Output: 10 1 1 10 1 2 10 2 1 10 2 2 10 3 1 10 3 …
18 replies
Hi I am trying to extract just the hours and minutes form getdate. The best I have come up with i…
4 replies
This is puzzling...at least to me. SELECT A FROM TABLE 1 WHERE A NOT IN ( SELECT Field1 FROM B ) AN…
2 replies
Hello All experts, I have requirment to run the queries against three tables with left outer join, …
3 replies
Hi all, I have a TSQL case I cannot explain. The problem is that the same SQL statement from the sa…
6 replies
Viewing 15 topics - 7,426 through 7,440 (of 10,647 total)
You must be logged in to create new topics.