[font="Courier New"]Hi,

Have added some cursor coding fo my requirement.. Need some help in adding functionality (using PATINDEX) to this code below:

CREATE TABLE STAFF_CODE

( CASE_NO VARCHAR(11),

ACCT_NO VARCHAR(19),

TSE_CODE...

[font="Courier New"]Hi All,

Here's the coding that i've done (attached to this post). Apologies for uploading the code in scanned format.

Need to fix up the coding for the cursor (PENDING part...

Hi,

This package runs and updates / refreshes the cube stored in the Server. Initially, certain data files which are required are stored and loaded into the local database and processed,...