Michael, you might want to check your code, too...

DROP TABLE #Dates

CREATE TABLE #Dates (aDate DATETIME)

INSERT INTO #Dates

SELECT TOP 100 DATEADD(dd,DATEDIFF(dd, 0, getdate()),50-number)

FROM Numbers

SELECT aDate, SergiyStart, SergiyEnd, CJMStart,...

Can you demonstrate please, Karthik? I'd be very keen to...

If new rows were going into table1 until it was replaced by table2, then this might be more appropriate:

SELECT emp_id, name, CAST(NULL AS CHAR(20)) AS emp_address, DOB

FROM table1

UNION ALL

SELECT...

karthikeyan (3/3/2009)

---

Hi All,

Thanks for all your inputs!:)

I found the TSQL 101 solution.

Declare @InputDate Datetime

select @InputDate = '02/mar/2009'

select case when upper(datename(dw,@InputDate)) = 'MONDAY' then dateadd(dd,-7,@InputDate)

...

When writing an UPDATE ... FROM ..., it pays to write it as a SELECT first, to see what rows are going to be affected and what the new values...

Jeff Moden (3/2/2009)

---

There's no special technique for this... it's simply the choice to figure it out using regular ol' set based code. It doesn't require a Tally table or...

Here's the same code with the outer loop removed and the update statements

replaced by PRINT statements, to try to identify what this thing does.

I made the assumption that...

Here's a quick sample using Jeffs' suggestion of PARSENAME:

DROP TABLE #Sample

CREATE TABLE #Sample (id INT, PersonName VARCHAR(100))

INSERT INTO #Sample (id, PersonName)

SELECT 1,'Doe, John H.' UNION ALL

SELECT 2,'Pardeshi, Mangal' UNION ALL

SELECT...

Jeff Moden (2/27/2009)

---

I'd still like to know why we're spelling out dates. What are the business rules that would require such a thing?

Also, just a friendly tip... you don't...

Check triggers on company_ext_attributes

Jeff Moden (2/27/2009)

---

Oracle... when code is autogenned, it comes out in all uppercase for things like column names whether you want it to or not. Oracle peeps have gotten...

That's nice - you're welcome!

I have to agree with Jeff however, this type of processing is almost always better done by the application/presentation...

Hi Crazyman

If you look at the result from the sample query

SELECT a.[Date], a.Userid, a.[Name] , '#', b.UseridRef, b.Userid

FROM #Temp a (nolock)

LEFT JOIN #TempCross b(nolock)

ON 'S000'+ CAST(b.UseridRef AS...

Have some coffee - the expressions are the wrong way round in the function 🙂

declare @searchterm nvarchar(200)

SET @searchterm = 'blood and sweat'

SELECT charindex(@SearchTerm,'and'), charindex('and', @SearchTerm)

GilaMonster (2/26/2009)

---

Jeff Moden (2/26/2009)

---

All SQL Keywords in UPPER CASE.

All database names, table names, procedure names, column names, column aliases, variable names (basically, my stuff) etc, in MixedCase with no underscores....