Skip to content

Instantly share code, notes, and snippets.

@battlejj

battlejj/correct.sql

Created April 22, 2012 02:38
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save battlejj/2442362 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save battlejj/2442362 to your computer and use it in GitHub Desktop.
Download ZIP
Selecting Random IDs for a Subquery in MSSQL
Raw
correct.sql
INSERT INTO
Tickets(
StartedBy,
TicketText
)
SELECT TOP 1000
(SELECT TOP 1 id FROM Users WHERE 0.01 >= CAST(CHECKSUM(NEWID(), id) & 0x7fffffff AS float)/CAST (0x7fffffff AS int)) AS StartedBy,
Comments AS TicketText
FROM olddbserver.oldDB.dbo.Tickets
Raw
normal.sql
INSERT INTO
Tickets(
StartedBy,
TicketText
)
SELECT TOP 1000
ClientId AS StartedBy,
Comments AS TicketText
FROM olddbserver.oldDB.dbo.Tickets
Raw
wrong.sql
INSERT INTO
Tickets(
StartedBy,
TicketText
)
SELECT TOP 1000
(SELECT TOP 1 id FROM Users ORDER BY NEWID()) AS StartedBy,
Comments AS TicketText
FROM olddbserver.oldDB.dbo.Tickets
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment