Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users
CREATE PROCEDURE Coll2014_FindResidentForRegistration -- Add the parameters for the stored procedure here @FName char(35), @LName char(30), @BDate char(10), @SSNum char(4) AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; -- Insert statements for procedure here select OccuSeqNo,RTRIM(a.propertyid)+'-'+RTRIM(a.BldgId)+'-'+RTRIM(a.unitid)+'-'+rtrim(a.resiid) as fullid, b.status,b.ListedDate,b.OriginalAmt from TAG_eSite.dbo.occupantheader a right outer join CollectionSystem.dbo.Collection_Master as b on RTRIM(a.propertyid)+'-'+RTRIM(a.BldgId)+'-'+RTRIM(a.unitid)+'-'+rtrim(a.resiid) = b.fullid where OccuLastName = @FName and OccuFirstName = @LName and Birthdate=@Bdate and RIGHT(OccuSSN,4)=@SSNum END
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.