Many thanks, I will apply it on actual data and let you know if I run into issues.

I will. But as I stated, what it is puzzling is that I can not use two names I want to use yet using TEST or any other name works!...

I wanted to add that I tried TEST, and WEBTEST and the instance configuration takes both of them without an issue! Yet, it does not take the names I want...

The windows cluster is already setup. I am working on setting up the primary node for SQL server.

I do not have access to AD, but I was told that the name of the machine name does exists and using the other name suggested to me does not...

You mean from the cluster manager, in cluster manager I see both node names (machine names) listed but nothing else as no SQL service has been setup. If I use...

Hi - Can you tell how you fixed your issue. I am encountering the same issue while installing SQL 2014 cluster. I never had this issue in past, I have...

Hi - I know this post is old, but I am in process of setting up SQL 2014 with CSV. I read that for the database engine, you need CSV....

I was putting else case SEC1 is null then 'Y'

For whatever reason it was given me error, so I thought I should put something like if SEC1 is null...

Sean, wow so simple! I like to code but sometimes I not thinking logic 🙂 Great, it worked 🙂

THANKS.

Luis - Very sorry to update you, but your query worked great. The null issue was due to bad data which we fixed and had nothing to do with the...

Luis - I will send an updated schema and sample data shortly. Thank you very much.

Question: Now that I changed the actual query, I am running into getting more than 1 record per year for the rows which do not match because of grouping. How...

Luis, Lynn and Wayne, I am very thankful.. With your help, I was able to get the query to working, I appreciate it! 😀

Great, thank you. That is exactly what I was looking for!!! THANKS...