Skip to content

Instantly share code, notes, and snippets.

@hanleybrand

hanleybrand/min max dates on bb learn activity accumulator tables.sql

Created December 15, 2014 15:05
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save hanleybrand/6b23d9692c8c6ad48c9b to your computer and use it in GitHub Desktop.
Save hanleybrand/6b23d9692c8c6ad48c9b to your computer and use it in GitHub Desktop.
Download ZIP
Blackboard Learn Activity Accumulator - min/max dates (bb60 schema)
Raw
min max dates on bb learn activity accumulator tables.sql
-- checks the min/max dates on your activity accumulator tables
SELECT
MIN(prod.TIMESTAMP)as 'AA min date bb60'
, MAX(prod.TIMESTAMP) as 'AA max date bb60'
,(SELECT MIN(TIMESTAMP) FROM bb_bb60_stats.dbo.ACTIVITY_ACCUMULATOR) as 'AA min date bb60_stats'
,(SELECT MAX(TIMESTAMP) FROM bb_bb60_stats.dbo.ACTIVITY_ACCUMULATOR) as 'AA min date bb60_stats'
FROM bb_bb60.dbo.ACTIVITY_ACCUMULATOR prod;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment