Advertisement
Guest User

Untitled

a guest
Jul 18th, 2019
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 1.29 KB | None | 0 0
  1.         """  
  2.        INSERT INTO web.Action(action_name,verbose_text) SELECT DISTINCT action_name,verbose_text
  3.        FROM web.facts_mindbox
  4.        WHERE action_name NOT IN (SELECT action_name FROM web.Action) AND verbose_text NOT IN (SELECT verbose_text FROM web.Action)
  5.    
  6.        DECLARE @time_insert datetime
  7.        SET @time_insert = GETDATE()
  8.    
  9.        UPDATE [trg]
  10.        SET [trg].[date_insert] = @time_insert
  11.        FROM [web].[Action] as [trg]
  12.        WHERE [trg].[date_insert] IS NULL
  13.        ;
  14.    
  15.        INSERT INTO web.Channel(channel) SELECT DISTINCT channel FROM web.facts_mindbox WHERE channel NOT IN (SELECT channel FROM web.Channel);
  16.    
  17.        SET @time_insert = GETDATE()
  18.    
  19.        UPDATE [trg]
  20.        SET [trg].[date_insert] = @time_insert
  21.        FROM [web].[Channel] as [trg]
  22.        WHERE [trg].[date_insert] IS NULL
  23.        ;
  24.    
  25.        INSERT INTO web.channel_action(channel_action) SELECT DISTINCT channel_action FROM web.facts_mindbox WHERE channel_action NOT IN (SELECT channel_action FROM web.channel_action);
  26.    
  27.        SET @time_insert = GETDATE()
  28.    
  29.        UPDATE [trg]
  30.        SET [trg].[date_insert] = @time_insert
  31.        FROM [web].[channel_action] as [trg]
  32.        WHERE [trg].[date_insert] IS NULL
  33.        ;
  34.    
  35.        """
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement