CREATE PROCEDURE dbo.pr_CustomForPV ( @VersionID int, @Number int ) AS SELECT CASE WHEN U.SourceFileName IS NOT NULL Then 1 ELSE 0 END AS IsCustom # some joins