Here's the query you requested :

Select

dtCC.Tname as TableName

, dtCC.CName as ColName

, dtCC.XType

, dtCC.IsComputed

, dtCC.Text

, C.Name AS ColUsed

FROM

(

Select

O.Name as TName

, C.name as CName

, O.XType

,...

Nobody came up with a better solution because it's not something that should be run on the server(s). However, this is a case where you have no choice. But...

The question really is, does that column need an index (or unique constraint)? If not then it's a complete waste of resources, but if it does the you need...

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