SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 query help
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

rajasekhar857
Constraint Violating Yak Guru

396 Posts

Posted - 01/18/2010 :  02:17:46  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

USA
2886 Posts

Posted - 01/18/2010 :  22:51:48  Show Profile  Visit jezemine's Homepage  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000