-- Insert the Details into tblClientProducts
SELECT A.CLIENT_ID, A.CREDITPRODUCTID, cast(A.TERM as nvarchar),
cast(A.OFFERMONTHS as nvarchar),
cast(A.HOLIDAYMONTHS as nvarchar),
cast(A.PPCODE as nvarchar),
cast(A.APR as nvarchar), cast(A.COMMISSION as nvarchar)
FROM viewstgclientproducts A WHERE
A.CLIENTCODE + '*' + A.CREDITPRODUCTCODE + cast(A.TERM as varchar) + '*' + cast(A.OFFERMONTHS as varchar) + '*' + cast(A.HOLIDAYMONTHS as varchar)
NOT IN
(select c.client_code + '*' + d.creditcode + cast(b.term as varchar) + '*' + cast(b.specialoffer as varchar) + '*' + cast(b.paymentholiday as varchar) from tblclientproducts b
INNER join tblipf_clients con b.clientid = c.client_id
INNER join tblipfcreditcodes d on b.creditproductid = d.creditproductid)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment