Thanks, Gail. I think I was just overthinking it.

Bex

Should all the records have an ID of 1? As you are then using that ID to join, as far as I can see, you will have 3 rows...

Eirikur Eiriksson (5/23/2015)

---

Bex (5/22/2015)

---

I have a one-off need to get some XML data into a table

<Persons>

<Person>

<STAFFID>12345678910</STAFFID>

<SURANME>Bloggs</SURNAME>

<FIRSTNAME>Joe</FIRSTNAME>

...

spaghettidba (3/24/2015)

Part of what I'm about to post has already been Said in a Twitter conversation between Brandie, Sioban and myself yesterday. I'm sorry if my frankness is going to...

It looks like your inner join is the issue. If you want all dates, then if you start with that, then left outer join to your other tables, it...

We no longer use Backup Exec but did for a few years, and I know our sys admin was able to stop Backup Exec backing up SQL databases. If...

Thanks Daniel.

I think I was just having one of those "can't see the wood for the trees days."

Appreciate your time and input.

Bex

paul.knibbs (6/20/2014)

---

Trigger, in "Only Fools and Horses", never got Rodney's name right--he always...

You are, of course, in danger of being called Dave 😉

Bex

Did you make sure that the account that is used to run the report (ie the one defined in your connection) has rights to run the sp? I know...

Thank you. Our network guy has been out, but back tomorrow, so I'll ask him to check.

Appreciated!

Bex

Nice solution btw, Chris.

Bex

if you have a comment mark before the last line

eg --) l9 rather than just ) l9

If I comment out the last line, I...

I have an 8.5 if that is any use?

Edit : Just checked, it is the supplied help file

Bex

I'm short on time right now, but if you adapt this to your tables, it should get you what you need

select Table_1.ID, Table_1.name, (sum(Table_1.hours) + sum(Table_2.hours)) as hours

from...