Why are you using COUNT()? From what you've said it looks like you want SUM()?

Could you create a calendar table (lots of examples online), then use that the get the 'days vacant' number by month?

Kyrilluk (5/9/2016)

---

call.copse (5/9/2016)

---

@Kyrilluk

That's not really the spirit is it now? I'd imagine the majority of us here will avoid meeting folk when we don't have to but I often agree...

girishpillai (5/6/2016)

---

The facts about the Cloud paradigm and Azure are correct and the truth. since you don't have a proper response you can choose to call it arrogant - but...

girishpillai (5/6/2016)

---

I think this is the old way of thinking. In a Cloud world you "SHOULD NEVER" have to think about the underlying hardware. With all of the capabilities current...

I've had quite a few friends use it to get around Europe and not heard any horror stories. I'd definitely give it a go if I found it cut the...

Used to use a marketing suite with some very unhelpful error messages. It used NSQL IIRC, and many of the errors were along the lines of "Error: No error".

I do...

Luis Cazares (4/28/2016)

---

tindog (4/28/2016)

---

Did the queries Luis provided not work? What happened?

An alternative would be to change your parameters to DATE instead of DATETIME, then use BETWEEN as you have...

Did the queries Luis provided not work? What happened?

An alternative would be to change your parameters to DATE instead of DATETIME, then use BETWEEN as you have (without the TIME...

Thanks for the words of encouragement everyone...the thought still terrifies me but I'll look at other events and see if I can work up the courage to go 😀

I'd love to go to this, but have no SQL-y friends and get v anxious in unfamiliar places where I don't know anyone! (Never been to Liverpool)

I'll have to change...

What type of replication is it? Transactional, merge etc? What sort of job is it?

You can configure replication to run a script after a snapshot is applied - to...

Can you get the string value out for your dynamic connection and share it here?

Does the package fail if you hardcode the "FileName" variable using your tested file?

Lynn Pettis (4/11/2016)

---

tindog (4/11/2016)

---

TomThomson (4/8/2016)

---

I don't know how accurate it is for the USA, because I've never tried to live there - and short...

What does the output of your dataset look like? (And perhaps share the query in case the issue can be resolved there)

What are you currently grouping by (first name I'd...