Paul White (5/14/2009)

---

America is just really so big!

And hey your area is...

Well, since we are showing about where we all live, here is where I live.

Bob Hovious (5/14/2009)

---

Calm you must be, Lynn. Dwell on them you should not.

For though their numbers are legion they are not strong in the...

I'm still not sure what your problem is. Your statements are just too vague to know what your are actually asking us for. T make a simple guess,...

Is there a question here? I see code but no explanation as to what you are trying to accomplish or what error message(s) you may be receiving.

I have not used replication but I don't see how you can get 0 latency between publisher and subscriber. The data needs to be updated in the source database,...

The sun has set in the deep desert and lone figure sits quietly meditating next to a small camp fire. While sitting there, he simply cannot believe how ridiculous...

I started off in University as EE Major and had boolean logic hammered into me in several microprocessor design classes where we worked closely with AND gates, OR gates, NAND...

Jacob Pressures (5/14/2009)

---

Lynn, some of us are a little bit slow. Not all of us are privileged with common sense. I remember your ELSE correction, that is what eventually led...

Here is one article on calculating age, Calculating Age[/url]. Give it a read as well as the discussion that followed. There may also be several more articles on...

The VM environment makes it a bit more difficult. I'm looking at it at the physical server level at the moment. I am not looking at virtualizing any...

Which is why on your other thread I...

Does the following test code help you?

/*

guidAttendanceCodeChildrenID guidAssociateAttendanceCodeID AttendanceCode Date

NULL 7A0A970A5CD4 Approved 2008-06-05

NULL 9BF2F1986ED9 Unapproved 2008-06-05

NULL 27058A22E167 Approved 2008-06-06

NULL 9C77054505CE Unapproved 2008-06-09

NULL DDC7ED8C2284 Approved 2008-06-09

NULL 975628B59CC3 Approved 2008-06-10

NULL 64A11AB65DB9 Unapproved...

How about showing us the code you used to execute the stored procedure?

And in SQL Server 2005 (and later) you can also use NEWSEQUENTIALID (...