HTH.

Make sure you keep this at one row/select or else you'll have a full blown cartesian plan .

Make sure you disallow the updates after this is done... you don't want to wipe out a systable by accident .

You might want to use minutes (or even ms if it's a datetime (not smalldatetime) for the order by instead of hours... if you want ot keep the true order...

How did you figure out my name really??? I don't have anything in my profile .

How about this?

Select * from

(SELECT count (distinct dbo.Member.NRDS_ID) AS 'ACTIVE MEMBERS'

FROM dbo.Member INNER JOIN

dbo.Member_Association ON dbo.Member.Member_Number = dbo.Member_Association.Member_Number

WHERE (dbo.Member_Association.Status = 'A') AND (dbo.Member_Association.Member_Type_Code = 'R' OR

dbo.Member_Association.Member_Type_Code = 'RA') AND (dbo.Member_Association.Primary_Indicator...

Quoting myself >> "You can't do that in sql server unless you rebuild the whole table."

This is exactly what sqlserver does when you hit save.

DECLARE @Table table (Date smalldatetime not null primary key clustered, BD bit not null)

INSERT INTO @Table (Date, BD) VALUES ('1980-01-01', 1)

INSERT INTO @Table (Date, BD) VALUES ('1980-01-02', 1)

INSERT INTO @Table...

You can't do that in sql server unless you rebuild the whole table. Anyhow, column order should be chosen at the select... and actually the only time that it matters...

Now you can make that 97% as this is also wrong in my opinion... but I like the discussion that ensued .

The only time I use this is for my flags table > FlagName, FlagValue. This works in my small environement and because this flags are checked by jobs to...

That can't be the query you are running as there's no syntaxe error in there. Please post the code that ERRORS OUT.

Can we see the code you are using?

Yup .

Looks like you must do this in a few steps >>

1 - Create the new column

2 - Transfer the data from the old to the new column.

3 - Drop te...

Why can't you use a SP?

Why not select * order by??