---
title: "Discussion on \"Generate Event Sequence Numbers within a Specified Time Interval — From SQL to SPL #42\" | Hashnode"
description: "Discussion on \"Generate Event Sequence Numbers within a Specified Time Interval — From SQL to SPL #42\". Problem Description & Analysis:\nA certain table in the MS SQL database has three fields: account, date and time of string type.\n\nTask: Now we need to add a sequence number column Seq for the group. When a new event occurs for an account within one ho..."
url: "https://hashnode.com/posts/generate-event-sequence-numbers-within-a-specified-time-interval-from-sql-to-spl-42/6858e9059546d8843d236553"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Generate Event Sequence Numbers within a Specified Time Interval — From SQL to SPL #42](https://esproc-desktop.hashnode.dev/generate-event-sequence-numbers-within-a-specified-time-interval-from-sql-to-spl-42?utm_source=hashnode&utm_medium=feed)

Problem Description & Analysis: A certain table in the MS SQL database has three fields: account, date and time of string type. Task: Now we need to add a sequence number column Seq for the group. When a new event occurs for an account within one ho...

Jun 23, 2025 · 2 min read · esproc-desktop.hashnode.dev  
Read the article

-   [#sqltutorial](https://hashnode.com/tag/sqltutorial)
-   [#databases](https://hashnode.com/tag/databases)
-   [#data-analysis](https://hashnode.com/tag/data-analysis)
-   [#data-engineering](https://hashnode.com/tag/data-engineering)
-   [#data](https://hashnode.com/tag/data)
-   [#esproc-spl](https://hashnode.com/tag/esproc-spl)
-   [#programming-blogs](https://hashnode.com/tag/programming-blogs)
-   [#programming-tips](https://hashnode.com/tag/programming-tips)
-   [#programming-ciovqvfcb008mb253jrczo9ye](https://hashnode.com/tag/programming-ciovqvfcb008mb253jrczo9ye)
-   [#productivity](https://hashnode.com/tag/productivity)
-   [#coding](https://hashnode.com/tag/coding)

## Written by

[esProc](https://hashnode.com/@esProcDesktop)

@esProcDesktop

  
[View profile](https://hashnode.com/@esProcDesktop)

esProc SPL is a JVM-based programming language designed for structured data computation, serving as both a data analysis tool and an embedded computing engine. FREE download👉🏻: https://www.esproc.com/download-esproc

## Responses 1

Markdown supported · ⌘↵ to post

[esProc](https://hashnode.com/@esProcDesktop)

[Jun 23, 2025](https://hashnode.com/posts/generate-event-sequence-numbers-within-a-specified-time-interval-from-sql-to-spl-42/6858e9059546d8843d236553/comment/6858eaa5168ea022934b78a2)

Download esProc SPL for FREE and share your thoughts with us!

👉🏻Discord:[discord.gg/sxd59A8F2W](https://discord.gg/sxd59A8F2W) 👉🏻Reddit:[reddit.com/r/esProc\_Desktop](https://www.reddit.com/r/esProc_Desktop/)
