Great thanks tommy

thanks a lot for ur valuable ideas.

DECLARE @PVC_LOGIN_USERVARCHAR(40),

@PVC_APPLICATION_IDVARCHAR(40),--yet to finish

@PVC_PROGRAM_NAMEVARCHAR(40),

@PI_RET_STATUSINT,

@PVC_RET_MSGVARCHAR(500),

@PI_RET_ERRORNUMINT,

@PVC_APPLICATION_NAMEVARCHAR(50), @pvc_dest int;

my declaration is mentioned above

Great!!!!!!!!!!!!!... Working fine... Thanks chris....Thanks a lot...

create table trp_table (from_date varchar(15),to_date varchar(15))

insert into trp_table(from_date,to_date)

select CONVERT(VARCHAR(11), LTRIM(RTRIM('01-JUL-2010')), 106), CONVERT(VARCHAR(11), LTRIM(RTRIM('22-JUL-2010')))

UNION ALL

SELECT CONVERT(VARCHAR(11), LTRIM(RTRIM('15-JUL-2010')), 106), CONVERT(VARCHAR(11), LTRIM(RTRIM('20-JUL-2010')))

UNION ALL

SELECT CONVERT(VARCHAR(11), LTRIM(RTRIM('11-FEB-2010')), 106), CONVERT(VARCHAR(11), LTRIM(RTRIM('27-JUL-2010')))

DECLARE @lb_error_flag BIT

SELECT...

then how to convert a varchar type variable into datetime type?..

hai chris..

both are varchar types.... specification is like tht where i cant change that as datetime data type...

ya...i implemented this... works fine... Thanks chris...otherwise i wud have done an ugly coding.. thanks gail shaw

oh....Thanks a lot.... thanks Chris and gail....

how it possible?...

UPDATE GL_CALENDAR_LINES

SET CAL_HEADER_ID = @PVC_CALENDAR_HEADER_ID,

PERIOD_NAME = @lvc_period_name, FROM_DATE =...

GilaMonster (10/20/2010)

---

What do you mean by 'call a cursor'? A cursor isn't an object that you call, it's an object that you declare, use and then deallocate.

Why do you want...

Thanks a lot Gail......

GilaMonster (10/16/2010)

---

@@RowCount ALWAYS takes the row count of the last statement executed. For the second @@rowcount, that will be either the update (if it runs) or the IF.

What do you...

http://support.microsoft.com/kb/139444

refer the above link... 😉

Thanks Lowell!!!!