CREATE PROCEDURE Milestone_Get
(@.myID int, @.iShowAll int)
AS
SELECT uid, name, date, registration_confirmed
FROM tbl_members
WHERE
If @.iShowAll = 0
begin
(uid = @.myID) AND (registration_complete = 0)
end
else
begin
(uid = @.myID)
end
GO
Thanks,
davidyou can use a CASE statement but i do not know the syntax..heres another way of doing it
CREATE PROCEDURE Milestone_Get
(@.myID int, @.iShowAll int)
ASif @.iShowAll = 0
SELECT uid, name, date, registration_confirmed FROM tbl_members where uid = @.myID AND registration_complete = 0
else
SELECT uid, name, date, registration_confirmed FROM tbl_members where uid = @.myIDgo
HTH|||Here's an example using a Case
SELECT uid, name, date, registration_confirmed FROM tbl_members
WHERE (uid = @.myID) AND registration_complete = CASE WHEN @.iShowAll = 0 THEN 0 ELSE registration_complete END
No comments:
Post a Comment