We had 80 odd people at the show in September so a whole pig could well be worth it. I've just got to convince a couple of people that...

Ed Wagner (10/22/2014)

---

BWFC (10/22/2014)

---

When I worked in Caorle,...

When I worked in Caorle, not far from...

Luis, that second version works like a charm. Thank you.

The answer is wrong again! As usual, I read the question and decided what my answer would be. I then ran the query and confirmed my answer only to...

Stuart Davies (10/15/2014)

---

Possibly, in the cases when I posed a question then found...

I seem to have solved the problem but it has raised more questions than it's answered.

It appears that it wasn't necessarily anything to do with the Job I was running....

Am I being cynical in thinking that 'cracked it' means 'can't be bothered to provide sample data'?

http://www.sqlservercentral.com/Forums/FindPost1625755.aspx

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.