Home » SQL & PL/SQL » SQL & PL/SQL » Help needed
icon9.gif  Help needed [message #218717] Fri, 09 February 2007 09:40
Messages: 6
Registered: February 2007
Location: Leeds
Junior Member
Hi I am new to the forum but really need some help.

A code for a mileage claim usually looks like the the following

9ERP0000435 -- Claim amount
9ERP0000041 -- VAT amount
8ERP0000034 -- Number of miles

But we now have new codes that look like this, without VAT or miles info.

9ERP0000585 -- Claim amount

These new codes are not loaded because the procedure I am working on relies on the number of miles code, to load the whole claim into a temp table. So I need to get these new records to load with out having the VAT record or number of miles. Every thing I have tried has not worked. Could someone help please.

The procedure or main section anyway is attached(sorry its a long one)

[Updated on: Fri, 09 February 2007 09:41]

Report message to a moderator

Previous Topic: Max number of field in table?
Next Topic: Debugging
Goto Forum:

Current Time: Sat Aug 19 04:26:01 CDT 2017

Total time taken to generate the page: 0.02521 seconds