but even this is also taking more time for 25K records.

with Improved SQL 8K “CSV Splitter” Function its taking around 25 sec

with xml its taking around 30sec

with substring its taking...

i want the product which is there in both the brand not just in one

yes it's a sql server feature.

i just searched in web it is row level and cell level security.any idea about this?

whether it requires separate license or its free with sql server

thanks

it will be great if anyone explain or give some links to learn how sql server engine will process the query for some basic dml operations(delete,update,insert).

DELETE d1 FROM duplicate d1...

hi,

when i run the package in execution result it shows only below information

Task load pricing matrix-----------this is my DFT name

Validation has started

[SSIS.Pipeline] Information: Validation phase is beginning.

Progress: Validating...

hi chris,

find the updated execution plan.

thanks,

i think clustered index(primary key) in base_table is costing more.

is it good idea to drop and create clustered index after merge statement.

hi

find the same

hi ,

i attached actual execution plan of my proc..please find attachment(results.txt)...

thanks joe

thanks ram...

foreign key...