declare @base_filter_id varchar(max)
select @base_filter_id = isnull(@base_filter_id + ',', '') + base_filter_id from filtersmaster group by base_filter_id 

and then pass the CSV value into your stored procedure. Your stored procedure will need to modify to handle the CSV input value.
Make use of CSVTable or fnParseList found here
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=25830&SearchTerms=CSVTable
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=76033

quote:

---

Originally posted by ergen

This one will work, but I'm not sure if you are aware of the fact that this query in procedure can return more that 1 record. In such situation you will get an error... look at http://www.jacek-szarapa.com/index.php?p=sql&d=3 that will help with the problem when more than one record is returned.


CREATE PROCEDURE [dbo].proc_ins_TestDetails
(
@Title nvarchar(100),
@Base_Filter_Id char(3) output
)
as
begin
select @Base_Filter_Id = distinct(Base_Filter_Id) from filtersmaster
end
go

declare @Base_Filter_Id1 char(3);
exec proc_ins_TestDetails @Title='',@base_filter_id1 output
select @Base_Filter_Id1


----------------
Jacek Szarapa
http://www.jacek-szarapa.com

---

quote:

---

Originally posted by khtan

if you have multiple value for base_filter_id, maybe you can form a CSV (comma separated value)

declare @base_filter_id varchar(max)
select @base_filter_id = isnull(@base_filter_id + ',', '') + base_filter_id from filtersmaster group by base_filter_id 

and then pass the CSV value into your stored procedure. Your stored procedure will need to modify to handle the CSV input value.
Make use of CSVTable or fnParseList found here
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=25830&SearchTerms=CSVTable
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=76033

---

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

---