Topics
Started by
Posts
Last post
my stored procedure. its used to insert the data and increment idcount by one till the end of the y…
4 replies
Hey all, I have this query SELECTa.Report_Menu_Code , a.Menu_Name, b.Sub_Menu_Code, b1.…
17 replies
I am pivoting against a dataset and that works, but I want to add GROUP BY ROLLUP so that I can hav…
7 replies
Trying to do what I thought would be a simple LIKE wildcard query but I can't get the syntax correc…
13 replies
hi We need to combine two DML Statement into one statment update B Set B.phone_disp_new = ISNULL(A…
2 replies
Hi All, I have a table of stock details for NSE holiding Daily data. Here is the structure of the t…
18 replies
Hi All, Now in the SP shown below, I want to control the where clause from outside (Application). …
7 replies
Does anyone have a simple Stored Procedure that uses a MERGE Statement uses BEGIN TRY/CATCH Error h…
34 replies
I have a Table T1 with columns Col1, Col2, Col3, Col4, Col5 having primary key on columns Col1, Col…
3 replies
Hello all, having a table like this one: ID - DateRef - GroupID 17 2012-06-20 10:00:00.000 463 21…
10 replies
Hi SQL, I have issue when sql command content for bat file @ECHO OFF echo Executing the SQL Script.…
2 replies
How do I optimize a query with several nested joins? An index scan has the highest cost in the exe…
7 replies
Hi, Thanks for advance, I have one small question i have one table like 2 columns both are varchar(…
2 replies
This seems to work as I would expect it to, but is there any reason that you can think it would not…
6 replies
Ok Here is my code and a sample of my result set. Basically I am working with the computed column B…
2 replies
Viewing 15 topics - 5,461 through 5,475 (of 10,635 total)
You must be logged in to create new topics.