Hi
I am trying to produce a Stored Procedure to print a Timesheet based on multiple entries for any given Chap/Chapess in any given week
Here is my attempt so far
CREATE PROCEDURE qselTIMEDataOne (@timeTeamID int, @timeWeekEnding datetime)
SELECT timeTeamID int, timeWeekEnding datetime
FROM tblTIMEMainData
WHERE timeTeamID = @timeTeamID AND timeWeekEnding = @timeWeekEnding
GO
This obviousely does nor work, and I am open to suggestions
Cheers
Hans
I am trying to produce a Stored Procedure to print a Timesheet based on multiple entries for any given Chap/Chapess in any given week
Here is my attempt so far
CREATE PROCEDURE qselTIMEDataOne (@timeTeamID int, @timeWeekEnding datetime)
SELECT timeTeamID int, timeWeekEnding datetime
FROM tblTIMEMainData
WHERE timeTeamID = @timeTeamID AND timeWeekEnding = @timeWeekEnding
GO
This obviousely does nor work, and I am open to suggestions
Cheers
Hans