You posted 2 code blocks.  It appears there is an issue with the second one.  Where you define the cte:

VESValidEnrollList AS(
  SELECT 
   ...

So it's turtles all the way.  At some point you must have a statement that access the cte's yes?  Because if you define a cte and don't use it sql...

It won't let me post code.  Please add a select statement that references the common table expression.

The spam filter will not let you post "select *star*" which is kind of annoying on a Sql site.

Sorry, the 1,2,3,... syntax only works in sort by in Sql Server.   Can't tell if the syntax parses because the tables aren't in my test instance.  Please try:

            
August 15, 2019 at 3:58 pm
            
#3671597

            
            
                                                
        

These are the 5 'group by' columns in the select list:

     EnrollmentID
    ,CoveragePeriod
    ,PSPolicyTransID
   ...

• This reply was modified 5 years, 3 months ago by  Steve Collins. Reason: Put column lists in code editor

Oh ok I've looked into a little more.  Sql does get calendar/clock time zone info from the OS (on Windows, not sure how it works on Linux).  This is a...

Is this an MVC application?  Was the sql was generated by the entity framework?

Without wading into the specifics of your situation you could use the stuff() function in combination with for xml path.

In this code the cte is called num_expand and it creates...

Sorry, you asked if it's possible to install Sql Server with the Nepalese calendar.  Sql will inherit the time zone info from the OS it's installed on.  So if...

What happens if you run this query?

select * from sys.time_zone_info order by 1

In Azure Sql the 77th row is:

Nepal Standard Time, +05:45, 0

What happens if you run this next query?

select...