gregg_dn (1/3/2011)

---

I'm getting an the following error when I try to run the OPENROWSET function:

DECLARE @CD TABLE (XMLData XML);

INSERT INTO @CD

SELECT *

FROM OPENROWSET(BULK N'C:\SQL\cd_catalog.xml', SINGLE_BlOB)

Msg 491, Level 16, State 1,...

You will get much higher degree of uniqueness if you look at the least significant digits of your RAND() instead of the most significant.

In your Tally solution, simply changing LEFT()...