v1rt

  |--Compute Scalar(DEFINE:([Expr1004]=ltrim(rtrim(Convert(right(Convert([Loan].[LoanNumber]), 10)))), [Expr1005]=ltrim(rtrim([Loan].[Name])), [Expr1006]=ltrim(rtrim(replace([Loan].[Address1], '|', ''))), [Expr1007]=ltrim(rtrim(replace([Loan].[Address2], '|', ''))), [Expr1008]=ltrim(rtrim(Convert([Loan].[City]))), [Expr1009]=ltrim(rtrim(Convert([Loan].[State]))), [Expr1010]=ltrim(rtrim(Convert([Loan].[Zip]))), [Expr1011]=ltrim(rtrim([Loan].[PreviousNumber])), [Expr1012]=ltrim(rtrim(replace(Convert([Loan].[PIFDate]), ' ', '-'))), [Expr1013]=ltrim(rtrim(replace(Convert([Loan].[AcqDate]), ' ', '-'))), [Expr1014]=ltrim(rtrim([Loan].[AcqFrom])), [Expr1015]=ltrim(rtrim(replace(Convert([Loan].[FilmedDate]), ' ', '-'))), [Expr1016]=ltrim(rtrim([Loan].[FilmInfo])), [Expr1017]=ltrim(rtrim(replace(replace([Loan].[LoanComments], Convert(char(13)+char(10)), '`~'), '|', ''))), [Expr1018]=ltrim(rtrim(replace(Convert([Loan].[LoanDate]), ' ', '-'))), [Expr1019]=ltrim(rtrim(replace(Convert([Loan].[CreateDate]), ' ', '-'))), [Expr1020]=ltrim(rtrim(Convert([Loan].[ProductCode]))), [Expr1021]=ltrim(rtrim(Convert([Loan].[BaseFile]))), [Expr1022]=ltrim(rtrim(Convert([Loan].[BFRecBy]))), [Expr1023]=ltrim(rtrim(replace(Convert([Loan].[BFRecDate]), ' ', '-'))), [Expr1024]=ltrim(rtrim(Convert([Loan].[BaseFileLoc]))), [Expr1025]=ltrim(rtrim(replace(Convert([Loan].[BFLastInv]), ' ', '-'))), [Expr1026]=ltrim(rtrim(Convert([Loan].[BaseCheckOutTo]))), [Expr1027]=ltrim(rtrim(replace(Convert([Loan].[BaseCheckOutDate]), ' ', '-'))), [Expr1028]=ltrim(rtrim(Convert([Loan].[BaseCheckOutBy]))), [Expr1029]=ltrim(rtrim(Convert([Loan].[BaseNoCheckOut]))), [Expr1030]=ltrim(rtrim(Convert([Loan].[BoxNoBaseFile]))), [Expr1031]=ltrim(rtrim(Convert([Loan].[Wallet]))), [Expr1032]=ltrim(rtrim(Convert([Loan].[WRecBy]))), [Expr1033]=ltrim(rtrim(replace(Convert([Loan].[WRecDate]), ' ', '-'))), [Expr1034]=ltrim(rtrim(Convert([Loan].[WalletLoc]))), [Expr1035]=ltrim(rtrim(replace(Convert([Loan].[WLastInv]), ' ', '-'))), [Expr1036]=ltrim(rtrim(Convert([Loan].[WalletCheckOutTo]))), [Expr1037]=ltrim(rtrim(replace(Convert([Loan].[WalletCheckOutDate]), ' ', '-'))), [Expr1038]=ltrim(rtrim(Convert([Loan].[WalletCheckOutBy]))), [Expr1039]=ltrim(rtrim(Convert([Loan].[DOTRecBy]))), [Expr1040]=ltrim(rtrim(replace(Convert([Loan].[DOTRecDate]), ' ', '-'))), [Expr1041]=ltrim(rtrim(Convert([Loan].[NoteRecBy]))), [Expr1042]=ltrim(rtrim(replace(Convert([Loan].[NoteRecDate]), ' ', '-'))), [Expr1043]=ltrim(rtrim(Convert([Loan].[TPolRecBy]))), [Expr1044]=ltrim(rtrim(replace(Convert([Loan].[TPolRecDate]), ' ', '-'))), [Expr1045]=ltrim(rtrim(Convert([Loan].[COTRecBy]))), [Expr1046]=ltrim(rtrim(replace(Convert([Loan].[COTRecDate]), ' ', '-'))), [Expr1047]=ltrim(rtrim(replace(Convert([Loan].[TitleElimDate]), ' ', '-'))), [Expr1048]=ltrim(rtrim(Convert([Loan].[FinCenter]))), [Expr1049]=ltrim(rtrim(Convert([Loan].[CLPC])))))
       |--Nested Loops(Left Anti Semi Join, WHERE:([Loan].[LoanNumber]=[Loan].[LoanNumber]))
            |--Clustered Index Scan(OBJECT:([RMSii].[dbo].[Loan].[Loan_LoanKey_U_Cidx]), WHERE:(([Loan].[PIFDate]=NULL OR datediff(year, Convert([Loan].[PIFDate]), getdate())<7) AND like([Loan].[LoanNumber], '000%', NULL)))
            |--Table Spool
                 |--Clustered Index Scan(OBJECT:([RMSii].[dbo].[Loan].[Loan_LoanKey_U_Cidx]), WHERE:(((((((((([Loan].[LoanDate]=NULL AND [Loan].[CreateDate]=NULL) AND ([Loan].[PIFDate]=NULL OR datediff(year, Convert([Loan].[PIFDate]), getdate())<7)) AND like([Loan].[LoanNumber], '000%', NULL)) AND [Loan].[Name]=NULL) AND [Loan].[BaseFile]=NULL) AND [Loan].[DOTRecBy]=NULL) AND [Loan].[BoxNoBaseFile]=NULL) AND [Loan].[LoanComments]=NULL) AND [Loan].[NoteRecBy]=NULL) AND [Loan].[TPolRecBy]=NULL))