DECLARE
@column NVARCHAR(MAX),
@sql
NVARCHAR(MAX),
@spname NVARCHAR(MAX)
-- Name of Stored procedure.
SET @spname =
'[dbo].[USP_Get_CustomerAll]'
-- column name with datatype
-- Structure of column and datadype must match with
stored procedure.
SET @column =
'
[Customer_Code] NVARCHAR(MAX),
[Customer_Name] NVARCHAR(MAX),
[AddressLine1] NVARCHAR(MAX),
[AddressLine2] NVARCHAR(MAX),
[Country_Code] NVARCHAR(MAX),
[Country_Name] NVARCHAR(MAX),
[State_Code] NVARCHAR(MAX),
[States_Name] NVARCHAR(MAX),
[City_Code] NVARCHAR(MAX),
[City_Name] NVARCHAR(MAX),
[Region_Code] NVARCHAR(MAX),
[Region] NVARCHAR(MAX),
[Area_Code] NVARCHAR(MAX),
[Area_Name] NVARCHAR(MAX),
[Email] NVARCHAR(MAX),
[Phone] NVARCHAR(MAX),
[Mobile] NVARCHAR(MAX),
[Web] NVARCHAR(MAX),
[NoofFollowup] INT,
[Status] NVARCHAR(MAX),
[PinCode] NVARCHAR(MAX)
SET @sql =
' CREATE TABLE #Temp
( '
+ ' '
+ @column +
') INSERT #Temp EXEC ' +
@spname + '
select * from #Temp
DROP TABLE #Temp'
PRINT
@sql
EXEC
sp_executesql
@sql