Edit: Nevermind.

My pleasure

I am. Hope to write it in May. I'm working through books online and the MS E-learning. MS also has a (free?) skills assessment that I plan to do soon.

Not 2 sps, 2 queries in one sp.

CREATE PROCEDURE ...

AS

SELECT ... FROM Sales

SELECT ... FROM Sales JOIN SalesDetails ... GROUP BY ...

GO

It will work, crystal can handle 2 recordsets coming back...

To be quite honest, that's a presentation issue, not a data issue. It should be taken care of where you're presenting the data (excel, or reporting tool) not in the...

I'm going to need some sample data to help out with this, and an example of what you want.

By the looks of things, a saleID can have more than one...

Am I correct in saying that you're looking for records where err is not full full of spaces?

Put an index on the err column and try this

SELECT <fields> FROM <table> WHERE Err...

Sorry, I missed the field 'site'. Also must come out of the group by and be agregated (or removed) in the select.

No, it's not because they have the same saleID. the...

Easy enough, move the completion date out of the group by. You'll have to then put a max or min on it in the select clause. Do you want the...

A table design that doesn't require constant changing would be a good place to start. This is also violating relational concepts a fair bit, but I can't think of a...

In SQL 2005 there's a DM  view that can show you this. sys.dm_db_index_usage_stats

That's her automatic signature. Just as mine is "Have a nice day..." It's not aimed at any one but is on every post of hers automatically. It's a pun on...

Do you mean table-valued function perhaps?

If so, there's a very nice section in books online (the SQL help files) on them. Title is "User-Defined Functions That Return a table Data...

Locks are escalated according to memory availability. It's definatly not a hard threshold of 10.

Rules for preventing deadlocks.

1) Keep your transactions as small as possible

2) Access tables as seldom as...

One thing to note with the times is that they vary with other server activity. I ran the following on my server 5 times and got the following results: (exactly...