The end result of the query I wrote doesn't give totals by day... it simply generates an internal record for each day so it can sum them by month (that's what...

Not sure that's true... what you say will certainly guarantee that all the pages of the table are loaded into memory at startup... but even a simple SELECT * from...

Good grief... I had no idea you had that many rows ... I should'a asked.

The query generates...

You are now 'cause that's the way to do it...

Brian, I think all you need to do to Serqiy's solution is change the "<" to "<="...  haven't tried it, though...

Joe,

I tend to lean towards Remi's solution simply because it has no loop although I believe the loop would be just as fast in this case (probably only until the...

Gopi,

Try passing this into your version....

SET @STR= '1,.,,$,2d01,6,7,8,9,10,0'

ISNUMERIC isn't valid as an IS ALL DIGITS function.  You must use NOT LIKE '%[^0-9]%' instead...

If the "#" is supposed to represent a digit, what happens if you introduce a letter or a space?   And, if you...

Is she hiring?

Yes... where is the C:\Person_Notes directory... on the server or on your desktop?

Lee,

Just curious... Everyone keeps telling you that cursors are not the way to go... why do you insist on using them?

Mita,

If you take a look... it is working correctly... you have multiple entries for some of the FMIS codes... notice in the sample data that you have the following inputs...

This should do it... if you don't already have a TALLY table, here's how to make one...

--===== Create and populate the Tally table on the fly

 SELECT TOP 11000...

Do you need ISO weeks by any chance?

RBAR!