Ahh..

but what advantage are you getting doing that ?

why not just create an index if is query speed what he is looking for?

oh well ...  let him say what's the purpose

>> I have no desire to know this DB that intimately <<

Then you shouldn't be doing DBA work on it

>>Once the Index + Data gets moved to a new place, how can I verify this?

Is there any SQL that tells me that the data has really moved?<<

what is the  problem with

alter table [tblname] drop column [colname]

alter table [tblname] add [computedcolumn] as newformula

note: If you have schemabound objects you will have to remove the binding first

hth

I hate maintenace Plans. Even though you get a nice GUI there is no way to SCRIPT them and that helps a lot for server rebuilds!

Congratulations Frank!

In my home country this is called: B E E R !!!

Cheers

Full Backup of 2TB every day with 3rd party tools and to TAPE !!!

exec sp_update_resume

IF

• You are using SQL 2000
• You can modify (a little bit ) the stored procedures
• You don't permit direct access to the tables

Then:

Change the SPs...

Yep,

"EXISTS" does not look at the field list at all it only check the "JOIN"s and the "WHERE" clauses

Cheers!

>>I need to generate, for each record, the corresponding missing history records with the correct sequence values.<<

the way to do that is to CROSS JOIN your table with all possible...

There is one more alternative though

Use FULL OUTER JOIN between the two table and check pk nullability to determine source  

Just watch out for deletes though

I still don't think you need a cursor and I would need DDL to write a set based solution. But to answer your question you can get around that limitation...

this may help you getting started

SELECT     POAttachment.AttachmentNameUnique

  , POAttachment.POID

  , POAttachment.POAttachmentID

  , @Att1 = (case when (select count(*) from POAttachment a

                   ...

>>View: Well, a view simply isn't identical to a table, client or not, and if you try to insert something into a view the error that will pop up will...