@okbangas

Thanks, it helped..!

When it takes procedure data from any stored procedure and that procedure contains '' then it produces error

Eg..

for following stored procedure it consider as procdata

USE [LocalTestData]

GO

/****** Object: StoredProcedure...

GilaMonster, Its extremely necessary to improve query performance..even if it process execution paralleled.

Or we can do bulk insert if we can using xml to improve performance?

Thank you all..!

I appreciate your help.. Most probably i can remove in clause and use inner join..

You can use how to check last updated stored procedures by below queries..

SELECT name

FROM sys.objects

WHERE type = 'P'

AND DATEDIFF(D,create_date, GETDATE()) < 7

select name,create_date,modify_date

from sys.procedures

order by modify_date desc