|
rajasekhar857
Constraint Violating Yak Guru
396 Posts |
 Posted - 01/18/2010 : 02:17:46
|
hi this is my query like
set @temp=@PUserName + '||' + Cast(@PGroupid as Varchar) + '||' + @PLocationName + '||' + cast(@PRoleabbrid as varchar) + '||' + @PRoleName
with in this i want to use query like
@PLocationName=@PUserName::@PGroupid ~~@PUserName::@PGroupid::@PUserName::@PGroupid
for example
@PLocationName=1501::Delhi~~1501::Mysore
for sample query like
SELECT 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 NULL
please help me in that |
|
query help
