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: Sunday, September 7, 2014 5:45 PM
Points: 55, Visits: 343
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 @ 2:20 PM
Points: 2,302, Visits: 2,773
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