Hugo Kornelis (2/3/2016)

---

So you want to add a generated column that can be combined with the Year column to become a composite candidate key? Okay.

"How do I do this in...

Hi, Thank you for your reply.

I want the YearID second key to be auto-increment depending on the year of the project, if the project is for 2015, the YearID will...

Luis Cazares (1/20/2016)

---

Just an advice, this should perform better than the UNION ALL approach and give the same results.

set @query = 'SELECT EmployeeID

,AttType

,' + @cols + '

from

(

selectEmployeeID

,AttType

,AttTime

...

Thanks you for this, I will try this approach on my other reports, the above union all worked out for me. Thank you so much for the help.

It seems that my main question plus a lot more has been answered, thank you for saving me time. We are now testing the failover scenarios and adding the parameter...

Noted with thanks on that one. I have now implemented mirroring without automatic failover. But now, I should do an automatic failover because this is what was required, Assuming the...

As for the third database server, can I just use the mirror as a witness also? Should the witness be installed on a different instance?

Thank You, I will look into this solution and try my best to understand and implement it on my scenario.