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 2008 Forums
 Transact-SQL (2008)
 comma seperated values

Author  Topic 

kiranmurali
Yak Posting Veteran

55 Posts

Posted - 2010-08-13 : 02:32:46
My senario is like this.

i have to store the input values which are selected from the list into a parameter then i have to call those values in the where condition of my select list.
for example

leave
holidaylist
attendance

when i select leave and attendance or any two or all or one it should store into a parameter.

This parameter i have to use in the where condition of my query.

Thanks in advance.
kiranmurali

pk_bohra
Master Smack Fu Yak Hacker

1182 Posts

Posted - 2010-08-13 : 05:32:57
Hi Kiran,

Have a look of article at:
http://www.sommarskog.se/arrays-in-sql-2005.html


Regards,
Bohra

I am here to learn from Masters and help new bees in learning.
Go to Top of Page
   

- Advertisement -