I have a table Revision with 3 fields JobID, RevisionDate and
1. I'd like to get all records for a particular JobID. I can do it by this
CREATE PROCEDURE CoordinatorRevisions
SELECT TOP 100 PERCENT RevisionDate, RevisionNumber
WHERE (JobID = CurrentJob)
ORDER BY RevisionDate
2. I also would like to return the string containing # plus RevisionNumber
plus space plus RevisionDate. RevisionDate and RevisionNumber from the last
record of the previous Select statement.
I have a problem with syntax for SP.
I know that I have to declare output parameter, but how ...