SQL Server Query monthly totals -

SQL Server Query monthly totals -

मेरे पास एक प्रश्न है जो 01/01/2010 को सक्रिय सभी मामलों का योग करता है।

  SELECT COUNT (CaseID) कुल से dbo.ClientCase WHERE (CaseStartDate & lt; = CONVERT (DATETIME, '2010-01-01 00:00:00', 102)) और (CaseClosedDate> = CONVERT (DATETIME, '2010-01-01 00:00:00', 102)) या (CaseClosedDate IS नल) CaseStartDate द्वारा ग्रुप

मेरे पास एक कैलेंडर तालिका भी है जिसे मैं एक क्वेरी बनाने के लिए उपयोग कर सकता हूं जो 1 जनवरी, 1 फरवरी, 1 मार्च से 1 मार्च तक 1 तारीख से शुरू होता है।

मैं 2 प्रश्नों को कैसे संयोजित करने के लिए काम नहीं कर सकता, इसलिए मुझे सभी केस योगों की गिनती मिले

मुझे कुछ देखना होगा

  माह कुल जनवरी 102 फरवरी 130 मार्च 145 ..... दिसम्बर 162

  
   का चयन करें cal.MonthName, COUNT (CaseID) कुल से dbo.calendarTable cal बाएं OUTER JOIN dbo .ClientCase सीसी महीना (कैली.मोथस्टार्टडेट) = महीना (केसस्टार्टडेट) WHERE (केसस्टार्टडेट और एलटी; = कन्वर्ट (DATETIME, Cal.MonthStartDate, 102)) और (CaseClosedDate & gt; = CONVERT (DATETIME, Cal.MonthStartDate, 102)) या (CaseClosedDate IS                   > 
 


  

















Get link





Facebook





X





Pinterest





Email





Other Apps




Comments





Post a Comment







Popular Posts




IronPython in C#: No module named xmlrpclib -



    I am trying to create a web application with an interactive console for IronPython. When I try to import xmlrpclib into the General console of IronPython, it works. However, if I use IronPython inside my C # code, then it does not put an exception "a module named xmlrpclib", is it a known issue? Any solution to solve this issue?   Here is the code:    var testcode = @ "import xmlrpclib; apiarver = xmlrpclib.ServerProxy ('address', allow_none = true); print APIServer.Hello () ; "; Mystream str = newest Mystream (); ScriptEngine Engine = Python. Cretegenine (); Engine. Retyme.io asset output (str, system text encoding. ASCII); Engine. Serial.io.setuperoutput (str, systemtext.edcoding.aspx); ScriptScope scope = engine.CreateScope (); ScriptSource src = engine.CreateScriptSourceFromString (testCode); Src.Execute (scope); Sorry for the silly question, it has come to know that there is a path used by IronPathon inside me.       The C # code was not correct. I ...






qt creator - QtCreator importing makefile projects -



    Have you ever tried importing Classic C ++ / project into Qt Creator?   Say that I wanted to use some libraries in my GUI project, which must be created. how can I do this?      In Qt Creator 2.0.1 you can import projects using only * * Cmake, * .creator, * .pro or * .qmlproject   Then switch to cmake and you can import the project into Qt builder (Welcome tab -> Open project ...).   Alex     






php - cURL Cookie and 307 redirect issue -



    I currently have a script that loads my client using curls on another server Currently, the settings    curl_setopt ($ CH, CURLOPT_RETURNTRANSFER, 1); Curl_setopt ($ CH, CURLOPT_FOLLOWLOCATION, TRUE); Curl_setopt ($ ch, CURLOPT_AUTOREFERER, true); Curl_setopt ($ ch, CURLOPT_USERAGENT, $ UserAgent); Curl_setopt ($ CH, CURLOPT_HEADER, 0); $ Usecookie = ROOT_PATH "/public_html/football_parser/cookie.txt"; If ($ usecookie) {if (! Is_writable ($ usecookie)) {return "$ usecookie can not write cookie file, change the file's permission to 777 or read only for windows."; } Curl_setopt ($ ch, CURLOPT_COOKIEJAR, $ usecookie); Curl_setopt ($ ch, CURLOPT_COOKIEFILE, $ usecookie); } $ Output = curl_xac ($ ch);    I'm trying to load two example URLs   statto.com/football/teams/newcastle-united/2005-2006/results   and   statto.com/football/teams/newcastle-united/2008-2009/results   Without a second load without any problems  curl_setopt ($ ch, CURLOPT_FOLLOWLOCATION, TR...








Powered by Blogger