Absolutely - just didn't want to spoil the fun!

You did ask for pointers, not the answer. If you want the answer, just say 🙂

10% = *---------

3% = *-------------------------------

how many more "-" do you need to make 10% into 3%

and how much is a "-" worth...

I think...

There was a thread about this a while back where Paul White showed an excellent SQLCLR method http://www.sqlservercentral.com/Forums/FindPost910545.aspx

Ah right I see the problem now...and sorry I don't have an answer to that and I don't have a working Report Server to hand to have dabble...sorry.

Seems like some people don't want help....:-P (joking)

Skip (7/4/2010)

---

I just re-copied your sp and it is working like a charm. For the life of I don't know what I did to mess it up.

The code does...

Very odd - I tested all situations here and it works fine.

Can you post your test script for me?

Hi Skip,

Thanks for posting the code...made life much easier.

I have a stored procedure for you to try...note that I renamed #FPD_Schedule to FPD_Schedule so that the stored proc could update...

You haven't really made it clear what you want to do...I will explain why.

You started by saying that someone sets the priorities, and that they can move an order from...

Hi,

Have you tried querying the ExecutionLog table in the ReportServer database?

Can you explain why you want a cascade on updates? That column references an integer primary key in the person table - surely you will not be updating that key?

This looks like it could be a case of mistaken identity....

Please try this:

select tt.*

from TempBaby.dbo.Admin2_543 tt (nolock)

WHERE

tt.PersonId not IN

(

SELECT SC.PersonId

FROM TempBaby.dbo.SuccessCals AS SC (nolock)

)

No, that is fine.

As...

Ok, I think maybe what you are getting at is "How can I choose a date format that is not available through CONVERT/CAST?"...

Here is a TVF that allows this.

(Written using...