thanks for answering my question.

here's the real situation... my customer is pharmaceutical company and recently had a foreign partner who has IT department in india. these companies are very sensitive...

dear friends,

what about if I create a user, disable windows users privileges and not allow them to login sql server, disable sa and only give owner privileges to my new...

sorry, I needed to mention that I DO NOT KNOW THE FILED NAMES.

reason is I will run this query for every table. I need syntax like insert statement:

select *...

woow... thank you my friend. you saved my day. I could not imagine this.

thank you for million times.

have a nice day.

I'm not changing requirements my friend. just clearifying the problem for you.

any way, thanks for your intrerest.

yes actually. but column count and column names are changing all the time. so I beleive a kind of "for each column..." structure needed. and the the sql statement you...

no my friend, forget about everything I said before and just consider my last post. I managed my pivot code and my only concern is now "sum of itself and...

wow, quick answer. yes I have no data, sorry I know it would be easy. okay, let me put in that way. here's sample data:

Product Col1 ...

of course I'll read it my friend, thanks...

WOOOWWW.... that was fast...

You saved my day man... if somebody can say "I know SQL" then he must be you.:-P

thank you, thank you and thank you...

my friend, here's the db for you:

http://www.karina-mira.com/testdb.rar

OR here's the script for tables & data. please create database "test" before ececutiong. I did not included database creation script codes:...

my friend,

pivot didnt work because it can ony accept aggregate function. I also need money indormation (euro, usd, etc...) I did run pivot but could not append USD nor EURO...