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)