one table will have a total amount available and the other table will have line items for the amoun…
3 years, 1 month ago
By: The Dixie Flatline
I have the following code in place, I need to be able to capture specific application error for eac…
By: Gary Stacey
Need assistance for below scenario in SQL server 2005.
I have two tables, stg,main with the same structure.Each day data is refeshed into stg from the fla…
3 years, 3 months ago
By: Lynn Pettis
Are any of ya'll using the Entity Framework to develop? I am told that it generates the SQL stateme…
By: Del Lee
Below is the linked server query ,here i m passing the server and linked server name dynamical…
3 years, 4 months ago
I have a table with 2 columns
The first 14 tags have to be in the order I give . However…
i want to show the column data in row wise, can any one please help me how to write a query for…
here is my code:
Declare @var varchar(3)
SET @var = '22'
SET @QRY ='exec dbo.sp_policeTest' + @var
3 years, 5 months ago
The following Code is giving me the following error:
Only one expression can be specified in the se…
I was trying to run the below query
exec master..xp_cmdshell 'C:\Program Files\7-Zip\7z.exe …
By: Ed Wagner
I want to create Jobs Dynamically using a stored procedure and also kick off those jobs.
Also we ca…
I have one query, i want to calculate the business working hours (like from monday to …
3 years, 6 months ago
I want to replace cusror used in the stored procedure by any other alternative solution.
By: Hugo Kornelis
I'm new to XML and SQL Server. I am trying to extract the CustomerID field from the foll…
3 years, 7 months ago
By: Alan Burstein
Viewing 15 topics - 31 through 45 (of 4,152 total)
You must be logged in to create new topics.