1
DECLARE product_cursor CURSOR FOR
2 SELECT
3 VendeeClassID, UserID, VendeeClassCode
4 FROM
5 VendeeClass order by UserID
6
7 declare @UserID int
8 declare @ClassCode varchar( 8 )
9 declare @VendeeClassID int
10
11 declare @globalUserID int
12 declare @globalCount int
13 declare @globalClassCode varchar( 8 )
14 set @globalUserID = - 1
15
16 OPEN product_cursor
17 FETCH NEXT FROM product_cursor INTO @VendeeClassID, @UserID, @ClassCode
18 WHILE @@FETCH_STATUS = 0
19 BEGIN
20 if (@globalUserID = @UserID)
21 begin
22 set @globalCount = @globalCount + 1
23 if (@globalCount > 9 )
24 begin
25 set @globalClassCode = ' 01 ' + cast(@globalCount as varchar)
26 end
27 else
28 begin
29 set @globalClassCode = ' 010 ' + cast(@globalCount as varchar)
30 end
31 if (@ClassCode is null )
32 update VendeeClass set VendeeClassCode = @globalClassCode where VendeeClassID = @VendeeClassID
33 end
34 else
35 begin
36 set @globalUserID = @UserID
37 set @globalCount = 1 ;
38 if (@ClassCode is null )
39 update VendeeClass set VendeeClassCode = ' 0101 ' where VendeeClassID = @VendeeClassID
40 end
41
42 FETCH NEXT FROM product_cursor INTO @VendeeClassID, @UserID, @ClassCode
43 END
44
45 CLOSE product_cursor
46 DEALLOCATE product_cursor
2 SELECT
3 VendeeClassID, UserID, VendeeClassCode
4 FROM
5 VendeeClass order by UserID
6
7 declare @UserID int
8 declare @ClassCode varchar( 8 )
9 declare @VendeeClassID int
10
11 declare @globalUserID int
12 declare @globalCount int
13 declare @globalClassCode varchar( 8 )
14 set @globalUserID = - 1
15
16 OPEN product_cursor
17 FETCH NEXT FROM product_cursor INTO @VendeeClassID, @UserID, @ClassCode
18 WHILE @@FETCH_STATUS = 0
19 BEGIN
20 if (@globalUserID = @UserID)
21 begin
22 set @globalCount = @globalCount + 1
23 if (@globalCount > 9 )
24 begin
25 set @globalClassCode = ' 01 ' + cast(@globalCount as varchar)
26 end
27 else
28 begin
29 set @globalClassCode = ' 010 ' + cast(@globalCount as varchar)
30 end
31 if (@ClassCode is null )
32 update VendeeClass set VendeeClassCode = @globalClassCode where VendeeClassID = @VendeeClassID
33 end
34 else
35 begin
36 set @globalUserID = @UserID
37 set @globalCount = 1 ;
38 if (@ClassCode is null )
39 update VendeeClass set VendeeClassCode = ' 0101 ' where VendeeClassID = @VendeeClassID
40 end
41
42 FETCH NEXT FROM product_cursor INTO @VendeeClassID, @UserID, @ClassCode
43 END
44
45 CLOSE product_cursor
46 DEALLOCATE product_cursor