LOL. Yeah if this is something you are going to have to do over and over then maybe you need to look at the process that is creating your new...

Given the challenge of needing to keep the existing values it may actually be easier and quicker to just edit the tables in SSMS over writing a script.

something like this may get you started in the direction you are heading.

select 'alter table ' + name + ' add ' + name + 'ID int identity not null;'

from...

That one "depends". For example, I had somebody last week ask me the syntax for an xml comment via instant message. I agree that there are plenty of bad answers...

Me too. Makes me nearly pee myself every time I send somebody a link there. Even better is the response I get from people around the office when the ask...

BitBucket - You need to know about this site.

This is the perfect link for a response to this thread.

😀

Not sure what information you are looking for or how you are wanting to get this information. With some more details your chances of an answer will increase greatly.

Please don't continue to post the same question repeatedly. The reason nobody responded to your first post is because you didn't provide any detailed information about your problem.

Please direct all...

You need to post some ddl and sample data so that we can help you. Take a look at the link in my signature for answers on how to get...

Sweet...

Lowell you beat me to the punch again. 😛

Your update is using a subselect. My guess is the error is that a subquery can't return more than 1 value??

Try this:

UPDATE ADDRESS

SET ADDRESS_STATE_ID = s.STATE_ID

FROM ADDRESS a

INNER JOIN...

something like

select AVG(datediff(d, DINVPDOF, DOCDATE)) from table

LutzM (5/4/2011)

---

Looks like a "classic" triangular join to me.

It might be a better way to use ROW_NUMBER() instead of the COUNT(*) in a subquery approach.

Would it be possible to post...

Since you are updating all the records where field1 = 0 to the same static value can you just calculate that value and put in a variable?

declare @newVal char(8)

select @newVal...