ASP.net Help solve problem

[Bakedgoods]

Sorry Stelly I was with the girlfriend yesterday, replied to your e-mails now

Thanks

 

[Stelly]

rightio for anyone that might need the solution this is how I did it:

ALTER PROCEDURE GetTimeTable
(@username NVARCHAR(50), @WeekNo INT, @Year INT)
AS

IF @WeekNo IS NULL BEGIN

SET @WeekNo = DATENAME(week, GETDATE())

END

IF @Year IS NULL BEGIN

SET @Year = DATENAME(year, GETDATE())

END

DECLARE @tTable TABLE
(tId INT, tTimecode NVARCHAR(50), tDate DATETIME, tHours DECIMAL, tUserName NVARCHAR(50), tComments NVARCHAR(MAX), tApproved BIT)

DECLARE @hrsTable TABLE
(hrID INT, hrTimecode NVARCHAR(50), hrMonday DECIMAL, hrTuesday DECIMAL, hrWednesday DECIMAL, hrThursday DECIMAL, hrFriday DECIMAL, hrSaturday DECIMAL, hrSunday DECIMAL)


INSERT INTO @tTable (tId, tTimecode, tDate, tHours, tUsername, tComments, tApproved)
SELECT ID, TimeCode, Date, Hours, UserName, Comments, Approved
FROM tblHours
WHERE tblHours.UserName = @username AND DATENAME(week, tblHours.Date) = @WeekNo AND DATENAME(year, tblHours.Date) = @Year

INSERT INTO @hrsTable(hrTimecode)
SELECT DISTINCT tTimecode
FROM @tTable t
WHERE t.tUserName = @username

UPDATE @hrsTable
SET hrTuesday = t.tHours
FROM @hrsTable h
JOIN @tTable t ON h.hrTimecode = t.tTimecode
WHERE DATENAME(weekday, t.tDate) = 'Monday'

UPDATE @hrsTable
SET hrTuesday = t.tHours
FROM @hrsTable h
JOIN @tTable t ON h.hrTimecode = t.tTimecode
WHERE DATENAME(weekday, t.tDate) = 'Tuesday'

UPDATE @hrsTable
SET hrWednesday = t.tHours
FROM @hrsTable h
JOIN @tTable t ON h.hrTimecode = t.tTimecode
WHERE DATENAME(weekday, t.tDate) = 'Wednesday'

UPDATE @hrsTable
SET hrThursday = t.tHours
FROM @hrsTable h
JOIN @tTable t ON h.hrTimecode = t.tTimecode
WHERE DATENAME(weekday, t.tDate) = 'Thursday'

UPDATE @hrsTable
SET hrFriday = t.tHours
FROM @hrsTable h
JOIN @tTable t ON h.hrTimecode = t.tTimecode
WHERE DATENAME(weekday, t.tDate) = 'Friday'

UPDATE @hrsTable
SET hrSaturday = t.tHours
FROM @hrsTable h
JOIN @tTable t ON h.hrTimecode = t.tTimecode
WHERE DATENAME(weekday, t.tDate) = 'Saturday'

UPDATE @hrsTable
SET hrSunday = t.tHours
FROM @hrsTable h
JOIN @tTable t ON h.hrTimecode = t.tTimecode
WHERE DATENAME(weekday, t.tDate) = 'Sunday'

SELECT *
FROM @hrsTable

 

[Bakedgoods]

Stelly is officially a coding machine. Very nice guy and very helpful.

Thank you so much again.

 

[Stelly]

Stelly is officially a coding machine. Very nice guy and very helpful.

Thank you so much again.

Ah Shucks mate

No problem, any time

Stelly