something is still off. None of the result show a followup with a NULL completed date.

I'm running all this from a sub query, not sure how that would matter, but...

THANK YOU!

I've bookmarked that site, thank you

David92595

Sorry, my spacing\formatting got removed...hope this is a little better.

CREATE TABLE [dbo].[tblOrderBillingSteps](

[OrderBillingStepID] [int] IDENTITY(1,1) NOT NULL,

[lngOrderID] [int] NULL,

[lngBillingStepID] [int] NULL,

[lngSubBillingStepID] [int] NULL,

CONSTRAINT [PK_OrderBillingSteps] PRIMARY KEY CLUSTERED

INSERT INTO tblOrderBillingStepsVALUES...

Thank your for that clarification. You may have just made my case to upgrade to 2016 🙂

David92595

I just took a job for a small company that holds NPI (non public information), but due to client requirements I have to treat it as SSN's. I'll write...