Oh, yeah... if you want the actual "Region ID", you'll need to get Telcordia's "NNACL"... but I think that's only for the US and Canada.  Prepare to pay some $$...

I'll second that on LincMad... been using his stuff for years and is one of the best places to find this type of free info.

If you need something to pay...

Heh... also hacked one for Peter's method... slowed it down just a bit but it's still faster than the traditional method...

--===== Peter's method of generating random numbers from...

Hacked a fix for the zero distribution problem on the traditional method...

--===== Traditional method of generating random numbers from -5 to +5

 SELECT SUM(CASE WHEN r = -5...

Couldn't resist... simple integer rounding gives zero twice the number of hits using both methods... everything else has a pretty good distirubtion... if anyone wants to take a crack at...

Peter, I gotta say it again... nice job... I was a bit concerned about distribution of the numbers so I compared your method against the traditional method... both have the...

Heh... no problem James... short naps are what get me through the day

Percent James... he needs the /100 to turn it into the decimal equivelent of percent so it can be used as a multiplier...

Close Peter... and nicely done, but I believe you need this instead...

SELECT 1 + (CHECKSUM(NEWID()) % 6) / 100.0

...yours gave a range of .96 to 1.04... above gives range of .95...

Heh... look at the original post... no need to put these in startup (although that's a good idea!).

No, no... just add SET NOCOUNT ON...

osql -E -d pubs -q "SET NOCOUNT ON select * from dbo.authors" >junk.txt -h-1

You could also do it in a file using the...

To further the explantion...

You cannot put indexes on views unless they are specifically designed to be "Indexed Views".  There's a long list of requirements to make an Indexed View in...

And, yes... BCP will also create output without headers.

As Christoper suggests, you may want to create the report (in T-SQL, possible as a sproc) and have OSQL run it... to suppress the headers, use the -h-1 parameter in the...

Heh... Not having nearly the bad day that you will if you keep trying unverified commands on your database (production or not)   That's...