I agree with that!  The looping has got to interfere with the overall performance.

Anyway, Michael... I have a question about your wonderful F_TABLE_NUMBER_RANGE  function... Since it's very fast (Surprisingly so! ...

I'm not a .Net guy either... that's why I just right click on a proc in QA and select [OPEN].  A windows opens with all the parameters available which can...

Obviously...

Like you said at the end of your last post, I'm still trying to get Lindsay to correctly identify the problem

Yep... that's what I was talking about... but that's week 14?  Maybe I missed it somewhere but you still haven't given us all the info we need... like when the...

But it won't always unless you have something that identifies the order of the task descriptions....

I'm still waiting for Lindsay to describe what happens during the first week of the year... for example, if it has less than 4 days, is it considered to be...

EXEC @sql will try execute a named stored procedure where the name is stored in @sql.

EXEC (@SQL) will execute the SQL stored in the variable @sql

Did you get an "A" on the homework?

FTP to a text file... then BCP or Bulk Insert into SQL Server.  See Books Online for more info on either or both.

Lindsay,

What are the rules for the first week/first month of the year?

Considering your other post... this looks a lot like a take-home exam...

Considering your other post, this looks a lot like a take-home exam.

Yep... clever code.  Thanks.

Very hard for me to believe you can't display an estimated execution plan... even a fully read only data base let's you do an estimated execution plan in Query Analyzer......

Yep... some serious truth in that... the best accounting procedure is, of course, don't make mistakes.  The second best is don't try to roll back anything... issue a credit!