Posted by Erland Sommarskog on 05/30/06 00:24

Helmut Woess (user22@inode.at) writes:
> A real SQL goody - i didn't think that this is possible with one
> statement.
> My respect, Erland!

At this point I feel obliged to point out that using a table numbers is
not an idea that I have come up with, but something I've picked up by
following the SQL Server newsgroups over the years. I will also have
to admit that as a system developer I am overly fond of using a table
numbers. It's a great idea - until you exceed the highest number in the
table, and your query no longer produces the right result.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Storing SQL Server Agent logs in a relational store
• Prev in forum: Re: T-SQL CLOSE Connection to DB
• Thread view: Re: SQL syntax question

[Reply to this message]