Stored Procedure or View to Print out One Record 1

[GammelNok]

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

 

[JamesLean]

Not entirely sure what you want but start by taking out the int and datetime from the SELECT list.

--James

 

[tlbroadbent]

You should check the SQL BOL for proper syntax.

http://msdn.microsoft.com/library/en-us/tsqlref/ts_create_4hk5.asp

In addition to James' suggestion, you need the keyword AS.

CREATE PROCEDURE qselTIMEDataOne
@timeTeamID int,
@timeWeekEnding datetime)
AS

SELECT timeTeamID, timeWeekEnding
FROM tblTIMEMainData
WHERE timeTeamID = @timeTeamID
AND timeWeekEnding = @timeWeekEnding
GO



If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm