RE: randomized update
try this DECLARE @RandomValues TABLE ( RandVal int ) DECLARE @Tbl TABLE ( Id int identity, RandVal int ) INSERT INTO @RandomValues VALUES (1) INSERT INTO @RandomValues VALUES (4) INSERT INTO @RandomValues VALUES (6) INSERT INTO @RandomValues VALUES (10) INSERT INTO @Tbl (RandVal) VALUES (NULL) INSERT INTO @Tbl (RandVal) VALUES (NULL) INSERT INTO @Tbl (RandVal) […]
2003-05-27