dui4k8aV

1IF Object_id('tempdb..#tempt') IS NOT NULL 
2  DROP TABLE #tempt 
3
4SELECT group_id, 
5       55 AS GAME_ID, 
6       limit_id 
7INTO   #tempt 
8FROM   tg_vip_groups, 
9       tg_game_type_limits 
10WHERE  game_type_id = 24 
11       AND group_id IN (SELECT group_id 
12                        FROM   tg_vip_groups_levels 
13                        WHERE  operator_id IN ( 1, 3 )) 
14       AND limit_id IN ( 3089, 3092, 2012 ) 
15
16SELECT* 
17FROM   #tempt 
18
19-- create a cursor to delete from TGE_Games operators if key already exists   
20DECLARE @AsignLimitsToGame AS CURSOR 
21DECLARE @Game_ID INT 
22DECLARE @Limit_ID INT 
23DECLARE @Group_ID INT 
24
25SET @AsignLimitsToGame = CURSOR 
26FOR SELECT * 
27    FROM   #tempt 
28
29---------------------   
30OPEN @AsignLimitsToGame 
31
32FETCH next FROM @AsignLimitsToGame --Start the cursor   
33INTO @Group_ID, @Game_ID, @Limit_ID 
34
35WHILE @@FETCH_STATUS = 0 --while there is a loaded record, keep processing  
36  BEGIN 
37      IF NOT EXISTS(SELECT 1 
38                    FROM   tg_vip_groups_limits 
39                    WHERE  game_id = @Game_ID 
40                           AND group_id = @Group_ID 
41                           AND @Limit_ID = limit_id) 
42        INSERT INTO tg_vip_groups_limits 
43                    (group_id, 
44                     game_id, 
45                     limit_id) 
46        VALUES      (@Group_ID, 
47                     @Game_ID, 
48                     @Limit_ID) 
49
50      FETCH next FROM @AsignLimitsToGame --Start the cursor   
51      INTO @Group_ID, @Game_ID, @Limit_ID 
52  END 
53
54CLOSE @AsignLimitsToGame 
55
56SELECT group_id 
57FROM   tg_vip_groups_levels 
58WHERE  operator_id IN ( 1, 3 )