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)
 Multi Value Parameter

Author  Topic 

cardgunner

326 Posts

Posted - 2009-07-22 : 11:48:54
My wording may not be accurate but....
I'm trying to pass a multivalue parameter such as

declare @leac varchar(25)
set @leac='30000,300002'

select *
from tble
where tble.t_leac in (@leac)



CardGunner

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2009-07-22 : 11:54:11
http://vyaskn.tripod.com/passing_arrays_to_stored_procedures.htm
http://www.sommarskog.se/arrays-in-sql-2005.html


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

bklr
Master Smack Fu Yak Hacker

1693 Posts

Posted - 2009-07-23 : 00:30:14
use like or patindex or dynamic sql for in function
see these link for example
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=129815
Go to Top of Page
   

- Advertisement -