So...do we have a way to report these questions for review? The question is clearly a bad post. We should be given our points.

No where did it state...

I'm curious Kevin,

What would be the advantage to this as opposed to a contained database?

Thanks!

Unfortunately SQL Server authentication does not work with Always-On. The accounts have Security identifiers(SID's) that are unique to each server.

Even if you've created the account on both sides and...

An excellent and interesting questions!

Thanks so much. I've not had an opportunity to actually work with either data type in my career so I did quite a bit of...

Good question although I would disagree with the solution if only for the incorrect terminology used.

Buffer Count (Should be BUFFERCOUNT) is going to exponentially increase the amount of cpu used....

Hi Steve,

Overall; there is a whole lot of wrong with that code. The data you're trying to get can be had with a much simpler solution. You need...

I started answering your question; but then realised the wording of your question has a nifty little logic bomb in it. Sorry you will have to clarify:

"I want that...

I think you're looking for something like this:

SELECT

attendace_date

, staff_id

, working_year

, hours

, COUNT(1)

FROM

staff_attendance

GROUP BY

attendace_date

, staff_id

, working_year

, hours

HAVING

COUNT(1) > 1

;

This is the...