Easiest, yes, fastest, no.

Using a function on a column in the where clause of a query will prevent the optimiser from using any index that may exist on that...

What type is the TAB lock? S, X, IX, Sch-S?

An IX lock on table level is fairly normal when doing modifications. It's not a full exclusive lock, it's there in...

I'd love to work in the 3D graphics industry. I do modelling and rendering as a hobby, but I'm no where near as good as the professionals

That, or be an...

Table A to be able to create 1 row for each distinct gr# with first occurence of toname and fromname

What do you mean by first? First alphabetically? Is there another...

Apparently they don't.

Sorry, I wrote those a while back and they did work then. Haven't used them in ages. Will check.

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...