Greatly appreciate your response Jeff, apologies on the delay on mine - stupid busy and haven't had the chance to get back to this, as it was more of a...

Perry Whittle (12/16/2015)

---

This has been possible since sql server 2005...

Determined the cause to be a very peculiar permissions issue on the SAN Manager itself, that was handling the LUNs I for the CSV.

I can't give the exact details for...

My mistake, I was thinking about Failover Cluster Instances >.<

You can configure a Two Node environment with Standard, but you're right - AG is only available with Enterprise.

If I'm not mistaken, 2014 removed the restriction of AG being only available for Enterprise Edition.

So, if we can safely assume you are using SQL Server 2014 (cause you are...

Repeatedly, lol. I think I may have thought of the possible cause, over the weekend - unfortunately my work is sticklers about hours, so I only get to test...

The following test reinforces my belief that there is some conflict on the Disks for the CSV, when the server is coming back online, that I am not able to...

....wth, I just got it to work.

Literally, I spent a good hour yesterday before heading home for the day trying to figure out why this wouldn't work and it just...

Nevyn (6/3/2015)

---

First, stupid question but why does your SQL have < 9 and your expression < 8?

Second, what happens when you replace the null function with a default string like...

Chris Wooding (6/3/2015)

---

I've worked on a similar process; we had to identify clients across multiple 'unique' identifiers who were actually the same person and where some records had more data...

ScottPletcher (6/2/2015)

---

Dougieson (6/2/2015)

---

Hadn't thought of COUNT(DISTINCT CASE WHEN <column_name> > '' THEN <column_name> END) for the count of values within a possible column, I like that!

I was thinking of using...

Hadn't thought of COUNT(DISTINCT CASE WHEN <column_name> > '' THEN <column_name> END) for the count of values within a possible column, I like that!

I was thinking of using MIN &...

webrunner (5/22/2015)

---

Steve Jones - SSC Editor (5/21/2015)

---

Sounds like you have a good idea of what's needed and what's required.

Good luck.

If you want to write up some of this, talk about...

@steve-2 - Oh forgot to add this, there's additional metadata columns for 'When was record entered', 'Who entered record', 'When was record changed', 'Who changed' etc for the...

@steve-2 - I definitely wasn't taking it as any negative commentary. From what I understand the responses for each survey taken will be inserted simultaneously in a single...