loop between 2 datetime field values

--CELKO-- (jcelko212@earthlink.net) writes:
> A programmer would have be in a very small isolated environment to
> deal with one and only one SQL product.

The system I work is by means nowhere close to small. And in runs on
SQL Server only.

The size of the system may be different for other SQL programmers, but
most programmers only work with one product at a time. And to be able
to get the best performance out of their system, they need to know the
product they work with.

Sure, sometimes people cross borders. We had a guy that joined our team
that had a long experience of Oracle. A brave step, but there was no
happy ending. He was mainly grumpy and whined about SQL Server not doing
things he was used to, and he left after two years.

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

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx