set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[GetPrintLayouts] ( @FKID int, @NoSort bit, @UserId int ) AS if @NoSort=0 SELECT PrintLayouts.ID, PrintLayouts.LayoutName, CASE WHEN UserId IS NULL THEN 0 ELSE 1 END AS DefaultLayout, PrintLayouts.PrimaryLayout FROM PrintLayouts LEFT OUTER JOIN (SELECT LayoutId, UserId, RefId FROM UserDefaultPrintLayoutTbl AS UserDefaultPrintLayoutTbl_1 WHERE (UserId = @userid)) AS derivedtbl_1 ON PrintLayouts.FKID = derivedtbl_1.RefId AND PrintLayouts.ID = derivedtbl_1.LayoutId WHERE (PrintLayouts.FKID = @FKID) ORDER BY DefaultLayout DESC, PrintLayouts.ID else SELECT PrintLayouts.ID, PrintLayouts.LayoutName, CASE WHEN UserId = @userid THEN 1 ELSE 0 END AS DefaultLayout, PrintLayouts.PrimaryLayout FROM PrintLayouts LEFT OUTER JOIN (SELECT LayoutId, UserId, RefId FROM UserDefaultPrintLayoutTbl AS UserDefaultPrintLayoutTbl_1 WHERE (UserId = @userid)) AS derivedtbl_1 ON PrintLayouts.FKID = derivedtbl_1.RefId AND PrintLayouts.ID = derivedtbl_1.LayoutId WHERE (PrintLayouts.FKID = @FKID) ORDER BY PrintLayouts.ID