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!

P.s  Nice trick with the TOP 0 thing... most folks use WHERE 1=0 to do the same thing.  TOP 0 seems more obvious and I like it.

First, SELECT/INTO does not lock system tables during a SELECT/INTO with no explicit transaction... (at least, none that I can detect)...

Test setup:

First, build yourself a nice medium sized test...

You should never set the database to grow by a percentage especially if the size of a database starts out small.  It takes 73 growth spurts to grow a 1...

Sure... I'll send you the shrunken head of a Developer that I didn't like

Just curious... did my post help at all?

Yep... write to a UNC instead of a file/path...

\\machinename\path

The server must have write privs, as well.

SELECT dbo.functionname(@parameter)

Job Requirements:

1. Must know T-SQL inside and out
2. Must at least know how to spell "performance code"
3. Must comply...