You changed...

You are certainly pretty close. Here is a small little bit of help for working with triggers. They can be pretty difficult to debug because you can't just run it...

Nope no offense taken. It seems that you still have some issues getting the information you want out of your query?

And take the suggestions for indexes with a grain of salt. The suggestions are not always good ones. You need to test actual performance before and after adding those indexes.

Luis Cazares (8/8/2012)

---

I couldn't believe that @Date was declared...

Still no ddl or sample data? Honestly how do you expect anybody to be able to decipher this from what you have posted? We can't see the tables, we don't...

Please don't start a new thread for the same topic. Please direct all replies here. http://www.sqlservercentral.com/Forums/Topic1341216-392-1.aspx

http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx

A couple other suggestions. You should not declare @Date as varchar and turn around and force implicit conversions to datetime.

DECLARE @DATE VARCHAR(25)

SET @DATE = '2012-08-01 23:59:59'

Instead declare it as the...

You still need to look closer at the inserted and deleted virtual tables.

joshphillips7145 (8/8/2012)

---

I Think this may be right now What would I do to test it? Write a select...

That is reasonably close. Take a look at the...

This sounds a lot like homework. As such you will find people here willing to help guide you but not many that will provide you with code. The reason is...

No worries. It is hard to put your thoughts on "paper" in such a way that others can understand it. It seems that perhaps you read the article I suggested....

Thanks. Now if we can just the OP to clarify the question we can knock this out in about 3-4 minutes. 😛

You can't execute a query against a variable like that.

select @execquery = N'Select * from dbo.' + quotename (@tablename)

EXECUTE sp_executesql @execquery

This is where I am stumped. After I execute the...