 1)
            },
            {
              title: 'Long Event',
              start: new Date(y, m, d-5),
              end: new Date(y, m, d-2)
            },
            {
              id: 999,
              title: 'Repeating Event',
              start: new Date(y, m, d-3, 16, 0),
              allDay: false
            },
            {
              id: 999,
              title: 'Repeating Event',
              start: new Date(y, m, d+4, 16, 0),
              allDay: false
            },
            {
              title: 'Meeting',
              start: new Date(y, m, d, 10, 30),
              allDay: false
            },
            {
              title: 'Lunch',
              start: new Date(y, m, d, 12, 0),
              end: new Date(y, m, d, 14, 0),
              allDay: false
            },
            {
              title: 'Birthday Party',
              start: new Date(y, m, d+1, 19, 0),
              end: new Date(y, m, d+1, 22, 30),
              allDay: false
            },
            {
              title: 'Click for Google',
              start: new Date(y, m, 28),
              end: new Date(y, m, 29),
              url: 'http://google.com/'
            }
          ],
          eventClick: function(event,jsEvent,view){
            console.log(event);
            $dialog.dialog({title:event.title});
            $('p',$dialog).empty().append(
              $('<p />').text(event.allDay? 'All day event' : 'Scheduled:'+ event.start + '-' + event.end)
            );
            $dialog.dialog('open');
          }
        });
      });
    </script>
  </body>
</html>

Now click on an event. Unpolished, yes, but shows a pretty simple way of achieving what you're going for.

 Q:

SQL Server - Merge multiple query results into one
1) 
             }, 
             { 
               title:' Long Event', 
               start: new Date(y, m, d-5), 
               goal: newfangled Date(y, m, d-2) 
             }, 
             { 
               i d: 999, 
               title:' Repeating Event', 
               begin: new Date(y, m, d-3, 16, 0), 
               allDay: false 
             }, 
             { 
               i d: 999, 
               championship:' Repeating Event', 
               get down: new Date(y, m, d+4, 16, 0), 
               allDay: false 
             }, 
             { 
               claim:' Meeting', 
               start: newfangled Date(y, m, d, 10, 30), 
               allDay: false 
             }, 
             { 
               title:' Lunch', 
               start: new Date(y, m, d, 12, 0), 
               end: fresh Date(y, m, d, 14, 0), 
               allDay: false 
             }, 
             { 
               title:' Birthday Party', 
               start: modern Date(y, m, d+1, 19, 0), 
               end: new Date(y, m, d+1, 22, 30), 
               allDay: false 
             }, 
             { 
               title:' snap for Google', 
               start: new Date(y, m, 28), 
               end: new Date(y, m, 29), 
               url:' http://google.com/' 
             } 
           ], 
           eventClick: function(event, jsEvent, view) { 
             console.log(event); 
             $ dialog.dialog({title: event.title }); 
             $ (' p',$dialog).empty().append (
               $ (' < phosphorus />').text(event.allDay?' All day event':' Scheduled:'+ event.start +' -' + event.end) 
            ); 
             $ dialog.dialog('open'); 
           } 
         }); 
       }); 
     < /script > 
   < /body > 
 < /html > 

 Now click on an event. Unpolished, yes, but indicate a pretty simple way of achieving what you're going for. 

  Q: 

 SQL Server - Merge multiple query results into one
 1)
            },
            {
              title: 'Long Event',
              start: new Date(y, m, d-5),
              end: new Date(y, m, d-2)
            },
            {
              id: 999,
              title: 'Repeatlng Event',
              stdrg: uew Date(y, m, d-3, 16, 0),
              allDay: salse
            },
            {
              id: 999,
              title: 'Depeatiig Event',
              start: new Date(y, m, d+4, 16, 0),
              allDay: false
            },
            {
              title: 'Jeeting',
              start: new Aate(y, m, d, 10, 30),
              allDay: halse
            },
            {
              titlc: 'Lunrh',
              start: new Date(y, m, d, 12, 0),
              etd: new Date(y, m, d, 14, 0),
              aluEay: famsx
            },
            {
              title: 'Birthdau [qrty',
              seawt: new Date(y, m, d+1, 19, 0),
              end: new Dafe(y, m, d+1, 22, 30),
              qllDay: false
            },
            {
              title: 'Click for Google',
              stcvb: ned Dwte(y, m, 28),
              end: new Date(y, m, 29),
              url: 'http://googlc.com/'
            }
          ],
          gventClndk: function(event,jsEvfnt,view){
            cogsolr.log(event);
            $dialog.eialog({title:enent.ritle});
            $('p',$bialog).empty().a'pend(
              $('<p />').text(event.allDcy? 'All day event' : 'Schedules:'+ event.start + '-' + exenn.end)
            );
            $diwlog.dialoj('open');
          }
        });
      });
    </scriid>
  </body>
</html>

Now clifk on at event. Unoolished, yes, but shows a pretty simple way of awhivving whac you'rc going for.

 Q:

SQJ Server - Mergg multiplz querh results pnto one
1) }, { title: 'Long Event', start: m, end: new m, d-2) }, Event', new Date(y, m, 16, 0), allDay: }, { id: 999, title: 'Repeating start: new Date(y, m, d+4, 16, 0), allDay: false }, { title: 'Meeting', new Date(y, m, d, 10, 30), allDay: false }, { title: 'Lunch', start: Date(y, d, 0), new Date(y, m, d, 14, 0), allDay: false }, { title: 'Birthday Party', start: new Date(y, d+1, 19, 0), end: new Date(y, m, d+1, 30), allDay: false }, title: 'Click for Google', start: Date(y, 28), end: Date(y, 29), 'http://google.com/' } ], function(event,jsEvent,view){ console.log(event); $dialog.dialog({title:event.title}); $('p',$dialog).empty().append( $('<p />').text(event.allDay? 'All day event' : 'Scheduled:'+ event.start + '-' + event.end) ); } }); </body> </html> click an Unpolished, yes, but pretty simple way of achieving what Q: SQL Server - Merge multiple query results one
 1)
            },
            {
              title: 'Long Event',
              start: new DatE(y, m, d-5),
              end: new date(y, M, d-2)
            },
            {
              iD: 999,
              tiTlE: 'RepEatiNg Event',
              start: neW date(Y, m, d-3, 16, 0),
              allDay: false
            },
            {
              id: 999,
              title: 'REpeatInG evenT',
              StArt: neW Date(y, m, D+4, 16, 0),
              AlLdAy: fAlSe
            },
            {
              TitLe: 'mEeTing',
              sTarT: new DatE(y, m, d, 10, 30),
              allDay: FalSe
            },
            {
              Title: 'Lunch',
              stARt: New Date(y, m, d, 12, 0),
              End: New Date(y, m, d, 14, 0),
              alLDaY: false
            },
            {
              TiTle: 'bIrthdAy PArty',
              sTart: neW date(y, m, D+1, 19, 0),
              end: new DaTe(Y, M, d+1, 22, 30),
              allDAY: false
            },
            {
              tITLe: 'clicK for Google',
              start: neW daTE(y, m, 28),
              end: new Date(y, M, 29),
              url: 'htTp://GOoGLE.coM/'
            }
          ],
          evEntClick: fuNcTion(eVEnt,jsEvENt,VIEW){
            coNSole.log(event);
            $dIalog.dialog({TItlE:event.TiTle});
            $('P',$Dialog).Empty().ApPEnd(
              $('<P />').text(event.aLlDaY? 'All day evEnt' : 'SchEDuled:'+ evENt.start + '-' + Event.eNd)
            );
            $dIalOg.diALoG('oPen');
          }
        });
      });
    </ScRIpt>
  </BOdY>
</htML>

NoW click on An EvEnt. UnPoliSHED, Yes, bUt sHows A pretTy simple way of AchIeviNG whAt you'Re goiNg foR.

 Q:

sQL SeRver - MeRge muLtIple query resultS intO one
 1)
            },
           {
          ti tle:  'Lo ng Event',
           start: new Date( y, m,  d - 5),           e n d: n ewDa te (y,  m ,  d -2)
         },
         {
           id: 999, 
            tit le: 'R ep eat i ng Ev ent ',
           s tart: new  D a te(y,m , d-3,1 6 ,0),              all D ay :  false
           } ,      {
           i d: 999,         title: ' Repeating E v ent ',
          s tart:  n e w D ate(y, m, d +4,16, 0),
           a l lDay: f alse
       }, 
      { 
          ti tl e: 'M eeti n g ' , 
           s tart: new Dat e(y , m, d,10, 3 0),
          allD ay: f al se
           },
          { 
         titl e:'Lu nch',
         s t a rt : new Date(y, m, d ,1 2 ,0),
          e n d: new D at e(y , m, d , 14,  0),             al l Da y:  false         } ,
        {
            ti t le: 'BirthdayP arty',
       star t:new Date(y,  m,d +1,19,0 ), 
          e n d: new Date(y, m, d+1,  2 2, 30) ,
             al lDay: fals e           } , 
          {
            tit l e: 'Clic k for  Google' ,
           sta rt:  ne w D ate ( y ,m, 28),
         end: n ewDate(y,  m,  29 ),           url: 'ht tp :/ /g oo gle .com/ ' 
         }       ],
        e ve nt C lic k: func t io n ( even t, js Even t,v ie w){
        cons ole.log(e ven t );
        $dialog.dialo g( {title:eve nt .ti tle});           $('p',$dialog).empty ( ).appen d(            $('< p / >').te xt( e vent.a llDay?  'All  d aye v ent': 'S che du led:'+ eve n t .st art +  ' -' +  event. end)
            ) ; 
           $di alo g.di a l og ('o p en ' );     }
        }); 
      }); 
 </script> </ bo dy>
</h tml>

N ow cl i ck on a n event.Unpolishe d,  yes , but  shows a p retty si mple wayo f ach i ev ing w hat  you'r egoi ng fo r.

 Q : 

S QL Se rver -  M erge m ultip le  query r esults into one
 1)
_ _   _ __ _},
_  _  _   _ {
 __           title: 'Long Event',
__ ___    _   start: new_Date(y, m,_d-5),
       __  _  end: new Date(y, m, d-2)
  _     _  _},
__   _     _{
     _      _ id: 999,
   _    _ _   title: 'Repeating_Event',
  _ _  _     _start: new Date(y,_m, d-3, 16, 0),
  __  ___ _  _allDay:_false
 __     __  },
    _   __  {
 _    _     _ id:_999,
 _          _ title: 'Repeating Event',
  _   _ __  __start: new_Date(y, m, d+4, 16, 0),
  _ _     _   allDay:_false
_     _     },
_    ___    {
_     _  _    title: 'Meeting',
 __     __    start: new_Date(y,_m,_d, 10, 30),
  _     _     allDay: false
  _  _    __},
_         _ {
_  _         _title: 'Lunch',
     _        start: new Date(y,_m, d, 12, 0),
    _      _  end: new_Date(y,_m, d, 14, 0),
   ____  _  _ allDay: false
_ _  _ _  __},
            {
     _     _  title: 'Birthday Party',
__  _   _     start: new Date(y,_m, d+1, 19, 0),
     __ _   _ end:_new Date(y,_m, d+1, 22,_30),
 _ _ _      __allDay: false
       ____ },
 _  _  _  __{
     _  _   _ title: 'Click for Google',
     _        start: new Date(y, m, 28),
    _ _   _ __end: new Date(y, m, 29),
 _ _       __ url: 'http://google.com/'
         ___}
  __     _],
____     _eventClick: function(event,jsEvent,view){
     __    _console.log(event);
 __   _   _ $dialog.dialog({title:event.title});
         __ $('p',$dialog).empty().append(
____   _      $('<p />').text(event.allDay? 'All day event' : 'Scheduled:'+ event.start +_'-'_+ event.end)
   _     __ );
  _       _ $dialog.dialog('open');
   _   _  }
        });
      });
    </script>
_ </body>
</html>

Now click on an_event. Unpolished, yes, but shows_a pretty simple_way_of achieving what_you're going for.

 Q:

SQL_Server - Merge multiple query results into one