hi,

Just I want to pass datatable as xml parameter to sp

and in sp I need to select values from xml parameter and insert into...

Thank you very much.

I get inserted successfully through the method which u specify

Thank you.

I got correct query.

-------------------------

declare @vcTemp int

declare @sql nvarchar(max)

declare @tblname1 as varchar(50)

declare @tblname2 as varchar(50)

set @tblname1='tbl_00001'

set @tblname2='tblSt_00001'

SELECT @sql='select @vcTemp=count(*) from(

select line,Status_text,Zerox_ID from...

I am alredy try that method also

declare @val int

declare @sql varchar(max)

declare @tblname1 as varchar(50)

declare @tblname2 as varchar(50)

set @tblname1='tbl_00001'

set @tblname2='tblSt_00001'

select @sql=N'with cte1

as

(

select line,Status_text,Zerox_ID from '+@tblname1+' where allocateto...

Hi

thank you.Its working fine.but I am trying to print that variable nothing

will be displayed

code

-----

declare...

I have try already this

but its not working