Indeed. Another version:

;with Remove

as (

select a.c1

from t1580 a

except

select a.c1

...

Something like this (untested)?

;with Remove

as (

select a.c1

from t1580 a

)

except

(

select a.c1

from T1580 a

inner join T2115 b on a.C301289100 =...

forsqlserver (7/23/2012)

---

Hi Phil and king Thanks..

delete a

from T1580 a

inner join T2115 b on a.C301289100 = b.C1000000161

and b.C7 < 5

this query will delete my actual data I want to...

Haha, caveat emptor as always.

delete a

from T1580 a

inner join T2115 b on...

Not sure I understand the...

Please explain what you are trying to do. Newid() is a SQL thing and a script task is not. Combining them can be done, but not without trips to the...

i assumed that was deliberate!

That would not capture updates to existing data.

I think Anthony meant "custom triggers" - Winnie the Pooh's mates were not that hot when it came to database theory, customised or not 😀

There is another possibility. If your...

How is this question related to SQL Server?

Anthony pretty much laid it on a plate for you and still - no DDL. I'm out.

raghuldrag (7/20/2012)

---

accountno transaction amount date

==========================================

A-123 Cr ...

OK, I thought about this a bit harder.

How about this?

(@LoopRecordCountPrimary+@LoopRecordCountSecondary)==0

emmadcst (7/19/2012)

---

I had been using SQL but not very sure about this query. Will have to look into this further. We had been tracking time for business purposes as required...