Well it's still not clear to me.  Here are examples of both.  If you're choosing concat then make sure table_b has wide enough column to fit (including the spaces).

            
August 15, 2019 at 10:34 pm
            
#3671711

            
            
                                                
        

Do you want concatenation or coalescence of the 3 columns?  Can be 1 and only 1 value per row in these 3 columns?  Could all 3 columns have values in...

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 6 years, 8 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...

You're using SSMS and error says it's timing out.  What is the timeout setting in your SSMS?

In SSMS menu go to Tools, Options, Query Execution, then General.  The 3rd item...

Agree try/catch is primarily for error capture.  Partial rollbacks are not common in my experience.  Sql clients could cache partial form input however they do it.

In theory something could be...