Dfalir,

yes i understand, if you goto to the post above that i have put, a similar problem is being solved. if you have problems changing the code to suit your...

oh je comprends maintenant

you can goto to this post

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=338&messageid=379131

what exactly do you want to do then? i am a bit confused.

do you want the data in a row to all show in one column?

you should have a change management process in place to cover your back.

yes you can, goto http://www.gotreportviewer.com to get examples of usage of reports. what you might want to use is called a matrix report. you can do it in crystal reports...

if you are doing it in your DAL, you can use a datatable/dataset into which you populate data from two different connections provided you have the same column names and...

well i think you can use ADODB. can you instantiate it?

can you post your query, this sounds very interesting

are you developing a web app?

to get more useful recommendations i would suggest you give more info on for example how busy the server is i.e. transactions per hour etc , the size of your...

 do you get the error only when you run the union or when you run any other query.

check in your machine sys event log if there was a problem with the network...

yea.. beat the info out of the user

No, I think as Ninja said you have to turn on auditing

are you saying you have a one to one mapping of the store to the article?

so is your question then more like:

i would like a count of the stores that [sell/buy/whatever] an articles

Terry,

your first solution should give you what you are asking for.

select count(articles) from mystores group by store

what exactly do you mean by

But then i can't manipulate the...