Well sort of....apologizes for being antagonistic and...

Do you still need help with this?

I am going to go out on a limb here and guess that you didn't bother to read the article that was suggested by myself and Lynn? Look at what...

I took a few liberties and created my own version of your data. I made the assumption that LastUpdated is a datetime datatype. If it is not, it will need...

Can you post ddl and sample data? It will help greatly if we know what datatypes we are dealing with here. Take a few minutes and read the article at...

Ganga-236835 (4/25/2013)

---

Also, I should point out that the many to many relationship I refer to is not the standard many to many model. In a one to many model, a...

Thanks Lowell. I figured it was collation but wasn't totally sure how to demonstrate it.

sram24_mca (4/25/2013)

---

Hi,

We have production database with huge records and every day 100 of users are using the application, because of this transaction log file size is increasing in...

Hi and welcome to the forums!!!

I am 100% certain that what you are trying to do is possible. However, you need to post a lot more details before anybody can...

I would agree that a many to many is not a the way I would choose here. There is nothing to be gained by this. Yes it is possible that...

Can you post ddl and sample data? Based on your vague description I put this together.

with something (SomeValue) as

(

select 'Alexander Glaesel' union all

select 'Alexander Glæsel' union all

select 'Alexander Riess' union...

Please take a few minutes and read the first article in my signature. We need ddl and sample data. Keep in mind we can't see your screen, we don't know...

We can't really offer a lot of help here because you haven't offered many details.

This is a good place to get started.

http://msdn.microsoft.com/en-us/library/ms189799.aspx

DKN2101 (4/24/2013)

---

Syntax error.

If i do:

SELECT MAX(Revenue_Spend) AS "Largest Amount Spent" FROM MaxCents

I get the max amount spent, but I can't figure out how to get it to display...

What happened when you tried that? Syntax error?

Keep in mind that your cte now...