quote:

---

Originally posted by madhivanan

I have given the answer here
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=136500

Madhivanan

Failing to plan is Planning to fail

---

quote:

---

Originally posted by hemant_ec48

Sorry my friend that in not a answer...on that post i have ask some what complecated Question...so i have post new one....with easy way....


thanks,

Hemant Patel
Contact me : 09726242864

---

-- generate some test data
declare @M table (Mid int)
declare @Q table (Qid int, Mid int, QValue varchar(255))

insert @M
select 1 union all 
select 2

insert @Q
select 10,1,'Q10 value' union all
select 11,1,'Q11 value' union all
select 12,1,'Q12 value' union all
select 20,2,'Q20 value' union all
select 21,2,'Q21 value'

-- classic inner join resultset...
select
convert(varchar(255),m.Mid) as Mid,
q.QValue
from @M as m
inner join @Q as q on m.Mid = q.Mid
order by m.Mid,q.Qid

-- resultset without repeating Master data
select 
case
  when rownum=1 then Mid else '' end as newMid,
QValue
from
(select
row_number() over (partition by m.Mid order by m.Mid) as rownum,
convert(varchar(255),m.Mid) as Mid,
q.QValue,
q.Qid
from @M as m
inner join @Q as q on m.Mid = q.Mid)dt
order by Mid,Qid