A few additional comments:

• That's PDM (Pretty Damn Lazy) even for a programmer. You have to write out the columns - what? - ONCE and then save it. Cut and paste...

Here's a solution without UDFs, but it does take a Tally (number) table. Which, btw, mine starts at zero.

DECLARE @myTable TABLE
(
    DataDate DATETIME,
    DataVale...

Um, I did it in one select, based on the example you posted.

Here I sit working on my $400 computer with OpenOffice, Firefox, Oracle Express, SQLExpress, NetBeans, and a host of other good software -- all free -- and I kinda wonder...

declare @Table table (

id int primary key,

col1 int,

col2 ...

The trouble is, it is the 10% that has the money to spend on the cutting-edge products that provide the funds for the continuing R&D that makes the products better...

Rule #1 in any rulebook: Exceptions exist!

Primary keys: It is critically important to establish the natural key field(s) of a table. This is the foundation on which is built all...

I've seen the article before and I had the same question then.

Take the following query:

  select c1 from t1 where c2 = @value

There is an index defined on c2....

I agree with the sentiment stated here...but I have one question. IN is poor, granted. But how is NOT IN any worse? You take the result of IN (true, false)...

I wasn't doubting the ability of NewID() to generate random results. Nor was I concerned with using it as you did in generating a random sequence of genre IDs for...

Your basic problem is that your data is corrupt. The ProdLoc table is an intersection (or "glue") table which implements a many-to-many relationship between the Product and Location tables (any...

Well, gee, so was I...

Jeff,

You picked the wrong guy to use sports analogies on. How stupid is it it to hit balls against a fence while others try to catch them or for two...

How are you able to edit the quotes area? I'm not able to reach it when I quote a post.

------------------

I am a believer in taking full advantage of the strengths...

Whether or not Peter's specific solution disproves my general statement remains to be seen. How many RDBMSs will it work on?

As for putting the work in the query. How shall...