Duplicate post. Please direct replies here. http://www.sqlservercentral.com/Forums/Topic1381001-391-1.aspx

Jeff Moden (11/3/2012)

---

Sean Lange (11/2/2012)

---

CELKO (11/2/2012)

---

If my birthday is in December (1983-12-12) and I just did the datediff function using CURRENT_TIMESTAMP and that birthdate...It would return that my age...

The decision to use a cte or a subquery boils down to preference. This type of query has been presented both ways time and time again with tons and tons...

When you restore a database it retains all the characteristics is had...

CELKO (11/2/2012)

---

If my birthday is in December (1983-12-12) and I just did the datediff function using CURRENT_TIMESTAMP and that birthdate...It would return that my age is 29 when really...

What error? Remember we can't see your screen, read your...

Was thinking about this during a meeting and one challenge with capnhectors code is that it could get unwieldy pretty quickly.

If the list contained more values for manufacturer this could...

I would probably go with capnhector's code. It will probably be better for performance. 😀

There are a few ways this could be done. Here is one example. Notice how I posted ddl and sample data to make setting up your problem easy.

;with cte as...

Luis Cazares (11/2/2012)

---

Sean Lange (11/2/2012)

---

That seems like a horrible way to name your columns but in order to do that you will have to use dynamic sql. Make you sure...

The problem with the code Luis posted is there is a USE inside dynamic sql followed by an update. The use does not...

That seems like a horrible way to name your columns but in order to do that you will have to use dynamic sql. Make you sure you wrap your column...

bala2 (11/2/2012)

---

HI,

We a have 2 tables.I need to update ds_size and create_dt columns values on DAT_DES table by comparing the Data_Des and DAT_STAGE tables coulumns.

update DAT_DES set

DAT_DES.ds_size = (select ds_size...

nmcgowan (11/2/2012)

---

It appears to be finding the correct db now as i get the following but still get an error performing the update

use [DJesus_eCristal]

GO

Msg 102, Level 15, State 1, Line...

Nice job with the ddl and sample data. However, it is much preferred to just include in your post so we don't have to download a file and unzip it...