SQL Server Performance

write a T-sql to get the result

Discussion in 'General Developer Questions' started by ajay_a1, Aug 22, 2006.

  1. ajay_a1 New Member

    suppose there is a Table having rows and column in MxN format.
    How can we get the result set as NxM.

    I mean to write a sql queries to get the the output result format like this.
    Thanks
  2. Roji. P. Thomas New Member

    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by ajay_a1</i><br /><br />suppose there is a Table having rows and column in MxN format.<br />How can we get the result set as NxM.<br /><br />I mean to write a sql queries to get the the output result format like this.<br />Thanks<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br />??? [<img src='/community/emoticons/emotion-6.gif' alt=':(' />]<br /><br />Roji. P. Thomas<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://toponewithties.blogspot.com>http://toponewithties.blogspot.com</a><br />
  3. satya Moderator

    LOL on Roji's expression..
    Ajay
    Are you looking for cross-tab kind of reports?

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.
  4. Adriaan New Member

    Lots of people wondering about cross-tab queries today!
  5. patel_mayur New Member

Share This Page