Topics
Started by
Posts
Last post
Has anyone seen this error returned from an application server whilst running a stored procedure ag…
1 replies
Hi Folks, Need Your help again to rewrite this query using CTE'S. ALTER PROCEDURE dbo.SP_CDB_EA2 @R…
3 replies
Hi Team, I have a table 'library' with two columns user_name, access_time every user is having more…
9 replies
While extracting data I ran across a CTE result i was not expecting. I have a temp table #tReceive …
8 replies
Hi I have a query that displays a bunch of fields, specifically a createdon field and closedate fie…
5 replies
Hi Folks, Need to put this into single SQL statement without update command. UPDATE T --SET T.[Clie…
10 replies
Hi I have created procedure that creates a temptable with the users from a certain business unit. I…
6 replies
Hi Folks, I'm getting an error as "Incorrect syntax near the keyword 'CASE' ". When trying to run t…
9 replies
Hello all, how would I compare a list of concrete values? I have following situation and do not how…
3 replies
hi my index reorganise maintenance plan fails partly due to the disabled indexes Executing the quer…
5 replies
A numeral of separation-connected conservatories to Alter table can utilized with separation tables…
1 replies
DECLARE @Table TABLE (minv_code INT, alert_msg varchar(10), alert_time Datetime) INSERT INTO @Ta…
1 replies
This is my first post so hopefully I'm doing it correctly. If not I apologize in advance. Basically…
6 replies
I have a query like SELECT DISTINCT S.studyCode AS StudyCode ,CL.clientName AS Sponsor ,CL.clientC…
4 replies
In some t-sql 2012 that I am using, I am using the following on 5 separate merge statements. USING …
2 replies
Viewing 15 topics - 2,941 through 2,955 (of 4,984 total)
You must be logged in to create new topics.