sql server - Query containing Logic -

sql server - Query containing Logic -

September 15, 2013

<पूर्व>

 empno emailID -------------------- 1 A@gm.com 2 बी@gm.com 3 C@gm.com 2 बीबी @ gm.com 1 एए@gm.com 1 AAA@gm.com 3 CC@gm.com

< P> एक क्वेरी लिखें ताकि परिणाम हो: -

  empno emailID ------------------ - 1 ए @ जीएम.कॉम, एए @ जीएम.कॉम, एएए @ जीएम.कॉम 2 बी @ जीएम.कॉम, बीबी @ जीएम.कॉम 3 सी @ जीएम.कॉम, सीसी @ जीएम.कॉम     
  आप जो देख रहे हैं उसे MySQL में कहा जाता है और इस तरह दिखता है:  
   
  दुर्भाग्य से  GROUP_CONCAT  एसक्यूएल सर्वर में मौजूद नहीं है लेकिन आप  XML पट के लिए <उपयोग कर सकते हैं < / कोड> या अन्य कार्यवाही में से एक को उत्तर के रूप में पोस्ट किया गया है।


















Get link





Facebook





X





Pinterest





Email





Other Apps




Comments





Post a Comment







Popular Posts




Unable to get a fresh ASP.NET MVC project running with Visual Studio
2008 -



    This is a very basic question. I'm asking this silly about this, but I'm stuck something else and hopefully That something here can save me some time. So I open VS2008, to download the new ASP.NET MVC web application and click OK I want to prepare a test project. I debug my new MVC project to hit F5 then I enable the debugging to the web. I choose to modify the config file. It goes where I get a page load error.   Firefox can not establish a connection to the server on the local host: 57323.   Do I have to do something special for Vista? Or I should do something with IIS   Thanks for helping a noob   6/30/2009 update   OK, I think that I VS2008 may need to be reinstalled with the ASP.NET Development Server port. I have tried to do everything that I have suggested. I've marked Default.aspx as the start page. I tried to open it in Firefox / IE 8 / and Chrome. I tried to uninstall / reinstall ASP.NET MVC, which was not working. I tried telnetting with Putin with a local ho...






delphi - Mouseover hint for TChart series value -



    I am using a TChart in Delphi 7, and I want to display charts sometime. I am using the following code to set the chain value to a database query:    chart1.FreeAllSeries; Chart1.SeriesList.Clear; Chart1.AddSeries (TBarSeries.Create (self)); TBarSeries (chart1.Series [0]) BarStyle :. = BsRectGradient; Stop starting with Query 1; Executed; While EOF does not start chart1.Series [0]. Add (field 'flags' ('sum_actual_days'), Field Astrstring ('contract_no')); the upcoming; End; End;    Each time (value) is now showing both the label below the bar and in a yellow rectangle above the bar.   Rather than repeating the amount of label twice, I have some additional information from the query that I would like to show above the bar rather than the label (or, preferably, as a mouseover signal). Can it be done with TChart? And how ...?      This can be done with a TChart using the onMouseMeave event of the chart. Something like this should start with you:    Process TForm...






sql - Incorrect syntax near the keyword 'table' -



    I'm getting this error what I'm doing is trying to get data from a table and a db and Keep it in another DB and table. The tables are not exactly the same, I am using a FETCH cursor, so I get the first line from the DB1 table and then keep each column value in the declared variable. Then I run an assembly statement in db2 table and get the next value. All of these are working properly because it runs properly, but in the end I get this error,   Wrong syntax near the keyword 'table'.   In the entire transaction details, an attempt / catch with the error of expression in the Cat block, apart from this, I do not know what is the reason for it.   Here is the code    added to prevent additional result set at SET NOCOUNT - Interfering with the SELECT statement. Set nosenate on; TRY begin transaction sets ITENDITY column off --TURN identity_insert [dB] start [dbo] [TEST] all CONSTRAINTS table --TURN [dB] change [dbo] [TEST] NOCHECK barrier All -.... Insert statement here @...








Powered by Blogger