daily pastebin goal
6%
SHARE
TWEET

Untitled

a guest Oct 22nd, 2018 67 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Select
  2.   @GroupId= CASE @WorkTypeId
  3.         WHEN 1 THEN (SELECT COALESCE(@GroupId+',' ,'') + CAST(GroupId as VARCHAR(2)) as groupId1 FROM UserGroupRoleMapping
  4.                 WHERE UserId= @UserId and IsActive=1 AND GroupId != 4)
  5.         WHEN 3 THEN (SELECT COALESCE(@GroupId+',' ,'') + CAST(GroupId as VARCHAR(2)) as groupId1 FROM UserGroupRoleMapping
  6.                 WHERE UserId= @UserId and IsActive=1 AND GroupId = 4)        
  7.         ELSE (SELECT COALESCE(@GroupId+',' ,'') + CAST(GroupId as VARCHAR(2)) as groupId1 FROM UserGroupRoleMapping
  8.                 WHERE UserId= @UserId and IsActive=1)
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top