Hmm.. sounds like you're getting into the realms of dynamic SQL which I've
not done unfortunately.

Maybe someone else out there can help you?

Regards
Christine





Singh Jitender
<jitender.[Email Address Removed] To: Christine Carter/UK/TLS/[Email Address Removed] Singh Jitender <jitender.[Email Address Removed]
mens.com> cc: "LazyDBA.com Discussion" <[Email Address Removed]
Subject: RE: Urgent(cross tab query)!!
19/08/2003 11:06










Thanx christine,

But my this resourcetype column is dynamic today is jan-03-mar-03 but every
month
It will grow and can reach to jan-05 also.

Please advice.
Jit





_________________________________________________________________
--------------------- End of message text --------------------

This e-mail is intended only for the person to whom it is addressed. If an
addressing or transmission error has misdirected this e-mail, please notify
the author by replying to this e-mail. If you are not the intended
recipient you must not use, disclose, print or rely on this e-mail.

PricewaterhouseCoopers LLP is a limited liability partnership registered in
England with registered number OC303525. The registered office of
PricewaterhouseCoopers LLP is 1 Embankment Place, London WC2N 6RH. All
partners in PricewaterhouseCoopers UK Associates A are authorised to
conduct business as agents of, and all contracts for services to clients
are with, PricewaterhouseCoopers LLP. PricewaterhouseCoopers LLP is
authorised and regulated by the Financial Services Authority for designated
investment business.

PricewaterhouseCoopers LLP may monitor outgoing and incoming
e-mails and other telecommunications on its e-mail and
telecommunications systems. By replying to this e-mail you
give your consent to such monitoring.

----------------------------------------------------------------
Visit our website http://www.pwcglobal.com


MS Sql Server LazyDBA home page