buddy__a (3/28/2014)

---

This is being run in a brand new database on both servers that I'm testing it on.

CREATE TYPE [dbo].[MYGUID] FROM [uniqueidentifier] NOT NULL

CREATE TABLE [dbo].[EmergencyContact](

[EmergencyContactID] [uniqueidentifier] ROWGUIDCOL NOT...

Michael Valentine Jones (3/28/2014)

---

Luis Cazares (3/28/2014)

---

I'm a developer/programmer/moroff/slave and for that reason, I wonder why people like to overcomplicate things if they have the tools available. Next thing, I'll hear...

Hi and welcome to the forums. Unfortunately your post doesn't make a lot of sense. We can help you but you have to help us first. At the very least...

buddy__a (3/28/2014)

---

This my not be as simple as it seems in that the default can be created on one server but not on another. This is part of an...

Ville-Pekka Vahteala (3/28/2014)

---

Sean Lange (3/28/2014)

---

Luis Cazares (3/28/2014)

---

I'm a developer/programmer/moroff/slave and for that reason, I wonder why people like to overcomplicate things if they have the tools available. Next thing, I'll...

Luis Cazares (3/28/2014)

---

Sean Lange (3/28/2014)

---

Luis Cazares (3/28/2014)

---

I'm a developer/programmer/moroff/slave and for that reason, I wonder why people like to overcomplicate things if they have the tools available. Next thing, I'll...

Luis Cazares (3/28/2014)

---

I'm a developer/programmer/moroff/slave and for that reason, I wonder why people like to overcomplicate things if they have the tools available. Next thing, I'll hear about someone making...

Ed Wagner (3/28/2014)

---

Oh boy - I should have kept my mouth shut. Please, no pictures...

ChrisM@Work (3/28/2014)

---

Sean Lange (3/28/2014)

---

ChrisM@Work (3/28/2014)

---

Sean Lange (3/28/2014)

---

ChrisM@Work (3/28/2014)

---

Sean Lange (3/28/2014)

---

dwain.c (3/28/2014)

---

Ville-Pekka Vahteala (3/27/2014)

---

Luis Cazares (3/27/2014)

---

How is it possible that someone writes a cursor instead of using SUM()?

I'm afraid that this...

Jeff Moden (3/28/2014)

---

SQLRNNR (3/28/2014)

---

Sean Lange (3/28/2014)

---

dwain.c (3/28/2014)

---

Ville-Pekka Vahteala (3/27/2014)

---

Luis Cazares (3/27/2014)

---

How is it possible that someone writes a cursor instead of using SUM()?

I'm afraid that this database is full of...

ChrisM@Work (3/28/2014)

---

Sean Lange (3/28/2014)

---

ChrisM@Work (3/28/2014)

---

Sean Lange (3/28/2014)

---

dwain.c (3/28/2014)

---

Ville-Pekka Vahteala (3/27/2014)

---

Luis Cazares (3/27/2014)

---

How is it possible that someone writes a cursor instead of using SUM()?

I'm afraid that this database is full...

ChrisM@Work (3/28/2014)

---

Sean Lange (3/28/2014)

---

dwain.c (3/28/2014)

---

Ville-Pekka Vahteala (3/27/2014)

---

Luis Cazares (3/27/2014)

---

How is it possible that someone writes a cursor instead of using SUM()?

I'm afraid that this database is full of these pieces...

SQLRNNR (3/28/2014)

---

Sean Lange (3/28/2014)

---

dwain.c (3/28/2014)

---

Ville-Pekka Vahteala (3/27/2014)

---

Luis Cazares (3/27/2014)

---

How is it possible that someone writes a cursor instead of using SUM()?

I'm afraid that this database is full of these pieces...

You might start with this article. http://www.sqlservercentral.com/articles/comma+separated+list/71700/%5B/url%5D

It won't cover every requirement but it will be a good start. Give it a shot.

If you run into issues, feel free to post...

Not enough information to offer much help here. Please take a few minutes and read the first article in my signature for best practices when posting questions.