sql test

Sql code posted by Tihonovich A.Y.
created at 24 Jul 21:42, updated at 01 Aug 14:27

Edit | Back 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
 
DECLARE @i INT,@page varchar(25),@coll varchar(50)
  SET @i = 1
  WHILE (@i <= @count_add)
  BEGIN
    set @page= cast(@i as varchar(10))+'стр. клиентов: ';
    set @coll=(select COUNT(acc) from #TEMP where pages =@i)
    print @page+@coll
    exec('insert into dbo.Client (*)
       select * from #TEMP where pages >'+@i+'')  
    SET @i = @i + 1
  END
  
  SET @count_con=(select COUNT(1) from ctk_UserData)
  PRINT '_______________' 
  PRINT 'Итого конвертов: '+@count_con 
  PRINT '**************************************************'
529 Bytes in 2 ms with coderay