Have a look the example below.

create table #EventHeader(

HistoryIDint primary keynot null

,DateTimeHappened datetimenot null

)

create table #EventDetail

(

HistoryIDint

,DetailIDint primary key not null

,DateTimeProcessed datetimenot null

,ProcessedBy varchar(20)not null

)

insert into #EventHeader

select 100001, '2014-07-23...

paul.knibbs (10/15/2014)

---

Maybe the author chose the column name deliberately to catch out people who just run the SQL rather than thinking about their answer? I mean, the error about incorrect...

On occasions when particular managers have said something's urgent my first thought has been 'I'll be the judge of that'. Often a quick phone call has revealed that the...

+1

How did you fix it in the end?

It's a start 🙂 Could you post examples of the data in your tables next please? Have a look at this article

http://www.sqlservercentral.com/articles/Best+Practices/61537/ and it'll show you how. As...

As I've said before, please can you post some sample data. It will make it much easier to see where there might be a problem.

I wish I was. It's not installed on this server and neither can I actually install it. I'm doing this direct into SQL Server Agent.

Will not do or does not do?

Could you post some sample data please? It will make it much easier to establish what's wrong if we've got an idea what...

The owner of the job is me and the job is run by svc_xxxxr2Agent. Both accounts have sa access and datareader and datawriter enabled.

It also seems that it's one...

Hi Imran,

welcome to the forum.

Try joining to the General Ledger Table with a LEFT join. That's only a guess mind you. If you go to the link on...

Singer

It should just be O'Gara, there's quite a few names with Name #D in the list as it turns out.

The good news is it appears it's not a...

Eric M Russell (10/10/2014)

---

Speaking of research studies with questionable cause and effect, I see this type of thing all the time on the morning news shows. Below is a good...

Road