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

Upgrading SQL Server 2017 Containers to 2019 non-root Containers with Data Volumes – Another Method

By

Yesterday in this post I described a method to correct permissions when upgrading a...

Power Platform Quick Tips – Episode 02: Dynamic Power Apps Form Headers

By

Welcome back to my Power Platform Quick Tips series! In this second episode we...

Simple-Talk Article…Understanding Azure Storage Options

By

Simple- Talk is technical journal and community hub from Redgate. This week I have the pleasure of...

Read the latest Blogs

Forums

Numeric and Decimal

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Numeric and Decimal, which is...

SSIS Expressions

By clucasi

Hi All, Just wondered if someone could help, I have an SSIS package with...

Random number in results searching IDNUMBER >= '1000205830' and IDNUMBER

By nilknarf1972

IDNUMBER >= '1000205830' and IDNUMBER <= '1000206010' ORDER BY ID_NUM DESC I'm also getting...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers