<table><tr><td> <table> <tr> <td></td> </tr> </table></td></tr></table>
DECLARE @Count INT,@SqlQuery NVARCHAR(MAX)SELECT @Count =1, @SqlQuery ='CREATE TABLE DynamicTable('WHILE(@Count<=10)BEGIN SELECT @SqlQuery = @SqlQuery + 'Column' + CAST(@Count AS VARCHAR(4)) + ' Varchar(max),' SELECT @Count = @Count +1END SELECT @SqlQuery = LEFT(@SqlQuery,LEN(@SqlQuery)-1) + ')'EXEC(@SqlQuery)
Thanks & RegardsG.RenganathanNothing is mine ,Everything is yours!!!