USE [ETIDB]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER Procedure [dbo].[MCSO_Sheriff_Sale_Details]
@CurrentSale int
AS
SELECT DISTINCT
ISNULL(cast(c.DFirstName as varchar), '') + ' ' + ISNULL(cast(c.DMidName as varchar), '') + ' ' + ISNULL(cast(c.DefendantName as varchar), '') AS SaleName,
ISNULL(cast(s.AppraisedValue as varchar), '') AS AppraisedValue,
ISNULL(cast(s.PropStNo as varchar), '') + ' ' + ISNULL(s.PropStName as varchar), '') + ' ' + ISNULL(s.PropStSfx as varchar), '') + ' ' +
ISNULL(cast(s.City as varchar), '') + ' ' + ISNULL(cast(s.StatePrefix as varchar), '') + ' ' + ISNULL(cast(s.Zip as varchar), '') AS SaleAddress,
ISNULL(cast(c.SaleDT as varchar), '') AS SaleDT,
ISNULL(cast(c.PlaintiffName as varchar), '') AS PlaintiffName,
ISNULL(cast(c.CaseNumber as varchar), '') AS CaseNumber,
ISNULL(cast(c.PAttorneyName as varchar), '') AS PAttorneyName
FROM ETIDB.dbo.CvSales s
LEFT OUTER JOIN ETIDB.dbo.CvCases c
ON (s.YearOf = c.YearOf AND s.Docket = c.Docket)
WHERE c.Docket = @CurrentSale
Open in new window