Pass Temporary Table Values parameter as stored procedure

See more:

SQL-Server

Hi this is Ramesh.

i wrote the sql query(bellow). Actually the temp table #tblx have data. But when i am passing as select query it will return zero.

Please help me...

CREATE TABLE #TblX( Code varchar(20))
DECLARE @TblY TABLE(Code varchar(20))
INSERT #TblX
SELECT distinct Code FROM tbl_MainList

SELECT  feorcre,ClientID,[#TblX]
FROM
(SELECT distinct Code,feorcre,ClientID
FROM tbl_MainList where FeorCRE=@FeorCre  ) As Souce
PIVOT (COUNT(Code) FOR Code IN ([#TblX])) As p