Thank you for your guidance. I  went out of town and wanted to work on queries. I traveled light  so didn’t take my laptop.  With what you said, I probably...

Thank you for your responses,  And thank you for not beating me up for not having a proper backup.   Lesson learned!!!

Have a Happy Thanksgiving.

Carroll

Thank you. Mark.  That was exactly what I was looking for.  I really did try googling it, but sometimes you have to know how to ask the quesstion.

Blessings,

Carroll

I am using right click on database, tasks, import flat file wizard.  Since I wrote the question, I have been looking for alternatives and now am using import databases.  I...

Just a second or two.  One of the changes I made was instead of pulling all records, I just pull the top 50.  Thanks again.

Thank you for your help.  I tweaked it a bit and it's working fine.

I'll be out of town this weekend, but it looks promising.  Thanks

>Take TankDate 1/1/2021 as an example. There are 6 rows, with DrainSeq ranging from 1 to 6. Does that mean that the master tank was drained 6 times on 1/1/2021?

Yes ...

Select Top 1 @AlphaCounter as Tank,@seqnbr as CurSeqNbr,DrainSeq as Last_Seq_Nbr,@seqnbr-DrainSeq as Varcount
from Tankcount
Where @alphacounter in (Tank01, Tank02, Tank03, Tank04, Tank05, Tank06, Tank07, Tank08, Tank09, Tank10)
and @seqnbr-DrainSeq >...

Thank you all for answering my post.  I have to work on another problem now and cannot provide you with more information at this time.  I will get back on...

OK, so I ran Ken McKelvey's solutions and it seems to be working so far.  I also upgraded the machine memory to 16 Gig.

I want to thank you for not...

Thank you!  I ran it and it seems to be working.

Microsoft SQL Server 2017 (RTM) - 14.0.1000.169 (X64) Aug 22 2017 17:04:49 Copyright (C) 2017 Microsoft Corporation Developer Edition (64-bit) on Windows 10 Pro 10.0 <X64> (Build 19042: )

I really...

Sorry that I responded back to the email letting me know that you answered me.  Here is my response.

Thank you for your message and not flaming me. All I am...

Thank you Pietlinden!!!  That is exactly what I was looking for.  I tried to use partition but didn't have the rest of it.  It is going in my code file.

Below...