Guys I am trying to demoralize the source column in one of my tables so

I can identify the combination of sources that the email was recruited
from.


I know I can do this with a while loop (or cursor) but I would really
prefer taking a
set based approach.

Also, please feel free to offer any ideas on a better way to model
this.


I would like to know if we recruited an email on web site A, web site
B, or web site A and B.


My data table looks something like #data_table and I want my result set

to look something like #hybrid_table.


Can anyone offer some advice on how to approach this problem?


Thanks for you suggestions!!!


--drop table #data_table
create table #data_table (email_id int,src_id int)
--raw data
insert into #data_table select 1,5
insert into #data_table select 1,6
insert into #data_table select 1,7


insert into #data_table select 2,5
insert into #data_table select 2,6
insert into #data_table select 2,7


insert into #data_table select 3,5
insert into #data_table select 3,6
insert into #data_table select 3,7


insert into #data_table select 4,5
insert into #data_table select 4,6


insert into #data_table select 5,5
insert into #data_table select 5,9
insert into #data_table select 5,4
insert into #data_table select 5,20


insert into #data_table select 6,20
insert into #data_table select 6,5
insert into #data_table select 6,9
insert into #data_table select 6,4


--DROP TABLE #hybrid_table
create table #hybrid_table (hybrid_id int identity(1,1),hybrid_name
varchar(50))
insert into #hybrid_table (hybrid_name) SELECT '5,6,7'
insert into #hybrid_table (hybrid_name) SELECT '5,6'
insert into #hybrid_table (hybrid_name) SELECT '4,5,9,20'


select * from #data_table order by email_id,src_id
select * from #hybrid_table