Thanks Mr. Bhuvnesh for ur help.

Shahbaz

msn: shahbaz_awan@hotmail.com

ONE EXAMPLE PLEASE ....

Shahbaz.

Thanks Mr. Bhuvnesh for your prompt reply.

But, how I can catter it if there are unlimited Contact_types? is it possible to write dynamic query for it ?

Shahbaz

Hi,

Thanks all of you for response and I have done this seccessfuly. once again thanks.

Shahbaz

As you know that INSERTED and DELETED tables do not retrieve the values of text, ntext and image types, and I want to make a generic procedure to create one...

SELECT * INTO #INS FROM INSERTED

it works fine.

I just want to run this query via EXEC command.

Dear Chris,

Thanks a lot for your help; its working fine now.

DECLARE @sql VARCHAR(4000)

SET @sql = ' SELECT * INTO #TEMP FROM CUSTOMERS;

SELECT * FROM #TEMP'

EXEC (@SQL)

Once...

Thanx for your prompt reply,

but plz can u give me an example?

Thanks all of you its working fine