Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.
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
|How to update a sql 2012 database table with the time difference from 2 time frames in vb.net 2010||4||67|
|Word Template Mail merge with vb.net||4||40|
|C# Error - Add Failed||12||52|
|What are the Important skill to have as Asp.net Developer||8||27|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
12 Experts available now in Live!