Here's a "fix" for your code... doesn't change a thing in the code... just the way the "seed" for the RAND function works...

select dbo.fx_getrandomnumber(500, 300, rand(CHECKSUM(NEWID())))

FROM dbo.Tally

WHERE N <= 10

That...

Ummm... good idea and nice try... but doesn't work to create different random numbers within the same Select. For example, using the eample Select you have with your...

http://www.sqlservercentral.com/articles/T-SQL/63681/

Either that, or you're mapping doesn't actually equal what's in the file. Could be something stupid like a stray comma in some name in the file.

The data conversion is failing because there's bad data in that column somewhere in the file. You need to find out what the bad data/date is and fix it...

That would certainly help... but the OP said he can't touch the code because it's generated by and ERP. This is all vry much a moot issue.

josephptran2002 (11/26/2008)

---

First, Set DATEFIRST 6 --Since I wish to start counting records on saturday to Friday of every week.

SELECT COUNT(ClearedDate) AS 'Month',

...

When you get done with your CLR, lemme know...

Chris, the link in your signature is broken. You'r missing the right hand bracket on the first instance of the URL IFCode ShortCut.

Heh... check out ths clown...

http://www.sqlservercentral.com/Forums/Topic607292-1424-2.aspx#608466

He posted a NUMS function that uses a WHILE loop, has spent most of the post justifying his crud code, and then calls folks "anal"...

Very nicely done, Ken. Lot's o' work went into that one. Great job.

Jeff Moden (11/25/2008)

---

Thusi... you don't have these defined in your code anywhere... what are the datatypes and starting or constant values for the following variables?

Server: Msg 137, Level 15, State...

Thusi... you don't have these defined in your code anywhere... what are the datatypes and starting or constant values for the following variables?

Server: Msg 137, Level 15, State 2, Line...

Heh... "How fast?" 😀 Looks interesting... lemme take a look.

By the way, just to establish the scale of this project... right now you have...

It sure does... let's have a race when we're done... CLR vs T-SQL.