Hey Ian,

thanks for the reply..

i can't test it till tommorow coz my i am off from work today..

Well just would like to ask.. the thing is i'm working on a...

sorry for the inconvinience..

i guess i will look into this myself again ..

will hit u back when i have any probs

thanks chirag,

u have been really helpfull much appreciated.

regards,

...

CREATE PROCEDURE bpm.kelulusandup as

DECLARE @empskill2 VARCHAR(200)

SET @empskill2 = ''

DECLARE @empskill3 VARCHAR(100)

SET @empskill3 = ''

DECLARE @empskill4 VARCHAR(100)

SET @empskill4 = ''

DECLARE @empskill5 VARCHAR(100)

SET @empskill5 = ''

Declare @Next int

Set...

dear chirag,

i totally agree on your comments.. unfortunately there ain't anyone around to guide me where everyone is just being so busy with their owns.....

Dear chirag..

for the while... how do i determine the last record for employee_id

while uv_employee_id = .....

1) does sql 2000 has a function to determine the end of record set?

ooh...

dear chirag,

thank u sir.. this works fine now.. minor alterations here and there got this script working

i have modified n reused the codes to group the concatenation as such

DECLARE @empskill2...

the error message after executing query below is .. This designer does not graphically support the DECLARE CURSOR SQL construct. Is it becoz i m using sql2000?

DECLARE @empskill2 VARCHAR(100)

SET...

hey Craig,

thanks for the reply to my query..

i guess it is working..

this is the code i m looking at rite now..

DECLARE @empskill2 VARCHAR(100)

SET ...