Asif Sayed

Generating a Sequential Pattern

For many of us, working with the identity property allows us to easily generate a sequential series of numbers. But what if you need to generate a sequence according to some pattern, like one that includes the year? New author Asif Sayed brings us a technique and the code for generating a patterned sequence.

2.5 (2)

2006-05-17

8,982 reads

Blogs

ASF 030: Benni De Jagere interview

By

Introduction Benni De Jagere is a Senior Data Insights Consultant with a strong focus...

Going Dark in SSMS

By

I haven’t been a big fan of dark mode in many tools, but I’ve...

Figuring Out How To Hide Production Data

By

There’s a really simple conundrum that we go through all the time. The best...

Read the latest Blogs

Forums

Query Optimization Level

By Grant Fritchey

Comments posted to this topic are about the item Query Optimization Level

Now Is a Good Time for Choices

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Now Is a Good Time...

Design ideas for hostoric data & trending

By kazim.raza

Hi everyone, I have a use case (below) for which I am considering multiple...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

SQLCMD Output

See possible answers