not sure, but it is having only emply data in it.!!!

Try This

🙂

select Id,MIN(a) from (

select a.id, a.a from #MinAmt a ,#MinAmt

union

select a.id, a.b from #MinAmt a ,#MinAmt

union

select a.id, a.c from #MinAmt a ,#MinAmt

) a...

Thanks , seems to be there is no predifined system procedure for this.

Thank you very much.

Thanks sneh.

it is working fine....

Hi to all.

i didnt got any reply . am i missing any information ?

Thanks jitendra. i will try your solution.

But i am looking for Script Task.

Thanks in advance.:-)

Here is the logic which i applyed.

correct me if i am wrong...

select Genre_name, artist_name from #Genre G inner join #music M on m.gid=G.gid

inner join #Artist A on a.mid=M.mid

inner...

Thanks to all.

good to know that, it can be done using intersect and except.

i am done using Exists operator.

Expecting some more Solutions.:-)

i implemented the relation between tables like this.

select Genre_name,artist_name from #Genre G inner join #music M on m.gid=G.gid

inner join #Artist A on a.mid=M.mid

inner join #artist_name AM on AM.art_id=A.art_id...

here is dml for the required tables.

create table #Genre(gid int, Genre_name varchar(100))

insert into #Genre values(521,'classical')

insert into #Genre values(523,'pop')

insert into #Genre values ( 627,'fusion')

Create table #music(gid int,mid varchar(10),Era varchar(20))

insert into #music...

select replace(replace(@blah,LEFT(@blah,2),''),RIGHT(@blah,2),'')

select left(RIGHT(@blah,len(@blah)-2),len(@blah)-4)

select replace(right(REPLACE(left(@blah,2),'')),2),'')

select SUBSTRING(@blah,3,LEN(@blah)-4)

Thanks to all.

Thanks

hi,

thanks for your help, need some more solutions so that we can get the output which we are looking for.

hi thanks for replying me within time,

but we are not looking for this result.

but we are looking for out below result as follows

A B C E

A B C F

because

...