The number of times...

If I understand your requirements correctly, something like this should work

First create some data

DECLARE @StartDate date = '2020-04-01'
      , @EndDate  ...

According to your table structure, there is no index on [MULE_BATCH_ID].  This means that SQL has to do a table scan to find the record.

You are doing a select *,...

Firstly, you cannot compare anything to null.  Run this code as proof.

IF ( NULL > NULL ) PRINT 'NULL > NULL' ELSE PRINT 'CANNOT COMPARE NULL >...

Without anything to test against, I would guess at a solution similar to this

WITH cteMaxTime AS (
  SELECT      pr.plan_id, maxTime =...

Neither your example data nor requirements mentioned continent.  If you don't come right, then come back with sample data that represents both continent and country, and show us what you...

The following SQL should get the results as requested in your post.

SELECT      ID         ...

If the users can add/remove columns to a table at will, I would actually consider this a good candidate for an EAV table.

If i wish to use bigint for storing huge number of records in a table, i know bigint can go upto 9223372036854775807.

What if for next record if i...

If i wish to use bigint for storing huge number of records in a table, i know bigint can go upto 9223372036854775807.

What if for next record if i reach...

In order for anybody to assist with performance issues, you will need to upload the execution plan of the 2 different queries.  The actual execution plan is preferred.

Just guessing here,...

If you use the SSMS table designer to change the field from INT to BIGINT, then generate the change script, you will see that under the hood, the table is...

• This reply was modified 5 years, 4 months ago by DesNorton.

Luckily, in this case, the PII views that sit on top of the underlying tables, all return data from only that table, and use exactly the same column names.

SO, I...

I don't see any way to do this.  A view could have columns from several different referenced entities and from no referenced entity at all (such as CREATE VIEW...

What about INFORMATION_SCHEMA.COLUMNS or sys.columns ?   Do you not have access to either of those?  It just seems to me that those would make it far easier than trying...