Excellent solution. One small suggestion:
CREATE PROCEDURE dbo.spRef_GetCertifications
(
@activesOnly bit=0
)
AS
SELECT ID, Name, IsActive, SubmittedOnGMT FROM Certification WHERE IsActive >= @activesOnly ORDER BY Name ASC
This way you don't have to pass anything in when you want all. We use this to avoid even creating the parameter in the ADO calling object.
Edited by - RonKyle on 07/23/2003 11:35:02 AM