Skip to main content

Home/ isrdataanalysts/ Group items tagged by

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"
robertm50

SQ: Stata module for sequence analysis - 0 views

ideas.repec.org/...s456755.html

stata sequence analysis module

shared by robertm50 on 19 Jun 14 - No Cached
  • term sq refers to sequence data and to the commands for analyzing these data. Sequences are entities build by
    • robertm50
      robertm50 on 24 Jun 14
       
      test stick note
    • robertm50
      robertm50 on 24 Jun 14
       
      floating stick note
1 - 6 of 6
Showing 20▼ items per page