Jquery Error - Internal Server Error500 -

         error: function (e, textStatus, errorThrown) {

            //alert(e.responseJSON.Message);

            alert("Some Error occured");

            $('#model').hide();

        }

    });

===========================

Internal server error 500

Solution:- Due to Some duplicate function in Javascript

or

IF error showing Parameter BranchId

In Javascript BranchIds and BranchIds must be case sensitive as in Function name of cs file (web method)

Solution :- Due to Command.Parameters.Add("@BranchIDList") name to ("BranchIds")

================================

If error 

SQL Server find current year - Previous Year

  SELECT        TimePeriod

          FROM            (SELECT        YEAR(GETDATE()) AS TimePeriod

          UNION

          SELECT        YEAR(GETDATE()) - 1 AS Expr1

          UNION

          SELECT        YEAR(GETDATE()) - 2 AS Expr1

          UNION

          SELECT        YEAR(GETDATE()) - 3 AS Expr1

          UNION

          SELECT        YEAR(GETDATE()) - 4 AS Expr1) AS t

          ORDER BY TimePeriod DESC

Oracle JRE 7 Update 51 (64-bit) or higher is required for Polybase - For Microsoft SQL Server

 Uncheck "Polybase query  service for external data"

ref:-https://blog.sqlterritory.com/2017/10/31/sql-server-2017-oracle-jre-7-update-51-or-higher-is-required-for-polybase/

HTML colsapn and rowspan in table header - table with multiple headers

 <!DOCTYPE html>

<html>

<head>

</head>

<body>

<table style="width:100%">

<tr>

    <th rowspan="3">SL.No.</th>

    <th rowspan="3">ZONE</th>

    <th rowspan="3">BRANCH (Cummulative MPR)</th>

Powershell examles

 https://github.com/gangstanthony/