Goce Smilevski


Generating sequential numbers - the fast way

It is often necessary to generate a table with sequential numbers, up to a specified upper limit N. For small N, a simple INSERT in a WHILE loop will do. But, for large N, that solution becomes too slow. This script presents a different approach. It generates sequential numbers from the binary representation of N, […]

4.5 (2)

2004-12-30 (first published: )

592 reads

Blogs

How to get data in a DataFrame via .NET for Apache Spark

By

When I first started working with Apache Spark, one of the things I struggled...

The End of PASS

By

I think our profession was the better for having a professional association, even if...

Platforms for Events

By

in my last post I wrote about thinking of the tools as being a...

Read the latest Blogs

Forums

Linked Server Insert error

By natigsqlserver

Hello i have linked server one server in cloud one is local from local...

Default Credentials

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Default Credentials

Re-OPENing a Cursor

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Re-OPENing a Cursor

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers