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...

2007-07-16 13:34:56.59  logon Login failed for user 'JUnitCustomer'.

2007-07-16 13:34:56.67  logon Login failed for user 'JUnitCustomer'.

2007-07-16 13:34:56.71  logon Login failed for user 'JUnitCustomer'.

2007-07-16 13:34:56.84  logon Login failed for user 'JUnitCustomer'.

2007-07-16 13:35:12.43  spid4 ResType:LockOwner Stype:'OR'...

You bet... thanks for the feedback.

Would appreciate two things please... since you obviously can't get my last name correct, please call me "Jeff".

Second... I asked you to post...

Heh... I jumped the gun a bit... Oleg's code seems to do the trick nicely, though.