Hi Jeff, yes to confirm the first link was me searching in SSC for "Pseudo Cursor" and that came back with a very easy to understand definition...

thanks

Hi Lynn, I do use CTEs, but i've never specified the column names in that way... i just normally go "with myCTE as (select col1,col2 from tab1)". is this bad...

Wow! thanks for the help Lynn, Jeff.

just going through the code now... what is the use of (n) after the cte name or after a table name?

Lutz, i will try to follow your steps in details tomorrow...

Jeff, i don't need an EndDate and rather than a total NumberOfPeriods i would need to see the period details...

hi dwain.

it didn't quite do the job for some records such as 'STI850-200 ' or '25-53492-22 ' where it drops the first digit...

very close to Lynn's results however.

thanks guys

Perfect! Many Thanks Lynn

YOU'RE A STAR!!!

thanks lynn, but that is still removing zeros from alpha-numeric fields...

e.g.

for '012GR3NL' your code would return '12GR3NL'

rgrds

paul

thanks rob, this has certainly improved the results and helped with the leading zeros. the samples i provided where just a test. the actual data holds fields up to 18...

Thanks Kashif,

I will keep that option available as i develop new packages.

Currently however, I've set the individual packages within a project as individual steps in a a job.

It kind of...