This month’s featured course covers 16 hours of training in installation, management, and deployment of VMware vSphere virtualization environments. It's free for Premium Members, Team Accounts, and Qualified Experts!
CREATE PROCEDURE dbo.usp_SEL_CL_Net_GetMortgageInformation @PolicyID AS VARCHAR(15), @InceptionDate AS SMALLDATETIME, @PostDate as DATETIME AS Select [MortgageeID] AS 'Mortgagee Number', [Name] AS 'Mortagee Name', 'Address' = CASE WHEN [Address2] = '' THEN [Address1] + ' \r ' + [City] + ', ' + [State] + '. ' + [ZipCode] ELSE [Address1] + ' \r ' + [Address2] + ' \r ' + [City] + ', ' + [State] + '. ' + [ZipCode] END, [LoanID] AS 'Loan Number' From PlMortgage WITH (NOLOCK) Where PolicyID = @PolicyID And InceptionDate = @InceptionDate And PostDate = @PostDate Order by MortgageeID GO
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.