User Profile

Collapse

Profile Sidebar

Collapse
John Wilcox
John Wilcox
Last Activity: May 17 '12, 01:07 PM
Joined: Feb 1 '12
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • John Wilcox
    replied to Sub query Question
    in SQL Server
    I apologize, let me explain further. Essentially there are three fields I'm dealing with.

    Field1, Field2, and Field3.

    Essentially I wish to COUNT both Field2 and Field3 up within one query.

    The issue I'm having is I only want to count the Field if the value "P1" is there.

    So the date could look like the below:
    Field1|Field2|F ield3
    1/1/2012|N|P1
    1/1/2012|P1|N
    1/4/2012|P1|N...
    See more | Go to post

      Leave a comment:

    • John Wilcox
      started a topic Sub query Question
      in SQL Server

      Sub query Question

      I believe this question can be solved using sub-queries, but for whatever reason I can't make it work yet.

      If I have two queries:
      1)
      SELECT Table1.Field1 F1,
      COUNT(Table2.Fi eldA) FA
      FROM Table1 T1
      INNER JOIN Table2 T2 ON Table1.PN = Table2.PN
      AND Table1.IR = Table2.IR
      WHERE (((Table1.F1 BETWEEN '01/01/2012' AND '01/31/2012')
      AND (Table1.FieldX IS NULL)
      ...
      See more | Go to post
      No activity results to display
      Show More
      Working...