Search results for query: *

Dear Rac2, After much of testing, I came to know that the update statement is always giving @@Rowcount as 1. It was surprising that when the update statement did not update, the @@rowcount was 1. I went ahead and changed the business logic to set version number to null, to help clear out the...

The problem is it is not writting to ERROR_LIST table when the update is not done. Can you help me with the syntax. CREATE TRIGGER SP_A ON dbo.B FOR INSERT, UPDATE AS If UPDATE(STREAM_THROUGHPUT) BEGIN -- Declare variables for error handling DECLARE @ROWCOUNT AS int DECLARE @RETURN AS int...

Dear All, Thanks to all of you for the suggestions. This was very helpful and it solved my problem. Regards, Rajesh

SantaMufasa, I am using Fortran and it does not allow variable characters in its character set which it reads. Hence i will have to use LTRIM and RTRIM. I need to delete that extra space using LTRIM and RTRIM. Yes i used single quotes but it gave me problem with S'burg. In order to overcome...

Can anyone of you kindly help me with the following insert statement. Insert into ESP_MET_DATA VALUES ( 1165,to_date(' 1/1/2001', 'mm/dd/YYYY'),to_date(' 2/1/2001', 'mm/dd/YYYY'), 1,LTRIM(RTRIM(" Greenville-S'burg, South Carolina "))...

Dear All, I have created a package having a stored procedure. I wanted to create a temporary table inside the stored procedure. Can anyone of you help me at the earliest. Regards, CBA321

Dear Jee, Thanks a lot. To be frank and honest with you, I did not or could not understand dynamic sql. So i took an alternative, I built a function and called it from inside the select statement in the trigger. Thank you once again for all the patience and help. Regards, Rajesh

Dear Jee, Can you please help me more with Dynamic SQL as i am not proficient with that and i do not have any idea about it. Regards, Rajesh

Dear All, Platform: Windows 2000, Oracle 8i I am having the following code inside the trigger which is given briefly below, INSERT INTO ESP_MAT_CONST_OUTPUTS ( BEGIN_DATE, END_DATE, SITE_ID, PROCESS_STREAM_ID, MATCHEM_ID, CONSTITUENT_ID, DAILY_AVG_LIQ_SUR_TEMP_TLA...