I'm thinking about it by why just a single query?  Hopefully, you're not going to create a view of this monster... .

I have an...

So you were just kidding when you wrote the following?

During...

Shouldn't have to because the server should be able to see it's own drives.  Dunno what's wrong because the code I wrote works fine on my server. 

Also, dunno what...

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...