Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.
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')
|SQL 2012 Syntax Error||5||24|
|Export data with an insert trigger to a linked server||20||20|
|How to iterate through each record without using cursor||2||22|
|SQL query to summarize items per month||5||24|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
19 Experts available now in Live!