...as you sardonically tell him "I find your lack of respect for...

Well, I spent more time than I should have trying to get the cascaded value assignments (@counter = column = @counter + 1) to work inside a case statement. Finally...

Bob Hovious (4/30/2009)

---

john.arnott (4/30/2009)

---

So, you're telling us that Darth Vader wrote "Catcher in the...

So, you're telling us that Darth Vader wrote "Catcher in the Rye?";-)

The only difference I see between your two code snippets is starting @counter at 0 or 1. I don't see how that would make a difference. Meanwhile, You...

Yes, of course. Now it's a bit difficult to distinguish that experience from all the repeat viewings on television and the digitally enhanced re-release a couple of years...

Jan Van der Eecken (4/29/2009)

---

David Webb (4/29/2009)

---

Yes. I saw it 5 times during the next two weeks and saw some new detail I had missed on the times before....

Jack Corbett (4/29/2009)

---

Lynn Pettis (4/28/2009)

---

You know, I can think of some one else that, IMHO, ranks right there with our favorite White House window washer, and here is his latest...

Your posted code is incomplete/improperly copied (missing quote mark):

Insert into #YTD (SID,Stage,Year_Start,Year_End,MTD_Date)

select 'TP001,'P','01/01/2009','24/apr/2009','24/apr/2009'

And, as previous poster points out, date formats are incompatible, so the last inserts fail. 'JAN/31/2009'...

Like Ronald, I doubt I'll have much use for a "text" datatype, but we do have XML in our databases so this QOD was valuable to me in pointing out...

Well..... Yes.

Take another look at my suggestion above. Look at Goldie's first post. Consider reading the link Kyle gave to his blog...

SanjayAttray (4/22/2009)

---

select NULL,'manoj'union select Null,'1'union select NULL,'manoj'

order by 2

or

select NULL,'manoj'union select Null,'1'union select NULL,'manoj'

order by 1

gives you same result.

NULL1

NULLmanoj

I tried on all sql server versions and result is same. ...

So this was just for data with dates before March 8 this year, after which it would be 7 hours.... ...

drodriguez,

You say you figured it out. Please share your solution so others can learn from it. Thanks!!

Matt Whitfield (4/20/2009)

---

john.arnott (4/20/2009)

---

Whether sometimes you respond to a "situation" as best you can, even while aware that someone with different skills or experience may have offered a superior solution,...