How about posting the actual code instead of an estimated execution plan? Also, it would be a LOT better to see the actual execution plan. You have a splitter in...

Eric M Russell (12/2/2016)

---

Another issue is what to do when the Address already exists. Address is a separate entity from Employee, and it would break proper normalization to duplicate addresses...

Duplicate post. direct replies here. http://www.sqlservercentral.com/Forums/Topic1839767-3411-1.aspx

You should look at the stairways on this very topic. It covers this and so much more. http://www.sqlservercentral.com/stairway/112556/%5B/url%5D

Please don't cross post. It just fragments replies and makes it harder.

The original thread can be found here. http://www.sqlservercentral.com/Forums/Topic1839767-3411-1.aspx

Phil Parkin (12/2/2016)

---

Just having a mind warp on how to insert into the address table and get that unique int value and put it into the correct master row for...

JALLY (12/2/2016)

---

if i use the where clause to filter return columns associated with inventory inv table to return inv.active = 1, it throws an error if i use it this...

JALLY (12/2/2016)

---

thank you Phill for formatting.

i want to apply a where condition to a column in the inventory table -dbo.Inventory inv like this:

where inv.active=1

without causing conflicts for the columns in...

I rarely (if ever) have to do this. But creating a cursor using...

Kudos to Phil for the formatting. Now...what is the question??

See my earlier post. It will sometimes skip databases.

John Mitchell-245523 (11/30/2016)

---

Sean Lange (11/30/2016)

---

From what is posted there is no need for dynamic sql at all. Why introduce the possibility of sql injection when you could simply skip the...

From what is posted there is no need for dynamic sql at all. Why introduce the possibility of sql injection when you could simply skip the dyanmic sql entirely?

Do be careful using this procedure in a production environment. It will sometimes skip databases. http://sqlblog.com/blogs/aaron_bertrand/archive/2010/12/29/a-more-reliable-and-more-flexible-sp-msforeachdb.aspx

Here is another great article on the topic. https://spaghettidba.com/2011/09/09/a-better-sp_msforeachdb/%5B/url%5D

robert.sterbal 56890 (11/23/2016)

---

What is on your menu for Thanksgiving?

Can you share any recipes?

Our family will be having Thanksgiving at my wife's parents with turkey, gravy, mashed potatoes, stuffing, maple walnut...