Thank you very much Phil. I am testing some more code for additions to my tables. will keep you post.

Thank you a Ton Phil.

Tried this below code but no luck 🙁

Can somebody please help. Thank you in advance

SELECT 
Dataval,
    CASE 
      ...

I tried and generated code this far.

SELECT Comment,
       (CASE WHEN Comment LIKE '%[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]%'
        ...

Thank you both. Appreciate your help

Thank you very much Ed B.

just to clarify

for the question about population, below query returns no of records per day. so here I would like to check the current day counts to previous day record...

Thank you @pietlinden,, Can you pleaseprovide complete query?

Thank you

ASiti

Thank you Steve,

The date calculation is, only consider the customers after accountJoinDate Month (in Customers)  table. for example a new customer #107 joined in May 2022, and had first order...

Hello Zeff Afternoon,

Apologize, here is the code i executed and tested.

CREATE TABLE Customers (
    CID int NOT NULL PRIMARY KEY,
    GroupName...

Thank you Phil, I will follow your guidelines to help helpers easy to help me.

Thank you Again

Thank you for your response,

i tried your sample, it is showing two rows i mean each row is showing twice (because of plan name)please see below

ActNoPlanName(No column name)

100Keeper2

101Keeper1

101Valuer1

102Valuer2

103Keeper2

104Keeper1

104Valuer1

105Keeper1

105Valuer1

106Valuer1

110Keeper1

here...