Skip to main content

Home/ isrdataanalysts/ Group items tagged sessionid

Rss Feed Group items tagged

Filter: All | Bookmarks | Topics Simple Middle
robertm50

SQL SERVER - Solution to Puzzle - Simulate LEAD() and LAG() without Using SQL Server 20... - 0 views

blog.sqlauthority.com/...-server-2012-analytic-function

tsql lag sessionid SQL

shared by robertm50 on 10 Jul 14 - No Cached
  • robertm50 on 10 Jul 14
     
    "CASE WHEN N%2=1 THEN MAX(CASE WHEN N%2=0 THEN SalesOrderDetailID END) OVER (Partition BY (N+1)/2) ELSE MAX(CASE WHEN N%2=1 THEN SalesOrderDetailID END) OVER (Partition BY N/2) END LeadVal, CASE WHEN N%2=1 THEN MAX(CASE WHEN N%2=0 THEN SalesOrderDetailID END) OVER (Partition BY N/2) ELSE MAX(CASE WHEN N%2=1 THEN SalesOrderDetailID END) OVER (Partition BY (N+1)/2) END LagVal FROM T1"
1 - 2 of 2
Showing 20▼ items per page