Skip to content
Navigation menu
Search
Powered by Algolia
Search
Log in
Create account
Forem
Close
#
esprocspl
Follow
Hide
Posts
Left menu
đź‘‹
Sign in
for the ability to sort posts by
relevant
,
latest
, or
top
.
Right menu
Aggregate according to Time Interval — From SQL to SPL #27
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Follow
May 12 '25
Aggregate according to Time Interval — From SQL to SPL #27
#
programming
#
database
#
sql
#
esprocspl
9
 reactions
Comments
3
 comments
2 min read
Statistics by Time Window — From SQL to SPL #31
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Follow
May 22 '25
Statistics by Time Window — From SQL to SPL #31
#
programming
#
database
#
sql
#
esprocspl
10
 reactions
Comments
3
 comments
3 min read
Find the Superset from the Relationship Table — From SQL to SPL #19
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Follow
Apr 16 '25
Find the Superset from the Relationship Table — From SQL to SPL #19
#
dataengineering
#
sql
#
esprocspl
#
programming
1
 reaction
Comments
1
 comment
1 min read
Number Non-Null Values in Order within the Group — From SQL to SPL #17
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Follow
Apr 11 '25
Number Non-Null Values in Order within the Group — From SQL to SPL #17
#
programming
#
sql
#
esprocspl
#
dataengineering
6
 reactions
Comments
1
 comment
2 min read
Getting Values from Multiple Format Strings to Multiple Records — From SQL to SPL #16
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Follow
Apr 9 '25
Getting Values from Multiple Format Strings to Multiple Records — From SQL to SPL #16
#
programming
#
dataengineering
#
sql
#
esprocspl
6
 reactions
Comments
1
 comment
2 min read
Get the Initial Date Using the Total — From SQL to SPL #35
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Follow
Jun 4 '25
Get the Initial Date Using the Total — From SQL to SPL #35
#
programming
#
database
#
sql
#
esprocspl
6
 reactions
Comments
3
 comments
2 min read
Calculate all the year/months included in the year/month interval — From SQL to SPL #15
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Follow
Apr 2 '25
Calculate all the year/months included in the year/month interval — From SQL to SPL #15
#
programming
#
datascience
#
sql
#
esprocspl
5
 reactions
Comments
1
 comment
2 min read
Conditional Grouping — From SQL to SPL #37
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Follow
Jun 10 '25
Conditional Grouping — From SQL to SPL #37
#
programming
#
database
#
sql
#
esprocspl
6
 reactions
Comments
4
 comments
2 min read
Get the Records after and before the Searched One — From SQL to SPL #18
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Follow
Apr 14 '25
Get the Records after and before the Searched One — From SQL to SPL #18
#
programming
#
sql
#
esprocspl
#
dataengineering
7
 reactions
Comments
2
 comments
2 min read
Find the Closest Date Match for Each Record from Two Tables — From SQL to SPL #20
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Follow
Apr 18 '25
Find the Closest Date Match for Each Record from Two Tables — From SQL to SPL #20
#
programming
#
database
#
sql
#
esprocspl
6
 reactions
Comments
1
 comment
2 min read
Calculate the Number of Intersections between Adjacent Subsets after Grouping — From SQL to SPL #14
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Follow
Mar 31 '25
Calculate the Number of Intersections between Adjacent Subsets after Grouping — From SQL to SPL #14
#
database
#
sql
#
esprocspl
#
programming
5
 reactions
Comments
1
 comment
2 min read
esProc SPL & MongoDB: A Match Made in Data Heaven
Brett Hoffman
Brett Hoffman
Brett Hoffman
Follow
Feb 24 '25
esProc SPL & MongoDB: A Match Made in Data Heaven
#
mongodb
#
database
#
opensource
#
esprocspl
22
 reactions
Comments
4
 comments
3 min read
Pair and Transpose Adjacent Records within the Group - From SQL to SPL #13
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Follow
Mar 26 '25
Pair and Transpose Adjacent Records within the Group - From SQL to SPL #13
#
database
#
dataengineering
#
sql
#
esprocspl
6
 reactions
Comments
1
 comment
2 min read
Calculate a Pair of Minimum Values that Meet the Criteria within the Group — From SQL to SPL #12
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Follow
Mar 24 '25
Calculate a Pair of Minimum Values that Meet the Criteria within the Group — From SQL to SPL #12
#
sql
#
database
#
dataengineering
#
esprocspl
6
 reactions
Comments
1
 comment
2 min read
Calculate the Hierarchy of Recursive References — From SQL to SPL #11
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Follow
Mar 19 '25
Calculate the Hierarchy of Recursive References — From SQL to SPL #11
#
dataengineering
#
sql
#
esprocspl
#
database
5
 reactions
Comments
1
 comment
2 min read
đź‘‹
Sign in
for the ability to sort posts by
relevant
,
latest
, or
top
.
We're a blogging-forward open source social network where we learn from one another
Log in
Create account