This explains the basics: http://bit.ly/1aKPF3N

Everywhere

I agree with Chris, you should try them.

However, you might note that No.1 is using a function so it's not SARGable and No.2 is using LIKE with no wildcards, so...

A change to the function might be needed if the OP wants to include time offsets that don't use full hours as Venezuela which is UTC-04:30.

Not yet, but I wouldn't continue to use them in current or future development.

To know what's happening, we need you to post DDL and sample data in a consumable format (insert into statements). The reason for this is that we can't see what...

What's wrong with you current query? It seems to work as expected. Maybe you're having problems with your WHERE clause, try using some parenthesis.

You're welcome. It was fun when I found numero and thought it was spanish but it was really italian. 😀

If you have any questions on how does it work, feel...

I'd say it depends on what you need because a table can't have 2 primary keys by definition. It's not about SQL Server, it's about relational theory.

I need a 2012 instance at work 😀

Here's an option you could use to create your groups.

;WITH Islands( Account, AStatus, SDate, grouper ) AS

(

SELECT Account,

AStatus,

SDate,

ROW_NUMBER() OVER( ORDER BY SDate) -

ROW_NUMBER() OVER( PARTITION BY AStatus ORDER...

Hi Alessandro,

Thank you for posting your sample data with DDL and insert statements.

This solution might solve your problem, at least it works as expected on the sample data.

WITH CTE AS(

SELECT...

Could you post DDL for the columns involved?

EDIT: I'm asking because data types might perform different one from another and it would end in a wrong solution.

Hi Alex,

I was in a good mood and prepared the sample data, but I might not do it again, it's just to show you how it should be done.

I'm including...

You're very welcome. I hope that you learned something from this and you fully understand how the solution works. Remember to comment the code as you feel necessary to avoid...