Hi

I got message like scheema not avaialbe. I dont't know why. Because i m using dynamic column and dynamic table.

ALTER PROCEDURE [dbo].[sp_GetArchived_Timesheet_Weekly]
@UserID NVARCHAR(5),
@StartWeekDate NVARCHAR(MAX)
as
DECLARE @cols AS NVARCHAR(MAX),
    @query  AS NVARCHAR(MAX)
	

select @cols = STUFF((SELECT ',' + QUOTENAME(TsDate) 
                    from Timesheet where StartWeekDate =convert(date,@StartWeekDate, 103)  
                    group by TsDate
                    order by TsDate
            FOR XML PATH(''), TYPE
            ).value('.', 'NVARCHAR(MAX)') 
        ,1,1,'')

set @query = 'SELECT ProjectID as ID ,Project as CatName,' + @cols + ',UserID from 
             (
                select ProjectID,Project,UserID, TSDate,TSTime from Timesheet where UserID='+ @UserID +'
            ) x
            pivot 
            (
                sum(TSTime)
                for TsDate in (' + @cols + ')
            ) p '

execute(@query)