Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!
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.
|SQL Server 2014 Express vs Full - Service Pack question||5||47|
|Create a Calendar table||29||43|
|SQL Server Pivot||5||39|
|SSRS Deployed Reports Throws Not Supported in Edition of Reporting Services||12||15|
Join the community of 500,000 technology professionals and ask your questions.