Great! Thanks a lot. 😀

Thanks alot that did it.

Yes I am.

Would you know why I cannot see the sysdtspackagelog table? If I run the following command:

SELECT *

FROM sysdtspackagelog

I get a empty recordset back. I am using the SQL...

After some exhaustive anaysis on the underlying data, I found that it was a data issue. Once I fixed that, these procs worked just fine. I would like to thank...

Can someone please help me on this?

That is totally correct. I implemented the CASE statement and now I lost all the repromote flags.

Correct,it for a report.

Another though maybe this is a place for some sort of CASE statement like:

CASE Repflag =

WHEN RepFlag = (Select Repflag From #Temp WHere r.ConsultantID = d.COnsultantID )...

I need to display the dates displayed in this format but they will not used for calculations.

Can we do something along these lines although my logic is not right but may be it will help clarify what I am after (See Bold):

Select 'OrigConsID' = @ConsultantID

,(Select ConsultantName...

Yes I tried that code and the works fantastically in the Repromote Proc. I think the issue lies in the fact that in the Main proc, its not joined properly...

This works great,thanks.

yes, everything from table d needs to come across. Maybe I don't need the LeftOuter Join to the #temp table but it was what I thought would work because that...

I think I found the issue, it is not the repromote procedure its in the main proc (See bold). I think it needs to be changed because it is looking...