Anyone remember Steve Dassin and his set of stored procedure and functions call RAC? It handled all of these crosstab and hierarchy questions. You pass in the base...

Thank you all,

I've got it down to 13 seconds as it works through about 40M rows of data.

I placed new variables inline and assigned the passed parms to them.

The DBA's...

I'm on it and thanks!

Cheers

Chuck

Thanks this did the trick

Cheers

Chuck

No you're right a person can get notified more than once in a route (1 to X). The business rule really is to route to someone more than once....

It's still returning incorrect rows.

I'm getting rows back where empin = 16975

this routeid should not show up in the resultset

RouteUD SortOrder EmpNum ...

Thank yo again!

I'll give it a go,

chuck

Let me give this a try thank you. I'm not sure it deals with the possibility that @EmpID_In has a sortorder of 1 and a status of Null

Cheers!

Chuck

Great Post Steve,

Love the SPAM!

Cheers

Chuck

BTW RAC rocks

Thanks Scott,

I've got sysadmin rights and no error msg. No file either LOL!

Thanks Scotts but no. I did a search for any pdf or any file created at that itme and nothing. the...

I ran the create table script and then the Create Proc. Then I used the "INSERT" statements in the article. Run the SP2PDF 'filename' and it ran without...