Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @BadgeDefinitionID BIGINT = 420
- DECLARE @UserIDs NVARCHAR(MAX) = '11279,11133,11227,11100,1,2,3,4'
- BEGIN
- DECLARE @Users TABLE
- (
- Id BIGINT
- )
- INSERT INTO @Users
- SELECT Item FROM dbo.fn_SplitToBigint(@UserIDs, ',')
- select * from @Users
- --INSERT INTO IRBadgeUserAssignet(IRBadgeDefinitionID, IRUserID)
- SELECT @BadgeDefinitionID, u.Id--,bua.IRUserID
- FROM IRBadgeUserAssignet as bua
- RIGHT JOIN @Users as u ON bua.IRUserID = u.Id
- WHERE bua.IRUserID IS NULL
- end
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement