Chandrashekar
6/3/2016 - 11:48 AM

Stored procedure to temp table

Stored procedure to temp table

DECLARE @tblManager TABLE
(
    UserId int,	
    UserName varchar(510),
    Email nvarchar(510)
)

INSERT @tblManager  Exec USP_GetManagersByUserFacilities @centerId=1,@UserId=272,@csvFacilities=N'1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20'
select * from @tblManager;