OK just checked. All my jobs are configured to email notification (on failure) + write to windows application log (on failure), no jobs are configured with 'Net Send'?

Many Thanks,

Phil.

Thanks guys, I will re-check.

Phil.

OK, having a blonde moment, what I should have posted was 1 hour 15 minutes = 75 🙂

Many Thanks,

Phil.

Chris poor explanation on my part. If the user enters 8 in the hours field then enters 15 in the minutes field this is recorded as 75:00000.

Phil.

Hello again. So how would the full code read to get 1 Hour 10 minutes?

I have:

LT.Quantity / 60 AS Hours

Many Thanks,

Phil.

Thanks once again, I will take another look.

Kind Regards,

Phil.

Hi again. I followed the last link. I could not decipher how I might add a redirect based on my role based authorization?

Maybe I am missing the point? My rules...

Thanks, just making sure i wasn't confusing you!

I will follow the link and see if I can work it all out.

Many Thanks,

Phil.

Hi John. The data type is NVARCHAR (100). Maybe I will resort back to one search!! 🙂

Many Thanks,

Phil.

Hi John. I tried the following:

WHERE ([ProductId] LIKE '%' + RTrim(IsNull(@ProductId, '')) + '%' OR [CRef] LIKE '%' + RTrim(IsNull(@CRef, '')) + '%')

Same issue. I have to enter values in...

Thanks John, I will give that a try.

Phil.

Hi and once again many thanks. Maybe I have not explained myself properly? I do not have a problem with users authenticating, that side of things works fine. The issue...

Hi and thanks for the reply (not sure what happened to my code there...). I use windows authentication within my connection string to connect to SQL.

Let me try with that...

Thanks for filling me in on that.

Phil.

Hi Kenneth. What do you mean by mod by minutes?

I implemened as:

LT.Quantity / 60 AS Hours

Many Thanks,

Phil.