Thanks ur code seems to work perfectly with the suggested modifications.

Thanks a lot....

Hi Kelly,

We use PB for the front end application. Connection is done thru the Transaction Object. Please let me know if u have any suggestions.

Thanks

shobha

Hi, Thanks

This is the code..

CREATE PROCEDURE CFR_NES_UNIT_CAT (@ST_DT DATETIME, @END_DT DATETIME)

AS

declare

@rqtp_cd varchar(5),

@unit_id int,

@rc_tot_clsd int,

@row_cnt int,

@rc_tot_opnd int,

@rc_tot_clsd_og int,

@rc_tot_opnd_og int

/****** PICKS UP CLOSED NOTES ROW FROM CTCTRQSH & CTCTRQST TABLE ******/

/****** AND...

Hi, Thanks

This is the code..

CREATE PROCEDURE CFR_NES_UNIT_CAT (@ST_DT DATETIME, @END_DT DATETIME)

AS

declare

@rqtp_cd varchar(5),

@unit_id int,

@rc_tot_clsd int,

@row_cnt int,

@rc_tot_opnd int,

@rc_tot_clsd_og int,

@rc_tot_opnd_og int

/****** PICKS UP CLOSED NOTES ROW FROM CTCTRQSH & CTCTRQST TABLE ******/

/****** AND...