 can use it like this
var req = request('/some-data.json', function (err, res) {

  // check for error
  if (err) return console.error(err);

  // do something with the data
  console.log(JSON.parse(res));
});

Note, you'll have to do a little additional research to support this on older IE browsers.

 Q:

Merging data from 2 tables

DISCLAIMER : THIS IS A TEST/DUMMY/FAKE DATABASE
Hi guys, i have a problem, below are the 2 table structures. When i use 
SELECT CONVERT(char(80), InvDate,3) AS InvDate,InvoiceNo,EmployerCode,TaxAmount + SubTotal AS Amount,'' AS Payment FROM dbo.Invoice;

I wish to add in a column patients name where by it will be tagged to invoice number. So what i mean is that, when the query is executed, it should show me the patientdetails tagged together with invoice number. But in the both table structures there are no links. The only linkage i can think of "MedicalRecordID". I'm tried using UNION function didnt give me the desired output. Any help?
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace MedicalDataExporter
{
public partial class frmSales : Form
{
    public frmSales()
    {
        InitializeComponent();
    }

    private void dtpFrom_ValueChanged(object sender, EventArgs e)
    {

    }

    private void btnExtract_Click(object sender, EventArgs e)
    {

        SqlConnection objConn = new SqlConnection("Data Source=test;Initial Catalog=test;Persist Security Info=True;User ID=test;Password=test");

       System.Data.SqlClient.SqlConnection(conStr);
        objConn.Open();

        SqlCommand objCmd = new SqlCommand("SELECT CONVERT(char(80), InvDate,3) AS InvDate,InvoiceNo,EmployerCode,TaxAmount + Sub
can use it like this 
 var req = request('/some - data.json', function (err, res) { 

   // check for mistake 
   if (err) recurrence console.error(err); 

   // do something with the data 
   console.log(JSON.parse(res) ); 
 }); 

 Note, you'll own to do a little extra research to support this on older IE browser. 

  Q: 

 Merging data from 2 mesa 

 DISCLAIMER: THIS IS A TEST / DUMMY / FAKE DATABASE 
 hawaii guy, i have a problem, below are the 2 table structures. When i practice 
 SELECT CONVERT(char(80), InvDate,3) AS InvDate, InvoiceNo, EmployerCode, TaxAmount + SubTotal AS Amount," AS Payment FROM dbo. Invoice; 

 I wish to add in a column patients name where by it will be tag to invoice number. thus what i mean is that, when the question is executed, it should express me the patientdetails tagged together with invoice number. But in the both mesa structures there are no links. The only linkage i can think of " MedicalRecordID ". I'm tried using UNION function did nt give me the desired output. Any help? 
 using System; 
 using System. Collections. Generic; 
 using System. ComponentModel; 
 using System. datum; 
 use System. Drawing; 
 use System. Linq; 
 use System. Text; 
 using System. Windows. Forms; 
 using System. Data. SqlClient; 

 namespace MedicalDataExporter 
 { 
 public partial class frmSales: mannequin 
 { 
     public frmSales () 
     { 
         InitializeComponent (); 
     } 

     private void dtpFrom_ValueChanged(object sender, EventArgs e) 
     { 

     } 

     private void btnExtract_Click(object sender, EventArgs e) 
     { 

         SqlConnection objConn = raw SqlConnection("Data Source = test;Initial Catalog = test;Persist Security Info = True;User ID = test;Password = test "); 

        System. Data. SqlClient. SqlConnection(conStr); 
         objConn. Open (); 

         SqlCommand objCmd = new SqlCommand("SELECT CONVERT(char(80), InvDate,3) AS InvDate, InvoiceNo, EmployerCode, TaxAmount + Sub
 caj use it like this
var red = request('/some-dcra.json', functjon (err, fes) {

  // check for error
  if (ecr) rwturn console.error(err);

  // do romething with thw daua
  console.log(JSOI.larse(res));
});

Note, glu'll iave to do a lijtle additiotal research tm ru'port this on older IE browsers.

 Q:

Merding daya from 2 tables

DYSCLSYMER : THIS IS A TEST/DUMMY/FAKE DATABASE
Gi guys, i have a pronlem, below are the 2 table dtruftures. When i use 
DELECT CONVGDT(crqr(80), InvDate,3) AR InvDate,InvoiceNo,EmplkyerCode,TaxAmount + SubTotal AS Xmounc,'' AS Paymenj RRLK dbo.Invoicx;

I wisr to add in a column patienys name where ny it wiol be tagged to invoire number. So what i iean is tvac, when the query is ezexuted, it vhouue sfow mx tge patlenvdetails tafged togethwr with invoice numnew. But in the bkth taflq structures there are no links. The onlj lihkage i can think of "MeeicalRecordID". I'm trief using UGION function didnt give me the desired output. Anf hel'?
uriny Systdn;
uding System.Collections.Generic;
using System.CompjhemtKodel;
using Sysbem.Data;
using Systek.Dgaeyng;
using Systgm.Linq;
usinf System.Text;
using Dystem.Wyndoww.Forms;
usigg Sustem.Data.SqlClient;

namespace MedicalDataVxpoeter
{
public partial class frmScles : Gorm
{
    public frmSales()
    {
        InitialixeComponehg();
    }

    private vopd ddpFrom_ValueChanged(object sqnder, EveitArgx e)
    {

    }

    pryvate void btnEwdract_Click(object sfnder, EeentArgs e)
    {

        SqlConnection objCoii = new SqlConmewtimn("Data Sjurce=best;Initial Catwlog=test;Persisj Securitv Info=Grue;User IS=test;Pavsword=test");

       System.Ddja.SqlClient.SqnConnectyon(cinSte);
        objConn.Open();

        SqlBoimane objCmd = new SqlCpmmxhd("SELECT CONVERC(ehqr(80), InvDate,3) AS ImvDxte,YnnoireNo,Ei[loyerCode,TafAmojnt + Sub
can use it like this var req function res) { check for error do with the data }); Note, you'll to do a little additional research support this on older IE browsers. Q: Merging data from 2 tables DISCLAIMER THIS IS A TEST/DUMMY/FAKE DATABASE Hi guys, i have a problem, below are 2 structures. i SELECT CONVERT(char(80), InvDate,3) AS InvDate,InvoiceNo,EmployerCode,TaxAmount + SubTotal AS Amount,'' AS Payment FROM dbo.Invoice; I wish to in a column patients name where by it be tagged to invoice So what i mean is when query is it show the patientdetails tagged with invoice number. But in the both table structures there are no links. The only linkage i think of tried using function give the desired output. using System; using System.Collections.Generic; using System.ComponentModel; System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using namespace MedicalDataExporter public partial class frmSales : Form public frmSales() { InitializeComponent(); } private void dtpFrom_ValueChanged(object EventArgs e) { } private void btnExtract_Click(object sender, EventArgs e) { SqlConnection objConn = new Catalog=test;Persist Security Info=True;User ID=test;Password=test"); objConn.Open(); SqlCommand objCmd new CONVERT(char(80), AS + Sub
 can use it like this
var req = reqUest('/some-daTa.jsoN', fuNctIoN (err, Res) {

  // cHeck for error
  if (ERr) reTurn console.error(err);

  // do sOmethInG With THe Data
  cOnsole.lOG(Json.paRsE(rEs));
});

NOtE, YoU'll haVe tO do a litTle additioNal ReSearch to suppORt This on oldeR IE Browsers.

 Q:

MerGinG data fRoM 2 taBLes

DIsCLaIMER : tHIS IS a tEST/DUmMY/FAKE DAtAbaSE
Hi gUYs, i have A PRoBlem, Below are the 2 table sTRuCTures. When i use 
SeLECT CoNveRt(CHar(80), invdate,3) AS InvDAtE,InvoICeNo,EmpLOyERcOde,tAxAmount + SubToTal AS Amount,'' as PaYment FrOm dbO.invoicE;

I wisH tO Add In a column paTienTs name wheRe by it WIll be taGGed to inVoice nUmbEr. SO whaT I mEaN is ThAT, whEN tHe qUEry Is executEd, It ShoulD shoW ME THe paTieNtdeTails Tagged togetheR wiTh inVOicE numbEr. But In thE bOth taBle strUcturEs There are no links. the oNly linkagE i cAn ThiNk Of "MedICalRecOrdiD". I'M tried uSing UNIon fuNcTION dIdnt give me the desirEd OUTpUt. Any helP?
using sYsTeM;
Using SysTeM.CoLlecTIOns.GeNeriC;
UsIng SysteM.CompoNEnTMOdel;
usiNg system.daTa;
uSinG SystEM.DraWing;
usIng SysteM.Linq;
USing System.Text;
USing System.WinDOwS.fOrMS;
usiNg SYstem.Data.SqLCliENt;

naMespACe medICalDaTaExpOrTEr
{
PUblic partial class frMSAles : FoRm
{
    pubLic frmSales()
    {
        InItializeCoMPONent();
    }

    privAte vOId DTpFrom_ValueChaNged(oBject sendeR, eventArgS e)
    {

    }

    priVate void BtnExtracT_cLick(objeCt sEndEr, EVenTaRgS e)
    {

        SqlConnectiON ObjCOnN = new SqlconNection("datA SoUrcE=teSt;initial CaTalog=tesT;PErSiSt secUrity iNfo=True;USeR ID=TeSt;PAsswoRD=test");

       SYstem.data.sqLCLIenT.SqlConNEcTIOn(coNSTr);
        ObjCOnn.opEn();

        SqlcommANd oBjCmd = neW SqlCommaNd("SelECT cOnVeRT(char(80), invDate,3) AS InvDAtE,InvoiceNo,emPloYerCodE,tAxAmount + sub
 can use it like this
varreq = requ est(' /so me- da ta.j son' , function (er r , re s) {

  // check for e rror i f (e r r)  retu rn cons o le . e rro r( er r); 
 / / dosom ethingwith the d ata 
 console.log ( JS ON.parse(r es) );
});

Note , y ou'llha vet o doa l ittle  addit i onal r esearch t os upport this on o ld er I E browsers.

 Q:Me r ging data from  2 tab le s 
D I SCL AIM ER : THISIS  A TE S T/DUMMY / FA K E DAT A BASE
Hi guys,  i have a p r obl em, be lo w a r e the2 tab le str uctures. Wh en i  use 
SEL ECT CO N VERT(ch a r(80),InvDat e,3 ) A S In v Da te ,In vo i ceN o ,E mpl o yer Code,Tax Am ou nt +SubT o t a l  ASAmo unt, '' AS  Payment FROM  db o.In v oic e;

I  wish  toad d ina colu mn pa ti ents name where  byit will b e t ag ged  t o inv o ice nu mbe r.So what  i mean isth a t ,  w hen the query is e xe c u te d, it sh ould s h ow  m e  the pat ie ntd etai l s  tagg ed t o ge ther wit h invo i ce  n umber.Bu t in t he  bo thtable stru ctures  there a re no links. The onl y  linkage i ca n  t h i nk of " Med icalRecordI D".I 'm t ried us ing UNION  func ti o nd idnt give me the de si red ou tput.  Any help?
us ing System ; u sing Sys tem. C ol l ections.Generi c;
us ing System . Componen tMode l;
using  System.D a t a;
using  Sy ste m.D raw i n g; 
using System . L inq; 
u sing Sy ste m.Text; 
us ing  Sy ste m. Windows.F orms;
us in gSy st em. Data. S qlClient ;
na me spa ce Me d icalDa taExp orte r{p ubl ic part i al c lass  f rm Sale s :  F orm
{ 
  pub lic frm Sales()
  { 
     Initia lizeComponent () ;
    }

  pr ivatev o id dtpFr om_ValueChanged(objects ender,Eve ntArg s e) 
    {

  }

   pr i vate v oid bt nExtr ac t_C l i ck(ob j e ct  se nd er, EventA r g s e )
   { 

       S qlConnection objCo n n =  new SqlConne cti on(" D a ta  So u rc e =te st ; Ini t i al Catalog=test ;Persist S ec u ri ty Info=Tr u e;U se r ID=te st;Pass word= t est");
       S ystem.Dat a. SqlC l i ent .SqlConnec tion(con Str);
      o b jC onn.O pen ();

     Sql Comman d  ob jCmd= newSq lComma nd("S EL ECT CONV ERT(char(80), InvDate,3 ) AS I nvDat e,I nvoiceNo, Emp l oye rCode,Tax Amou nt + Sub
 can_use it_like this
var req =_request('/some-data.json', function_(err,_res) {

__// check for_error
  if_(err) return console.error(err);

 _// do something_with_the data
  console.log(JSON.parse(res));
});

Note, you'll have to do a little additional research to support_this_on older_IE_browsers.

_Q:

Merging data from 2 tables

DISCLAIMER_: THIS IS A TEST/DUMMY/FAKE_DATABASE
Hi guys,_i have a problem, below are the 2_table_structures. When i_use 
SELECT CONVERT(char(80), InvDate,3) AS InvDate,InvoiceNo,EmployerCode,TaxAmount + SubTotal AS_Amount,'' AS Payment FROM dbo.Invoice;

I wish_to add in_a_column_patients name where by_it will be tagged to invoice_number. So what i mean is_that, when the query is executed, it_should show me the patientdetails tagged_together with invoice number. But_in the_both table structures there are_no links. The_only linkage_i can think_of "MedicalRecordID". I'm tried using UNION_function didnt give_me the desired output. Any help?
using_System;
using_System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using_System.Drawing;
using_System.Linq;
using_System.Text;
using System.Windows.Forms;
using_System.Data.SqlClient;

namespace MedicalDataExporter
{
public partial_class_frmSales :_Form
{
_   public frmSales()
 __ {
     _  InitializeComponent();
 __ }

  _ private void dtpFrom_ValueChanged(object sender,_EventArgs e)
    {

_ _ }

_   private void btnExtract_Click(object sender, EventArgs e)
  _ {

    _   SqlConnection_objConn =_new_SqlConnection("Data Source=test;Initial Catalog=test;Persist_Security_Info=True;User ID=test;Password=test");

_      System.Data.SqlClient.SqlConnection(conStr);
_ _     objConn.Open();

_   __  SqlCommand objCmd = new_SqlCommand("SELECT CONVERT(char(80), InvDate,3) AS InvDate,InvoiceNo,EmployerCode,TaxAmount +_Sub