Topics
Started by
Posts
Last post
Hi All, It's been a while not being here, and my SQL has gotten a little rusty in days of old. Now …
7 replies
I'm in the process of trying to identify duplicate contacts. I doing this for millions of contacts…
7 replies
Hi, I need some help in building the dynamic sql . When I create below script and executed the pro…
30 replies
I am trying to select data from a column that has xml data in it. I have tried all I can think of, …
10 replies
Hi, Sample data to play with declare @client table(clientid int primary key,clientname varchar(30))…
7 replies
Can someone please look at this code and tell me what I am doing wrong. the middle 2 conditions are…
2 replies
SET @id = id= @id + 1
2 replies
Hi SQL-Guru, I have the following Query. SELECT CAST(DEL_INTERCOMPANYRETURNACTIONID AS NVARCHAR(40…
1 replies
Here is a CTE query With mstrTable(ItemNo, Sales) as ( Query1 Union All Query2 ) Select Row_Number…
7 replies
Hello, I am using AdventureWorks2008R2 to do some practice on Pivot, here is my query: Select * F…
3 replies
Hi Guys, I'm working with a schedule report where the data given is as follows however the required…
4 replies
Hi every one, I am new to SSC . I have a table that has NO.OF WORKING HOURS for 30 days. I am tryin…
6 replies
I have a population split between two vendors. One gets last names between A and R, the other the r…
2 replies
Hello friends if t-sql query is perfectly run in development and when I execute in production at th…
1 replies
Is there a way to use a case statement after "SET"? I am currently getting the following.. Msg 156,…
10 replies
Viewing 15 topics - 1,156 through 1,170 (of 10,647 total)
You must be logged in to create new topics.