Ok... I'm starting to feel like I'm being trolled a bit here, Bill.

What else is in the table besides that... show more than 1 "record" please.

Yes.

peace2007 (5/3/2008)

So...

You have a table with a single column and no external identifiers? Did you read the URL I pointed you to? You're not providing enough information for anyone...

First, take a look at the URL in my signature to get better help, faster. 😉

Following my own "rules", here some test tables and some test data...

--===== Presets

...

In "old" SQL Server 2000, "schema" was actually called "owner". It's the login or role that owns the object. It's assigned when the object is created and defaults...

I'm not sure what you mean by find all "month numbers" or "i want all the months inbetween to be listed"... do you want to find the first of every...

Nicely done, Matt! I guess my only exception to what you said is that I use it to "replace loops" all the time. Although.... I'll agree that it's...

Simon... take a peek at the following URL...

http://www.sqlservercentral.com/Forums/Topic494388-145-1.aspx#bm494619

Same technique can be used in SQL Server 2000 using VARCHAR(8000) with some limit, of course.

This is a double post... please post any replies at the following URL...

http://www.sqlservercentral.com/Forums/Topic494354-338-1.aspx

I haven't tried it, but I believe your problem is in the following code...

DECLARE @MaxRecipeId as INT

SELECT @MaxRecipeId = MAX(RecipeId )

FROM Recipe Where LocationId =1

It should...

I don't suppose you did a search on "running total" or anything like that... 😉

There's a lot of ways to solve the running total problem in SQL Server... they're all...

Here's the proof...

DROP TABLE jbmtest

go

SELECT TOP 1000000

RowNum = IDENTITY(INT,1,1),

...

And, I gotta tell you, 2ⁿ for CHAR, VARCHAR, and NVARCHAR size doesn't make a bit of difference because row size isn't any multiple of 2n (ie. 8060) and neither...

I'd have to say a lot of that depends on two things...

1. How important is the data? In other words, do you actually want the data to be...