Advertisement
Guest User

Untitled

a guest
Apr 25th, 2017
46
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.68 KB | None | 0 0
  1. INSERT INTO testtable_10
  2. ([City Key], [Customer Key], [Stock Item Key], [Order Date Key], [Picked Date Key], [Salesperson Key], [Picker Key],
  3. [WWI Order ID], [WWI Backorder ID], Description, Package, Quantity, [Unit Price], [Tax Rate], [Total Excluding Tax],
  4. [Tax Amount], [Total Including Tax], [Lineage Key])
  5. SELECT TT.[City Key], TT.[Customer Key], TT.[Stock Item Key], TT.[Order Date Key], TT.[Picked Date Key],
  6. TT.[Salesperson Key], TT.[Picker Key], TT.[WWI Order ID], TT.[WWI Backorder ID], TT.Description, TT.Package,
  7. TT.Quantity, TT.[Unit Price], TT.[Tax Rate], TT.[Total Excluding Tax], TT.[Tax Amount], TT.[Total Including Tax],
  8. TT.[Lineage Key] FROM testtable TT
  9. GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement