Hi Chris, I am using the solution you gave me a few weeks ago as base for my next query, can you look over please and see if there is...

Gail thank you, I feel like I move forward in leaps and bounds after mastering certain .net code that I once struggled with to realize that maybe I didn't move...

I understand debugging would be hard, but seeing as I am the only person doing the changes and ensure backups and such are carried out first before I deploy this...

That was a snippet of code just around that method, I have error checking/ignoring method further up the code for connection. Although I really appreciate your help telling me to...

Its the only way I know how at present, and it works. What is a better way

Thanks Gail

That is totally embarrassing 🙁 sorry.

I do have a check like this:

try

{

...

Hi Micheal, I did test it and it worked but wanted to understand how it was working

Thanks

J

Hi Sean, am I being dumb? I cant see how it matches the year ?

When everything else fails I will ask you guys. This has been annoying me for weeks now and although I can get my c# code to complete the task at...

The amount off calls raiesed by an operator, so I thought counting the ID would give me this which it does, but I want the operator with the most calls...

It has a time stamp also and the cast gave me the error

Operand type clash: date is incompatible with int

SELECT *from SLADB.dbo.DocketTB

where Docket_EngFinish >=dateadd(d,datediff(d,0, getdate()),-1) AND Docket_EngFinish<dateadd(d,datediff(d,0, getdate()),0)

This works, is there a better way ?

Thanks again Chris 🙂

Operand type clash: date is incompatible with int

Is it the time thats causing the problem ?

where Docket_Date = DATEADD(d,DATEDIFF(d,0,GETDATE()),0)-1

Hi John, Dockets that are 2months old, so 2months from today ?