Jay_Noob (12/10/2009)

---

If you only want to match the On_site to apptdate on the DAY then you need to scrub off the time from both the date time fields. If...

How can I link the 2 tables together to show each Appointment with the appropriate PDA activity?

Its baffling me :w00t:

Thanks for the help and advice over this subject. I have since found that what I was wanting to should really be done through replication

Ive test that and have it...

This was done on the on the Mirror...

Yes

I have done that and this is what it said afterwards

Event Type:Error

Event Source:MSSQLSERVER

Event Category:(2)

Event ID:1474

Date:02/12/2009

Time:21:24:21

User:N/A

Computer:MyServerName

Description:

Database mirroring connection error 4 'An error occurred while receiving data: '10054(An existing connection was forcibly...

I've just been reading that link posted a bit further,

If I want to quiery from a NORECOVERY database then it wont work as it will be in a locked...

They are internal VM machines no internet connections apart from internal ones, would that still need a firewall? if so then I'll check with my IT dept and find that...

By using this SQL I had done with your help, it seemed to be fine until I been looking at some data closer, I have found that the Appt3Outcome doesnt...

Thanks for that, much simpler SQL...

I have a problem with the 3rd SQL, all the lines like this dont add the correct amount

SUM(CASE WHEN [Month] = 4 AND [Year] =...

Excellent, thanks for this it works a treat 😀

I just need to understand how you have done it now :hehe:

Thanks again

Thanks for this 🙂

I've had a look at and tried to run it. I get an error

Msg 4104, Level 16, State 1, Line 1

The multi-part identifier "cteSQL1.April" could not be...

Find attached sample data using this query

If you look at the prop_seql 60571 as an example you will see the dates of

2009-09-15 14:34:00 and 2008-11-18 14:23:00

In my original SQL...

Attached is a copy of the tables, I will get some sample data shortly

I've had a look now at what you suggested and have now got a picture of Appts 🙂

Thanks for all the help, we eventually got there 😀

Can you recomend...