Topics
Started by
Posts
Last post
Hello All, I followed the following steps: use test_db go Create Table SystemPasswords (ID INT IDEN…
14 replies
SET @Date = '2011-01-01' SET @Date1 = '2011-01-30' WHILE (@Date<=CONVERT(DATE,@Date1)) BEGIN …
4 replies
Hi I am trying to find the first day of a week/month Example SELECT DATEADD(wk, DATEDIFF(wk, 6, '20…
20 replies
Urgent help please Ways to Improve this function: CREATE FUNCTION [dbo].[LBS_Quotes_GetEarliestCur…
6 replies
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
Viewing 15 topics - 7,411 through 7,425 (of 10,635 total)
You must be logged in to create new topics.