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 = @userid THEN 1 ELSE 0 END AS DefaultLayout, 
                      GridLayouts.CanPolicy
FROM         GridLayouts LEFT OUTER JOIN
                      UserDefaultGridLayoutTbl ON GridLayouts.FKID = UserDefaultGridLayoutTbl.RefId AND GridLayouts.ID = UserDefaultGridLayoutTbl.LayoutId
WHERE     (GridLayouts.FKID = @FKID)