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)