Skip to content

Instantly share code, notes, and snippets.

@Vaccano

Vaccano/TableInsert.sql

Created August 28, 2012 16:20
Show Gist options
  • Save Vaccano/3499835 to your computer and use it in GitHub Desktop.
Save Vaccano/3499835 to your computer and use it in GitHub Desktop.
Download ZIP
TableInsert.sql
Raw
TableInsert.sql
create table #MyTable(MyValue int, MyGroup varchar(5))
insert into #MyTable values
(56,'I'), (12,'I'), (56, 'II'), (12, 'II'), (56, 'III'), (56, 'IV'), (56, 'V'), (12, 'V')
select MyValue, MyGroup
from #MyTable
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment