Be very careful... There is nothing there that will keep 2 or more simultaneous calls to the same code from returning the same number.

Sure, but as others have already stated, a table source for this is the best way to go. The following code will solve the problem without a table, though....

Post the OSQL command, please.

EAV won't be a slow as you think. It'll process about 12 million rows in about 7 seconds.

halifaxdal (12/10/2008)

---

Hi guys,

Here is my task:

I have couple records marked as integrity = 1 or 2 or 3 or 4

I need to write a query to pull out all...

Heh... I hate it when impatient people pull this crap... this is a double post... please, no more answers on this thread... go to the following, instead...

http://www.sqlservercentral.com/Forums/Post.aspx?SessionID=gjq2tn3letp4qj554vsxeizy

First, it's not nice to double post.

Second, the function may work perfectly for...

Heh... to heck with all that... start answering posts on this forum with code! 😉

Nicely done, Peter.

I don't know how you'd do it in SSIS, but here's the T-SQL solution...

--===== Create a place to hold test data and populate it.

-- Note...

Why?

... and let me know if you still need a variable for the date...

And, never use INT for such a conversion because it rounds up to the next day for...

Heh... "We don need no stinkin' cursors"... 😛 ... especially in SQL Server 2005. Look at all the difficulties you're having making one do the things you want....

Ron, just an FYI... the code came through with no carriage returns.

And thanks for the awesome compliment! :blush:

Yeah, but why do you want to format the code is SQL? Unless you're formatting to write to a file, then you should let the formatting be done in...