Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now
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.
|ASP.NET Calendar Control||5||54|
|Adding where clause to entity statement c#||1||63|
|Error building VS2105 solution from repository||1||60|
|VB.Net Developer - Suggestions for Web Programming OnLine Learning||4||60|
Join the community of 500,000 technology professionals and ask your questions.