Well - it's certainly not a cartesian product, since you have a "real" set of join criteria.

I don't think it will make a lot (if any) difference, but I'm somehow...

Each PIVOT operation can only affect one aggreation operation at a time. If you need two separate aggregate operations - use them as separate derived tables and join them...

But - what exactly IS a data layer "without business logic"?

The data structure itself is "business logic".

The indexing scheme is dictated by "business logic".

The Keys, primary or foreign...

I remember seeing those and we had had a bit of a disagreement. Not that they're not a reasonable starting point - I'm just not convinced they cover all...

This all gets back to a platform for actually implementing the SecureOS concept. Build the minimal core with no "windows or doors in", except for one pre-established protocol for...

Sorry - have no idea if it will work against 7.0.

If anything I have a gut feeling that the DESC syntax is invalid on 7.0.

Point is - I'd advocate actually leveraging reporting services, Crystal reports, Business Objects, or something like that to steer them in the right direction. I mean - that's what...

Relational integrity can't be guaranteed from the business layer alone. It just can't - you could skip some logic at any time, and oops, there it goes - you...

I'd have to agree with Grant - it very quickly becomes an unsupportable solution. You're just asking for trouble.

SSMS given to an unqualified user (even with only read capability...

Here's an example - adapt it to using your table and field names.

use testing

go

drop index endmatric.ix_em_coend

--create the index that will help with the sequencing.

create index ix_em_coend on endmatric(company,date_start desc)

--grouping will...

If there is something you could count/aggregate to give some idea that things are consistent. e.g. sum of all orders, or averages of the time fields, etc....

something...

No....

Let's try this again. from BOL:

The types of statements that are valid in a function include:

DECLARE statements can be...

I have the profiler results. They're attached, but I summarized them a bit.

I ran it twice, once as is, and once after adding a CHAR(300) field (so that the...

running a cast the the string as is returns a datetime value - why are you throwing in the dashes?

e.g.

CAST('20071022' as datetime)

you also have option III

delete A

from dbo.a A inner join dbo.Stg_a B with (nolock)

on A.id = B.id

where YearMonth = @PrevDayYoMo

avoiding the correlated subquery will tend to run a LOT...