Showing posts with label operation. Show all posts
Showing posts with label operation. Show all posts

Sunday, February 19, 2012

How to use "not in" operation

Dear friends, I was not able to find any perfect toolbox item to use "not in" operation on my selected columns, also how can we use multiple join conditions in the merge join item? Thanks,

Jwalant Natvarlal Soneji wrote:

Dear friends, I was not able to find any perfect toolbox item to use "not in" operation on my selected columns,

Do you want to know if a certain row is not in some other table? This should help:

Checking if a row exists and if it does, has it changed?

(http://blogs.conchango.com/jamiethomson/archive/2006/09/12/SSIS_3A00_-Checking-if-a-row-exists-and-if-it-does_2C00_-has-it-changed.aspx)

Jwalant Natvarlal Soneji wrote:

also how can we use multiple join conditions in the merge join item? Thanks,

Just join multiple columns together. There is nothing limiting you to just one join condition.

-Jamie

How to use "delete" query for more than two tables?

hi all,
i need to perform a operation where in to delete tableA,tableB based on some
conditions, here is the query,
***********************QUERY************
**************
delete from tblSS_ShiftPeriodStamps,tblSS_ShiftStamp
s where
tblSS_ShiftPeriodStamps.StartTime <= @.PurgeTime and
tblSS_ShiftPeriodStamps.EndTime <= @.PurgeTime and
tblSS_ShiftPeriodStamps.ShiftStartTime <= @.PurgeTime and
tblSS_ShiftStamps.ShiftEndTime <= @.PurgeTime and
tblSS_ShiftPeriodStamps.ObjectID = tblSS_ShiftStamps.ObjectID
***********************QUERY************
**************
how will i perform the above operation so that the checks are performed, for
the deletion of first table, i need to check in the second table also.
i would be happy if my friends could help me out...
thanks in advance,
regards,
ChakkaradeepOne object per Delete statement only.
Jens Suessmeyer.