Hi R P Rozema,

Thanks for your input, it too is a very tidy solution & I appreciate the time you took to create it.

Cheers

Thanks you ALL very much for your assistance & Hugo for the answer.

Much appreciated !!

Peter

Hello Hugo,

Thank you very much for your answer!

I entered a large dataset of my info & got a very good summary of the results.

I'm not quite across your logic about...

Hi Again,

Here are my scripts to create the data;

CREATE TABLE PatternTest

(

[PersonID] int,

[Action] varchar(50),

[RankID] int

);

-------------------------------------------------------------------------

INSERT INTO [Test_DB].[dbo].[PatternTest]

([PersonID]

,[Action]

,[RankID])

VALUES ...

Thanks to all & apologies for the delay.

I have checked the responses as I received email alerts & fully intended to post a DDL script & my thanks to you...

Hi Forum,

I have found an Excel VBA solution as an example of what I need.

It's a function that uses some strings of what I want to find & Counts them.

Does...

Thanks Hugo,

I'm just looking for the logic to count patterns of action in a sequence.

If you're not aware of any, then thanks for your contribution.

I'm thinking someone has come across...

Thanks for the response,

Unfortunately the data is what it is, & not an error.

I'm trying to count patterns of behavior, so those Actions can change.

Currently, I'm working on four Actions...

Thanks Jeff.

Thanks John,

I now understand the logic which is the sum total using Bitcode being unique, thanks.

The other requirement is that the Actions must be in the same Order.

Can your code...

Hi Again John,

I have used prime numbers before to come up with this solution but haven't explored the Bitcode method.

What I mean is I had a task where I named...

Hi John Mitchell,

Thank you!

I've used that logic before but had forgotten about it.

I think you've answered my question, I'll give your code a try.

Thanks again!

Peter

Thanks again Eirikur, this is perfect!

Also appreciate the advice from John & Luis.

Peter

Hi Eirikur,

Thanks!

This works well & creates a table as I wanted.

I wonder if you can advise how to get the date to be a part of the tablename for the...

Thanks for your reply,

The key word here is append.

I have the 2 tables 3 Fields with the same name in each but the main table has other columns.

I simply want...