set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go






ALTER PROCEDURE [dbo].[GetGridLayouts]
    (
	@FKID int,
@userId int
	)

AS
SELECT     GridLayouts.ID, GridLayouts.LayoutName, GridLayouts.PrimaryLayout, CASE WHEN userid IS NULL THEN 0 ELSE 1 END AS DefaultLayout, 
                      GridLayouts.CanPolicy
FROM         GridLayouts LEFT OUTER JOIN
                          (SELECT     LayoutId, UserId, RefId
                             FROM         UserDefaultGridLayoutTbl AS UserDefaultGridLayoutTbl_1
                             WHERE     (UserId = @userid)) AS derivedtbl_1 ON GridLayouts.FKID = derivedtbl_1.RefId AND GridLayouts.ID = derivedtbl_1.LayoutId
WHERE     (GridLayouts.FKID = @FKID)