Thanks for your quick reply John,

Unfortunately that did not yield a result.

However, I tried something else.

SELECT
T.QTY,
T.CustomerID, 
T.ActivityID,
T.RelatedReferenceID, 
T.[Due Date], 
T.[RecordStarted],
T.[TableSummary], 
T.[TableType], 
T.[Team Member], 
T.[TableStatus]
FROM (
SELECT
S.*
, ROW_NUMBER() OVER...

Matt - Thanks you for this.  It's brilliant.  It's a nice and simple solution!

Matt - Thanks for this tip.  It appears to offer similar results to alternative methods and is a lot simpler to use.

I'm curious about how to add additional information into...

• This reply was modified 5 years, 6 months ago by  barry.nielson.

Hi all, And thanks so far for all your help. It is much appreciated.

However, nothing I try works to produce a result.  Clearly the issue lies in my not understanding...

Thanks for your help and effort to code this.

I've run this and it seems to work beautifully.  There's no chance I would have figure out this so thanks a lot.

Thanks you both for your input.

I did a little reading and came up with this modification:

USE [MyDB]
GO
OPEN SYMMETRIC KEY EncryptPIIKEY
DECRYPTION BY CERTIFICATE EncryptPIICert
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE...

• This reply was modified 5 years, 7 months ago by  barry.nielson.
• This reply was modified 5 years, 7 months ago by  barry.nielson.
• This reply was modified 5 years, 7 months ago by  barry.nielson.

Thank you for your response.

I'm sorry to say this method seems more complicated that my original script.  I tried testing it and ended up with the error: Must declare the...

Hi Grant,

Thanks for the advice.  My organisation keeps a dedicated SQL server someplace and I have been advised there is a possibility of it falling over from time...

Thanks Pietlinden

So seems like you know my issue.  Can you point me to a technical solution?

I use a number of SP's and views.  I may have...

The entire dataset is less than 2GB in size and if it were bigger I'd split the tables into two.  Rght now, it's not that big.

I just don't...

Thank you.  Yes, I know the benefit of SP's and this will be helpful.

This issues will be fa more complicated than just this little snippet and many problems...

Hi Drew,

Gee, thanks so much for the effort here.  Much appreciated.

I am using SQL 2008 server.  not sure if that means very much but i am...

Ok great.  Thanks for the updated description.The logic sounds wonderful and sure I'd be more than willing to push for a better solution than the one we use. 

it's a little complex but this is a set of records that maintain customer balances with us. Each day the record remain the same until such a day as the...