Hard to guess from the information you have provided.

The query looks fine if your trying to figure out the number of items that are ordered.

Post some sample data, and desired...

Reference post I just did with same basic question.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=252864&post=true

The best way is to do it on the client.

but you can perform this in a function.

-- =============================================

IF EXISTS (SELECT *

    FROM   sysobjects

    WHERE  name = N'fn_ConcatStrings')

 DROP FUNCTION...

You don't want to "Fix" the size of the transaction log unless you make it a reasonable size, even though your in simple recovery mode sql server will need the...

Happens to everyone I think.

Usually if I'm working on a long post, I'll Put the entire message into the clipboard. so if it does happen I don't lose anything.

I think...

When you restore your test db you should use the

WITH MOVE option to rename your files.

You cannot rename the files of a database.

I'm just guessing here, but are you joining views to views?

On a partitioned system I worked on exhibited this behavior when I joined views together.

Also, the optimizer...

Yeah, I'm not exactly sure.

Hopefully someone will pick up on this thread and clear it up.

You cannot do it from the "Standard" Reporting services browser.

You'll have to build your own pages. Even then your stuck with the paging defined in the rdl.

I think your architecture would lean more towards Processor licensing. Much like a web application only the application connects to the sql server, and an unknown amount of users connect...

Go to microsoft and search on Notification Services.

They made this "add on" similar to Reporting services that will do exactly what you are talking about.

You should create the tables in a different step.

In enterprise manager you can use generate Sql script to generate the tables you want.

In enterprise manager, right click on the database...

When you say export are you talking DTS Export wizard?

When exporting does table b exist in destination database?

If yes, then whatever properties are on that table are not modified.

If no,...

Simple approach would be to create folder structure within report manager. You can put description on each folder, and each report.

Are the servers in diffent Domains?

Are you going across a firewall?

Can you ping the other server?