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 (...

Need the DDL (CREATE TABLE) for the table(s), sample data (in a readily consumable format), expected results based on the sample data, and your complete existing code that is failing.

Please...

If it is growing, it is because it needs to in order to store the data being inserted. Constantly growing and shrinking the mdf file is going to result...

The following sample code should get you started.

declare @ThisDate datetime;

set @ThisDate = getdate();

select dateadd(wk, datediff(wk, 0, @ThisDate) - 1, -1) -- Beginning of last week (Sunday)

select dateadd(wk, datediff(wk, 0, @ThisDate),...

purushotham.k9 (5/14/2009)

---

actuvally there are 2 reports One for all the dates, another for data just from last week. By last week I mean a previous week for any given date.

suppose...

But that may not be the "week" that the OP wants to report. That is why it is important to know what is meant by the previous week.