Can you post the query you are using?

This is something you must do with a derived table, then inner join... if I understand what you need correctly.

Could you...

Could be... certainly not the expected behavior. Maybe you should ask on a dts specialized site for this one. You might get a clearer answer.

Especially not that wheel .

Here's a workaround :

Create dts

Create job that runs the dts

create alert that fires the job when raised

create stored proc that raise the alert

grant exec to the proc.

Document the proc...

I was referring to the simple where condition. The calendar option can save you a lot of problems, but there are also other options to solve this problem.

They probabely assume that if you can use sql server, then you should be able to make a proper design...

Depends how the EndDate is defined... Assuming that it's defined to null for the active products, then :

Select ...

where DateEnd is null

group by...

if it's set to a time way...

It's always something dumb once we find it .

Happy to hear that .

Did you also know that intColName is a worst practice (in case the datatype changes down the line)??

Here's the link for db Ghost :

db Ghost

Yup... no hesitation.

Or else you would have seen a few pages of rant in here .

Maybe you could add a little check constraint to avoid those kind of dulicates :

check : intStudent1ID <= intStudent2ID

that way 1, 1 is valid (but only once because I...

Actually this is much simpler :

select productid

from dbo.product_cities

where city in ('boston', 'chicago', 'denver')

GROUP by productid

having count(*) = 3 --number of cities in the in clause.

Select name, A, B, C, D, (A + B + C + D) / 4.0 as Average from dbo.YourTable

Would be nice if we could lock out the admins sometimes .