I agree with Andras. Also - if you simply add in the extra fields from Employee that you need to actually see in the final query to the CTE...

Brandie Tarvin (1/11/2008)

---

I'm thinking about this report and-ideally-here's what I'd like to do.

Have 2 datasets. DataSet1 is the detail. DataSet2 is the totals.

Write some sort of expression or...

Have you looked at using the WITH ROLLUP option? It will allow you to put in sub-total lines "inline" with the rest of the query.

you might need to play...

What exactly happens?

Put an index covering the ID and amount, so that you're not hammering the table with scans.

Something like:

Create index ix_tblExtract_ID on tblExtract(ID) include (amount)

Otherwise - just...

Download and install the "Advanced Services" version of SQL Server express, and you will see it included in the options for what you can install (in the client tools stuff)....

correct - but notice this little time-bomb:from "how to license"

A license is required for each physical or virtual processor accessed by...

Under 2005 - that's not actually correct. Multi-instancing is allowed in a single OS instance under the same...

Rog - if you have the "correct version" of SQL Serve Express installed, you should then either have something called Business Intelligence Design Studio (BIDS), or (if you already had...

The SSRS designer is called BIDS (Business Intelligence Designer Studio), which is a limited version of Visual Studio (if you don't already have it installed). If you have a...

Gary -

Do you have SSMS for SQL Express? If you do - if the Database is set up to be attached at all times, you should see the...

So affinity mask set to 0 for a specific processor core means - don't use it? It's worded so very awkwardly. I hate when they tap-dance around the...

Also -

depending on how you set the DB up (e.g. if you had Visual Studio create the database for you), you might have ended up with the DB being set...

Here here on getting the accountant to help you set up the taxes.

that being said - if you're going on a 1099 basis, using your previous salary as a benchmark...

Or - it's a "red herring posting" and someone in the recruiting business is trying to cast a wide net....

That being said - it seems to be leaning towards the...

Adam Skelton (1/10/2008)

---

I work in a development shop, all of our SQL boxes have multiple instances of SQL Server. On the larger one we run 7 instances, a mix...