select empid,logdate,basicpay from summ

result is

empid,logdate,basicpay

aldave,6/7/05,500

aldave.6/22/05,600

how can i display it in crsstab like this

empid, 6/7/05,6/22/05,.... <------- this will be the fields

aldave,500,600 <--data

and i will have the query ....... logdate between (param1 and param2)

tnx in advance

Take a look at http://www.aspfaq.com/show.asp?id=2462



“I sense many useless updates in you... Useless updates lead to defragmentation... Defragmentation leads to downtime...Downtime leads to suffering..Defragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" -- http://sqlservercode.blogspot.com/

You don't do what you want in SQL, you do it in your display layer, web or front end application aka display layer (asp/php/vb/dot net/java/etc.). You select it just like you did from SQL and use your other programming language your using to format it that way.

I agree. I had to crosstab some data in a query recently. What a headache!

Display layer. Yes, its good.