Forem

# esprocspl

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
Aggregate according to Time Interval — From SQL to SPL #27
Cover image for Aggregate according to Time Interval — From SQL to SPL #27

Aggregate according to Time Interval — From SQL to SPL #27

9
Comments 3
2 min read
Statistics by Time Window — From SQL to SPL #31
Cover image for Statistics by Time Window — From SQL to SPL #31

Statistics by Time Window — From SQL to SPL #31

10
Comments 3
3 min read
Find the Superset from the Relationship Table — From SQL to SPL #19
Cover image for Find the Superset from the Relationship Table — From SQL to SPL #19

Find the Superset from the Relationship Table — From SQL to SPL #19

1
Comments 1
1 min read
Number Non-Null Values in Order within the Group — From SQL to SPL #17
Cover image for Number Non-Null Values in Order within the Group — From SQL to SPL #17

Number Non-Null Values in Order within the Group — From SQL to SPL #17

6
Comments 1
2 min read
Getting Values from Multiple Format Strings to Multiple Records — From SQL to SPL #16
Cover image for Getting Values from Multiple Format Strings to Multiple Records — From SQL to SPL #16

Getting Values from Multiple Format Strings to Multiple Records — From SQL to SPL #16

6
Comments 1
2 min read
Get the Initial Date Using the Total — From SQL to SPL #35
Cover image for Get the Initial Date Using the Total — From SQL to SPL #35

Get the Initial Date Using the Total — From SQL to SPL #35

6
Comments 3
2 min read
Calculate all the year/months included in the year/month interval — From SQL to SPL #15
Cover image for Calculate all the year/months included in the year/month interval — From SQL to SPL #15

Calculate all the year/months included in the year/month interval — From SQL to SPL #15

5
Comments 1
2 min read
Conditional Grouping — From SQL to SPL #37
Cover image for Conditional Grouping — From SQL to SPL #37

Conditional Grouping — From SQL to SPL #37

6
Comments 4
2 min read
Get the Records after and before the Searched One — From SQL to SPL #18
Cover image for Get the Records after and before the Searched One — From SQL to SPL #18

Get the Records after and before the Searched One — From SQL to SPL #18

7
Comments 2
2 min read
Find the Closest Date Match for Each Record from Two Tables — From SQL to SPL #20
Cover image for Find the Closest Date Match for Each Record from Two Tables — From SQL to SPL #20

Find the Closest Date Match for Each Record from Two Tables — From SQL to SPL #20

6
Comments 1
2 min read
Calculate the Number of Intersections between Adjacent Subsets after Grouping — From SQL to SPL #14
Cover image for Calculate the Number of Intersections between Adjacent Subsets after Grouping — From SQL to SPL #14

Calculate the Number of Intersections between Adjacent Subsets after Grouping — From SQL to SPL #14

5
Comments 1
2 min read
esProc SPL & MongoDB: A Match Made in Data Heaven

esProc SPL & MongoDB: A Match Made in Data Heaven

22
Comments 4
3 min read
Pair and Transpose Adjacent Records within the Group - From SQL to SPL #13
Cover image for Pair and Transpose Adjacent Records within the Group - From SQL to SPL #13

Pair and Transpose Adjacent Records within the Group - From SQL to SPL #13

6
Comments 1
2 min read
Calculate a Pair of Minimum Values that Meet the Criteria within the Group — From SQL to SPL #12
Cover image for Calculate a Pair of Minimum Values that Meet the Criteria within the Group — From SQL to SPL #12

Calculate a Pair of Minimum Values that Meet the Criteria within the Group — From SQL to SPL #12

6
Comments 1
2 min read
Calculate the Hierarchy of Recursive References — From SQL to SPL #11
Cover image for Calculate the Hierarchy of Recursive References — From SQL to SPL #11

Calculate the Hierarchy of Recursive References — From SQL to SPL #11

5
Comments 1
2 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.