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.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 query help

Author  Topic 

rajasekhar857
Constraint Violating Yak Guru

396 Posts

Posted - 2010-01-18 : 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

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2010-01-18 : 22:51:48
this is not t-sql. guessing it's for oracle?

sqlteam is for SQL Server questions only. try http://dbforums.com


elsasoft.org
Go to Top of Page
   

- Advertisement -