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, 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...

Here's the list of unsupported features in MOT.  No triggers has made it not easy (and not even tried in some cases) to migrate to for some of my projects. ...

How many data points and over what interval...

Standard deviation is the square root of the variance

"after several updates and inserts..."

Maybe it's worth asking... does your procedure specify 'set xact_abort on'?  When a proc has multiple DML statement in a transaction and without xact_abort setting can...