The with statement is something I've never used before. What a great way to create a quick subset to use in other queries. I think this does it...

It does matter if they went active and inactive on the same day. If the order on that day was active at 10:00am and then inactive at 12:00pm, then...

Thanks for your quick response.... Here is the code to create the table and sample data

CREATE TABLE [dbo].[account_DeactivationReactivationHistory](

[ID] [bigint] IDENTITY(1,1) NOT NULL,

[account_id] [int] NOT NULL,

[Active] [bit] NOT NULL,

[status_date] [datetime] NOT...

Not exactly... what I need is to be able to pass a date range and account id to a function and it return to me if that account id was...