Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
rajasekhar857
Constraint Violating Yak Guru
396 Posts |
Posted - 2010-01-18 : 02:17:46
|
hi this is my query likeset @temp=@PUserName + '||' + Cast(@PGroupid as Varchar) + '||' + @PLocationName + '||' + cast(@PRoleabbrid as varchar) + '||' + @PRoleNamewith in this i want to use query like @PLocationName=@PUserName::@PGroupid ~~@PUserName::@PGroupid::@PUserName::@PGroupidfor example@PLocationName=1501::Delhi~~1501::Mysorefor sample query likeSELECT LOCATION_ID, LOCATION_NAME FROM EMRLOCATIONMASTER WHERE LOCATION_STATUS = 1 AND LOCATION_ID IN ( SELECT DISTINCT LOCATION_ID FROM EMRUSERROLELOCATION WHERE USER_LOGIN = 'privatra' AND GROUP_ID = 1501) AND CLINIC_NAME IS NOT NULLplease help me in that |
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
|
|
|
|