User Profile

Collapse

Profile Sidebar

Collapse
pjewett
pjewett
Last Activity: Dec 8 '09, 04:42 PM
Joined: Dec 8 '09
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • pjewett
    replied to Selecting MAX date from a group of records
    in SQL Server
    I'm pulling the data from a view.

    I've attached a sample record screenshot taken in Studio. Below is the sample I provided in the original post...is that not what you're looking for?

    Thanks so much.


    9781579905507 Altered Art 6,996 11/17/2006
    9781579905507 Altered Art 1,804 8/24/2006
    9781579905507 Altered Art 1,408 8/1/2006
    9781579905507 Altered Art 638 9/28/2006
    9781579905507 Altered...
    See more | Go to post

      Leave a comment:

    • pjewett
      started a topic Selecting MAX date from a group of records
      in SQL Server

      Selecting MAX date from a group of records

      Hi All,

      New to the forum and to SQL.

      I'm running a query to pull sales records for a specific customer that returns several dates (for each transaction). I only need the most recent date from the results however and am having difficulty figuring out how to get this.

      Can anyone help?

      Thanks

      Current code is:
      Code:
      SELECT vw_Summary_sales_Cust_Region_Brick_All.ISBN13, Sum(vw_Summary_sales_Cust_Region_Brick_All.NET_U)
      ...
      See more | Go to post
      Last edited by Frinavale; Dec 8 '09, 04:30 PM. Reason: Please post code in [code] ... [/code] tags. Added code tags.
      No activity results to display
      Show More
      Working...