This is nothing more than updating the table where date is greater than the date being passed in. The reason you are having a problem is because you have dates...

Erin Ramsay (3/8/2013)

---

So you're just looking to update each date to the end of the day?

Will this help you get started?

declare @datefield datetime

set @datefield = GETDATE()

select @datefield originalDate, dateadd(ms,-3,cast((dateadd(d,1,cast(@datefield as...

Glad you figured it out. This brings up a comment. If you store time information...

I guess I missed the bit about the date part. Just add a where clause to your query and you should be good to go.

declare @SearchDate datetime = '2012-04-01 00:00:00'

select...

Chrissy321 (3/8/2013)

---

There are two approaches to this problem that I am aware of.

You procedure is passed one string parameter like 'BUY','SELL','CONTRIBUTION' and then the string is split within the procedure...

I would say that "it depends". I do think to that to some extent you can tell a lot about a person by their code. I don't however think you...

This sounds a lot like a "catch all" query. check out Gail's blog post about this type of query here. http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/%5B/url%5D

Multiple values in a single parameter don't quite work like that. It is kind of a pain to deal with. However, there is really slick way to parse the value...

Excellent job posting ddl, sample data and an explanation.

This should work based on your sample.

select *

from

(

select *, ROW_NUMBER() over (partition by ConsumerID order by ActivityDate desc) as RowNum

from...

Well you did a pretty decent job of posting ddl and sample data. However it is totally unclear what you want for output. What column in your table defines the...

Duplicate post. Direct replies here. http://www.sqlservercentral.com/Forums/Topic1428706-391-1.aspx

You saw a cursor and your eyes rolled back in your head...then you realized that this really might be one of those...

This looks an awful lot like a loop that is running inside either another loop or a cursor. I agree that the only way you are going to improve performance...

You don't need to have email as a constant in your select for your cursor, just use the value that is already there.

The bigger question I would ask is do...

That is because you concatenate values to the previous subject each pass through the loop.

Change you loop to this.

--@emailSubject = @emailSubject + @sku

EXEC...