Can you provide us with more details, like the complete error message.

Hey Bob! He's back!

Without the code for your stored procedure, table structure (CREATE TABLE statements), sample data, and expected results there isn't much we can do to help you.

Please do not double post. Please post replies here.

Geez, some people with no sense of humor. I read it thinking it was a real horror story unfolding on a poor DBA. Glad to see it was...

How about providing ALL the code not just snippets? From what you have posted, I have no idea why it didn't work.

Does this mean that the posts may be gettng better, or are we just showing greater tolerance for the moment??

Does this code help:

declare @ThisDate datetime;

set @ThisDate = getdate();

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

dateadd(wk, datediff(wk,...

Can you provide a concrete example of what you are talking about? For instance, what dates would be used today (2009-03-31) if either or both paramteres are null.

JJ B (3/31/2009)

---

I'm not sure most people made bad choices. there are always some that made poor financial choices, but buying a larger car, or a less efficient car because...

RJ (3/31/2009)

---

Yes. Other than the key column we wouldn't need to add "or ((d.col5 <> i.col5) or (i.col5 is null) or (d.col5 is null))" to a column that is not...

No, just half baked! 😉

RJ (3/31/2009)

---

this is a good query but would fail if there are NULL values in deleted. i think the below query would fix it. But, anyway I have to double...

JJ B (3/31/2009)

---

Example: I have a co-worker who a couple years ago bought an expensive, big gas guzzling SUV because she "likes the feel of it" and "feels safer in...

Does this give you what you want? Realize that this is going to be a large insert query for your actual table.

insert dbo.audit_abc (col1,col2,col3,col4,col5,audittype)

select

d.col1,

...