ritacse

Convert.ToDouble("1234567.12345").ToString("N")

//If you want to control the decimal places you can do something like:

Convert.ToDouble("1234567.12345").ToString("N3") // 3decimal point
Convert.ToDouble("1234567.12345").ToString("N0") // int
or 
(Int32.Parse("78956258")).ToString("N0")

ritacse

1. change SP as per requirment
2. Field Explorer >> Right click on "Database fields" >> Select "Verify Database"
3. provide database connection, password & click "Finish" [database will be uptodate]
4. expand "Database fields">> command>> get your new column here

ritacse

We couldn’t find that file to show.

ritacse

//https://www.geeksforgeeks.org/javascript-get-the-index-of-an-object-by-its-property/

let arrayObj = [{
    prop_1: 'val',
    prop_2: 'val_12',
    prop_3: 'val_13'
}, {
    prop_1: 'val',
    prop_2: 'val_22',
    prop_3: 'val_23'

ritacse

    SET NOCOUNT ON;
--It's often used at the beginning of stored procedures and triggers. 
--Benefits of SET NOCOUNT ON 
--1.Reduces network traffic:
--2.Reduces processing

--Example:
ALTER PROCEDURE [dbo].[CheckUserMenuPermission]
    @UserId INT,

ritacse

var BindreportDataToHTML = function () {

    ReceiveSummary = _.chain(ReceiveSummary)
        .sortBy('companyID')
        .sortBy('purchaseIndentID')
        .sortBy('itemID')
        .value();

    var html = '';