djj (8/21/2014)

---

Lynn Pettis (8/21/2014)

---

Just an FYI, I prefer the system views to the information_schema views as there is more information contained in them. Also, information_schema views aren't that portable....

Just an FYI, I prefer the system views to the information_schema views as there is more information contained in them. Also, information_schema views aren't that portable. They don't...

SequelSurfer (8/21/2014)

---

Lynn Pettis (8/20/2014)

---

SequelSurfer (8/20/2014)

---

Just realised why I haven't been getting these updates, D'Oh. Set my team up in the league but forgot to subscribe to this thread. Glad I...

Koen Verbeeck (8/21/2014)

---

Lynn Pettis (8/20/2014)

---

This isn't so much a error, but an informational warning that it may take a bit to open the package and the editor may be slow.

I...

Never had a problem with them running at my previous employer. Just a bit of a pain when they needed to be modified.

This isn't so much a error, but an informational warning that it may take a bit to open the package and the editor may be slow.

I have had that occur...

Not enough to work with here. If you could post the DDL (CREATE TABE statement) for the two tables, some sample data for the tables (INSERT INTO statements), and...

Eric M Russell (8/20/2014)

---

dirk.dromgoole (8/20/2014)

---

I suppose there are probably better ways to modify the query. Basically, the WHERE clause of the query is:

WHERE (GETDATE() - 1 <= EndDate)

If EndDate...

Ed Wagner (8/20/2014)

---

Lynn Pettis (8/20/2014)

---

Lynn Pettis (8/20/2014)

---

Ed Wagner (8/20/2014)

---

This is one of the great things about this site. A question gets posted and several working solutions get posted. ...

SequelSurfer (8/20/2014)

---

Just realised why I haven't been getting these updates, D'Oh. Set my team up in the league but forgot to subscribe to this thread. Glad I realised before the...

Lynn Pettis (8/20/2014)

---

Ed Wagner (8/20/2014)

---

This is one of the great things about this site. A question gets posted and several working solutions get posted. Then we can all...

Ed Wagner (8/20/2014)

---

This is one of the great things about this site. A question gets posted and several working solutions get posted. Then we can all learn something...

Just to show how it still works with the dogs names included:

create table dbo.DogBreeds_TestTable (

DogName varchar(32),

DogBreed varchar(32)

);

--Dog_names Dog_breed Order

--Princess Boxer 1

--Jack Boxer...

hamptonmom2009 (8/19/2014)

---

Thanks everyone!

I took bits and pieces. I realized I needed to add the dog's names to make things unique. I was able to get what I wanted (minus the...

hamptonmom2009 (8/19/2014)

---

Thanks everyone!

I took bits and pieces. I realized I needed to add the dog's names to make things unique. I was able to get what I wanted (minus the...