Heh... you made my day, Sergiy. I've been trying to convice a DBA on a little side job of those very same points... he's doing things like using calculated...

yearmonthtime... so no days in there. The year could be 2 or 4 digits. The month could be...

Outstanding, Sergiy... you've reminded me of a couple of questions that I've always wanted to ask about such multi-purpose (Numbers/Tally + Date table + other) tables... guess now's as good...

Well, at least it has some documentation to let you know what's going on... that's a start.

You already know the bad news... this code has joins of concatenated address columns...

wdillon (5/6/2008)

---

Hi Jeff, I got the Tally table thing worked out from finding on another post of yours. WOW!!!! The data looks great!! Do you ever...

So THAT's what it is! Here I was trying to cut...

Thanks for the info, guys! 🙂

matt6749 (5/6/2008)

---

Yeah! Got it working in SQL Server! Thanks to Barry, Matt, Jeff, and this forum!

DECLARE @sql nvarchar(4000)

SET @sql = 'SELECT ID, Name, Address

FROM

(SELECT ID, Name, Address,

ROW_NUMBER()...

Ok... I'll try a third and final time... I'm trying to help you do this using xp_CmdShell and Bulk Insert, as you requested. I asked you a couple of...

Ummm... you certainly don't need a cursor to transpose a table. Cross-tabs, dynamic cross-tabs, and the occasional use of the Pivot function do the job in a nice set...

Holy Moly... that's one heck of a lot of analysis. Did they actually get anything useful out of all that?

dfalso (5/6/2008)

---

{I was encouraged to discuss my position a little better}

I'll attempt to give an example to illustrate (btw, this also illustrates a candidate for an appropriate use of cursors):

Think...

GSquared (5/6/2008)

---

Dateadd lists of datetimes. For example, if you need a second-by-second list of all times in a month, or a quarter. (10,000 seconds is a little less...

Now, you know why I've chosen the Avatar that I have... 🙂

Cursors = RBAR

The reason why the variable had the value subtracted twice is to make it work properly... you wanted the running total to NOT include the current value and that's one...