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