Open Minded (2/24/2014)

---

Yes, for example, sample codes, solutions with EXCEPT is for version 2005 and above. Then an article is for 2008 and above, and another is 2012 only.

This...

You didn't give us a whole lot here to go on. It seems that you could use a CASE expression to derive your other three columns. http://technet.microsoft.com/en-us/library/ms181765.aspx

If you need more...

You would do yourself a favor if you stopped using cursors for doing row level modifications. Cursors are horrible for performance and really should only be used for some administration...

Good luck Lynn. Safe travels!!!

hisakimatama (2/24/2014)

---

Oh yes :-D. There's exactly 217 uses of NOLOCK in that query. I have no idea why. Well, maybe... Considering how long this thing ran,...

ACK!!! That is hideous!!! I love the NOLOCK hints on some of the queries and not others. :w00t:

patrickmcginnis59 10839 (2/24/2014)

---

Sean Lange (2/24/2014)

---

patrickmcginnis59 10839 (2/24/2014)

---

Sean Lange (2/24/2014)

---

patrickmcginnis59 10839 (2/24/2014)

---

GilaMonster (2/23/2014)

---

Jim Arko (2/23/2014)

---

When using dynamic T-SQL you need to concatenate the variables.

SET @sqlstring = 'UPDATE table SET column =...

river1 (2/24/2014)

---

There is a person that made a script (generic script) to do this.

I have searched on the internet and did not found...

I saw the script some time ago but...

patrickmcginnis59 10839 (2/24/2014)

---

Sean Lange (2/24/2014)

---

patrickmcginnis59 10839 (2/24/2014)

---

GilaMonster (2/23/2014)

---

Sure, if...

malcolm.garbett (2/24/2014)

---

Example of output that's "wrong." (Sorry about the formatting - I can never seem to get it to display correctly.)

CustomerIDCustomerNameCountryPartNumberCurrencyPYTD_Ext_PriceCYTD_Ext_PricePYTD_QtyCYTD_QtyASP_PYTDASP_CYTD

N1141ARC Machine Tools LtdGBS2G00009D070GBP0.00-235.44010235.44

N1141ARC Machine Tools LtdGBS2G00009D070GBP0.00261.60010261.6

Issue 1. ...

I would say to use a SUM with a case expression inside. It seems you have done that. We can't offer a lot more insight here because we have no...

patrickmcginnis59 10839 (2/24/2014)

---

GilaMonster (2/23/2014)

---

Sure, if you want a nice...

Pretty sparse on details but this should get you started in the right direction.

insert Tbl2

select EmpId,

EmpId,

EmpLName,

EMPFName,

case when EmpEmail like '%@test.com' then EmpEmail else '' end,

case when EmpEmail is not null...

You might also want to check out this book. There is a free download but the paper version is well worth the money spent.

http://www.red-gate.com/community/books/accidental-dba

montecarlo2079 (2/24/2014)

---

and yes I Get the error There is already an object named 'eapgdx' in the database.

If the table is not created, will it create a temp table or a...