Advertisement
Dragonheart91

Untitled

Dec 2nd, 2016
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.27 KB | None | 0 0
  1. USE [TaxableIncome_Qa]
  2. GO
  3.  
  4. DECLARE
  5.  @contextId uniqueidentifier = 'PUT YOUR CONTEXT ID HERE'
  6.  
  7.   INSERT INTO [dbo].[EntityTaxLine]
  8.   ([ContextId], [TaxLineId])
  9.  
  10.  SELECT @contextId AS ContextId,
  11.  [Id] AS TaxLineId
  12.   FROM [dbo].[TaxLine]
  13.   WHERE ParentId IS NOT NULL
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement