SELECT IN ORDER BY CHARINDEX (排序)

最新推荐文章于 2023-03-14 11:03:25 发布

booth.chen

最新推荐文章于 2023-03-14 11:03:25 发布

阅读量1.4k

点赞数

分类专栏：数据库

本文链接：https://blog.csdn.net/chbos/article/details/8032379

版权

数据库专栏收录该内容

23 篇文章 0 订阅

订阅专栏

DECLARE my_cursor CURSOR SCROLL DYNAMIC 

SELECT UserID,SupplierID FROM  SupplierFollower

WHERE IMeetSupplierID IN(182231,182233,182234,121280)

order by charindex(cast(SupplierID as varchar), '182231,182233,182234,121280')

OPEN my_cursor 

DECLARE @userid NVARCHAR(100),@supplierID NVARCHAR(100)
FETCH next FROM my_cursor INTO @userid,@supplierID
while(@@fetch_status=0) 
  BEGIN 
    IF((SELECT COUNT(0) FROM dbo.T_Tagging WHERE MemberID=@userid AND TagStatus=2)>0)
    BEGIN
        PRINT 'INSERT dbo.T_Tagging
                     ( MemberID , SupplierID , TagStatus , CreateDate ,ModifyDate)
              VALUES ('+@userid+','+@supplierID+',2 getdate(),getdate())'    
  END    

FETCH next FROM my_cursor INTO @userid,@supplierID 
END
CLOSE my_cursor DEALLOCATE my_cursor