• good basic question.

    Declare @strSql varchar(2000)

    Set @strSql = ''

    Set @strSql = @strSql + 'Create table #tmp (id int)'

    Set @strSql = @strSql + 'Insert into #tmp(id) values (1) Select * from #tmp'

    Exec (@strSql)

    [font="Calibri"]Raj[/font]