Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Querying Snapshot Data Expand / Collapse
Author
Message
Posted Thursday, May 23, 2013 9:27 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, March 18, 2014 5:11 PM
Points: 55, Visits: 342
Can someone help me with querying the snapshot data as show in the attached file?

  Post Attachments 
Snapshot Data.PNG (11 views, 44.92 KB)
Post #1456284
Posted Monday, May 27, 2013 4:56 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 3:13 PM
Points: 2,255, Visits: 2,718
If you provide the statements to create the test data, it will be a lot easier to give you some help.

My guess is you need to join on a sub-select of the table with the max(snapshot_date) < requested date.


** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
Post #1457056
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse