How do I populate temp table..

See more:

SQL

Hey

1) Temp table ain't getting created by procedure.
2) even i tried using tempdb..tablename but not helpfull
3) So i modified code taken permanent table instead of temp table..
and code works and permanent table gets populated..


Can anyone please help....
I don't know why temmp table ain't getting created ?

Thanks in advance..

What I have tried:

ALTER PROCEDURE USP_FONM_HM
(
@DB_NAME NVARCHAR (MAX), -- DB NAME
@FORMAT_TABLE NVARCHAR (MAX),
@FORMAT_NODUPS NVARCHAR(MAX) -- REMOVE NO DUPS TABLE

)

AS

--@SQL_NO_DUPS_ID NVARCHAR (MAX) -- FETCH MAX ID FROM PREVIOUS SCRIPT

BEGIN
DECLARE @SQL_REMOVE_NODUPS NVARCHAR (MAX) -- TEMPORARY TABLE

PRINT '-- REMOVE DUPLICATES --'
BEGIN
SET @SQL_REMOVE_NODUPS=
CONCAT
(

'DROP TABLE ',SPACE(1),'#',@FORMAT_NODUPS,'

;WITH SAMPLECTE
AS
(
SELECT A.* , ROW_NUMBER () OVER ( PARTITION BY FIRST_NAME , LAST_NAME , ADDRESS, ZIP ORDER BY FIRST_NAME) AS RNUM
FROM ',SPACE(1), @DB_NAME,'..',@FORMAT_TABLE ,' A
)
SELECT * INTO',SPACE(2) ,'#',@FORMAT_NODUPS , '
FROM SAMPLECTE WHERE RNUM=','1','
'
)
END
PRINT @SQL_REMOVE_NODUPS

EXEC (@SQL_REMOVE_NODUPS)

END

------------------
EXEC USP_FONM_HM 'PRAC','TEST_FORMAT','TEST_FORMAT_NODUPS'