var mssql = require('mssql');

var config = {
    user: 'sa',
    password: 'scott',
    server: 'MSSQL2008',
    database: 'AdventureWorks',
    stream: false
};

var msconnection = new mssql.Connection(config, function (err) {
    if (err) console.log(err);
});

        module.exports.getCustomersDetails = function (callback, id) {
            var request = new mssql.Request(msconnection);

            //Add parameters to the SP
            if (id != null) {
                request.input('ID', id);
            }

            request.execute('CUSTOMER_DETAILS_GET', function (err, recordsets, returnValue) {  // does not come here when the dataset is large
                if (err) console.log(err);

                responseContent = {
                    recordDataKey: 'data',
                    data: recordsets[0]
                };
                callback(responseContent);
            });
        };

var c = require('./b.js');
c.getCustomersDetails(function (responsecontent) {
    console.log(responsecontent);
},  '1,2,3');