sql - Summing By Count -

-

I am trying to create a summation based on the calculation number for a particular column. If you look at the last line in the selection given below, you will see that I have tried to implement the case statement, however, it produces all the zero values believe I understand why (a unique set of values ​​in each row), but to me exactly how'm not sure that my problem 

  SELECT TotalFilesProduced.ReviewDate, TotalFilesProduced. FileReviewedByUserID, TotalFilesProduced.FileSource, TotalFilesProduced.FilesIndexed Total Index, TotalFilesProduced.FileNumberFages total fleet Snkyaprishtprisht, TotalFilesProduced.FilesProduced, Ririveteduuaiaidiaidi case when COUNT (separate file) & gt; 1 Thomas SUM (TotalFilesProduced.FilesIndexed) END of (Cast (ibfp.FileReviewedDate as DATE) review date, Aibifpi. Smicshabuyuesaiaraidi file, file processing, COUNT (*) Failenutpadit, COUNT (aside Aibifkinboundfailaidi) Failenanukrmit, Syuem (case when IBF. = Ibfp.ToPage THEN 1 ELSE ibfp.ToPage-ibfp.FromPage + 1 END) [FileNumberofPages] dbo.InboundFilePartitions ibfp Join INNER dbo.InboundFiles ibf ibfp.InboundFileID ibf.InboundFileID CAST (ibfp.FileReviewedDate as DATE) and gt; = '10 / 22/2014 'and cast (as the date ibfp.FileReviewedDate) & lt; = '10 / 22/2014' and ibf.ProjectID (110) TotalFilesProduced.ReviewDate, TotalFilesProduced.FileReviewedByUserID, TotalFilesProduced.FileSource, TotalFilesProduced.FilesSource, TotalFilesProduced.FileNumberofPages, TotalFilesProduced.FilesProduced   by Total Artists, Grouped Artists (as ibfp.FileReviewedDate Date), ibfp.FileReviewedByUserID, FileSource) / pre> 
 here's an example for further clarification - here UserID 1036 give a  output after zero  it appear only once but is fine for the 804 - I do yoga Want  Total Indexed  columns so that  NULL  area is 13 9 should be read (for both instances that 804 appears) 
 
  review. UASIDID ID in file review | File Resource | Total Indexed | Total file name packaging | Files produced | (No column name) / * My yoga * / -------------------------------------- - ------------------------------------------------- - ------------------------------------------- 2014-10-22 | 804 | 1 | 1 | 67 | 1 | Zero ------------------------------------------------- -------------------------------------------------- --------------------------------- 2014-10-22 | 1036 | 1 | 1 | 17 | 1 | Zero ------------------------------------------------- -------------------------------------------------- --------------------------------- 2014-10-22 | 804 | 2 | 138 | 3322 | 184 | The comment says - it will always be false

> 

  In case when COUNT (different file reviewed UIDIDID) & gt; 1

because 

  group ibfp.FileReviewedByUserID

and some other weird stuff 

  cast (ibfp.FileReviewedDate date) & gt; = '10 / 22/2014 'and Cast (ibfp.FileReviewedDate Date) & lt;   

  as cast (as ibfp.FileReviewedDate date)

More weird stuff 

  SUM (case if P. from page = ibfp.ToPage THEN 1 ELSE ibfp.ToPage-ibfp.FromPage + 1 END) [FileNumberofPages] is

as 

  SUM (ibfp.ToPage-ibfp.FromPage + 1) [FileNumberofPages]  < / Pre> 
 Not sure what you are trying to do but is not common on a group by a group

Comments

Post a Comment

Popular posts from this blog

java - Can't add JTree to JPanel of a JInternalFrame -

-
Image
There are two panels in my JInternalframe. I want to add TopPanel to Jtree to nominate another. But I can not add Jaitari to the top of the panel. Please help me in this piece of code: DefaultMutableTreeNode root = new DefaultMutableTreeNode ("deck"); DefaultMutableTreeNode Item Clubs = New DefaultMutableTreeNode ("Club"); AddAllCard (itemClubs); Root.add (itemClubs); DefaultMutableTreeNode item = New DefaultMutableTreeNode ("Diamonds"); AddAllCard (itemDiamonds); Root.add (itemDiamonds); DefaultMutableTreeNode Itemspads = New DefaultMutableTreeNode ("Spades"); AddAllCard (itemSpades); Root.add (itemSpades); DefaultMutableTreeNode item increases = new DefaultMutableTreeNode ("heart"); AddAllCard (itemHearts); Root.add (itemHearts); Default Trimodel Tree Model = New DefaultTreeModel (Route); Tree = new jetty (tree modal); ScrollPane = new JScrollPane (tree); // scrollPane.setViewportView (tree); . ScrollPane.getViewport () add (tr
Read more

javascript - data.match(var) not working it seems -

-
OK, I have this small block code, which is to scanned a number on the website, but for some reason There is a hip that it is not scanning at all. var regenges = / \ & lt; Span class = "currency-robux" data-to-"item-private-value-price" & gt; ([\ D,]) \ & LT; \ / Span \ & gt; /; Var ValueCiling = Data. Match (reggae); Value-song = number (value slicing location (",", "")); Is there anything wrong with that? This is related to the if statement if (value sling and lieutenant; = price watching) { < P> A function calls to move from there, but for some reason it does not seem to run at all. So I think the Regex is wrong but I'm not sure how. (There is a variable in PriceWinking , this is a snippet from the code.) On the website, I'm trying to remove it. & lt; Span class = "robux" data-plus = "item-privatesale-price" & gt; 115 & lt; / Span & gt; Keep in mind
Read more

javascript - How can I pause a jQuery .each() loop, while waiting for user input? -

-
Before I continue to get a jQuery .each loop to wait for user input There is a problem in repeatedly repeating This is my code (I have commented on what I would like to do): & lt; Html xmlns = "http://www.w3.org/1999/xhtml" & gt; & Lt; Top & gt; & Lt; Link rel = "stylesheet" type = "text / css" href = "common_components.css" /> & Lt; Meta http-equiv = "content-type" content = "text / html; charset = UTF-8" /> & Lt; Link rel = "stylesheet" href = "slider.css" & gt; & Lt ;? Php include_once 'common_components.php'; $ Query = $ dbh- & gt; Queries ("SELECT movies_dir FROM settings"); $ Line = $ query- & gt; Obtain (PDO :: FETCH_ASSOC); Date_default_timezone_set ('UTC'); Echo "& lt; title & gt; movie scanner & lt; / title & gt;"; ? & Gt; & Lt; Script src = "jquery.min.js" & gt; &am
Read more