I typed the function back up this morning, and it now works perfectly. No idea what i did differently, probably a stupid mistake somewhere. The user i'm using...

well, i'm impressed, but it's getting a bit more complicated than i originally had in mind. : /

think it'll be easiest to go with JLK's original solution, but the other...

James: your function worked. i tried to modify it so that it actually could accept a variable number of parameters by passing a single varchar containing all values separated...

Thanks Tomm ...but that's what i was afraid of...

as i said in my original post, i'd rather not use a subselect in my from clause, but if that's the only...

Hi, thanks for your post, sorry about the delay in mine.

i just have two concerns:

1) how would i run this type of function from a query? for example, if...

sure

trainreqs table looks like:

cliet-char(50) type-char(10) grp(int) hrs(int)

-------------------------------------------------

CLI1 type1 ...

screw it. writing this into a single query is taking too much time, so i'm giving up and writing this into a stored procedure that'll create a temp table....

A temp table would probably work, but unfortunately due to restrictions, i can't make one. I'm also working in a single query, not a stored procedure, so i can't...

its actually grabbing information about how far an employee has gotten in their training form both calculated records (based on employee's past shifts) and the information users enter manually...lots of...