August's CompTIA IT Fundamentals course includes 19 hours of basic computer principle modules and prepares you for the certification exam. It's free for Premium Members, Team Accounts, and Qualified Experts!
declare @dateGenerated datetime = '8/26/2014' declare @customizationIds varchar(8000) = '299' declare @isCustomization299Allowed BIT = dbo.IsCustomizationAllowed(299, @customizationIds) declare @isCustomization451Allowed BIT = dbo.IsCustomizationAllowed(451, @customizationIds) declare @isCustomization792Allowed BIT = dbo.IsCustomizationAllowed(792, @customizationIds) declare @isCustomization928Allowed BIT = dbo.IsCustomizationAllowed(928, @customizationIds) select cd.CustomizationId, p.PremiumFinanceLoanId, p.InsurancePolicyId from InsurancePolicy p join CustomData cd on p.InsurancePolicyId = cd.ObjectId where (@isCustomization299Allowed = 1 and cd.CustomizationId = 299 and Name = 'Policy Number Changed' and cd.Value = @dateGenerated) or (@isCustomization451Allowed = 1 and cd.CustomizationId = 451 and Name = 'Policy Number Changed - Generate new NFP') or (@isCustomization792Allowed = 1 and cd.CustomizationId = 792 and Name = 'Policy field Changed - Generate new NFP') or (@isCustomization928Allowed = 1 and cd.CustomizationId = 928 and Name = 'Policy Carrier Changed - Generate new NFP')
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.