Hai Hari..

I want to get the Max("Runningvalue(sales) by product")

1st step: get Running Total of Sale for each product..

the result of this will be

Prod.Name ...

I looked into how long it would take to test it out and it was easier than I thought. If anyone cares, here is my test data code and query...

Forget my original question...

Make believe that this has nothing to do with cursors, stored procs or anything else. I just want to know if anyone has ever seen "Primary Key"...

I didn't post the actual code because its long gone. What I needed to do was a multi step process with a derived set of data. Something you would use...

The code is as simple as that.

declare @cnt Int,

@max-2 Int

declare @t TABLE (somekey Int identity(1,1) primary key, someval varchar...

OK, maybe this isn't suitable for this forum. But when I was 13 years old, I had access to a Apple II+ with dual 5 1/4" floppies. Hacking in 1983...

Great, I got the attachments! Thanks.

This is a great solution to the problem. Many solutions include offloading the XML creation to SQL server, which just adds more stress to a...

Perfect timing on this article too. I am about to implement some AJAX code and was looking for the right solution for generating the XML output from SQL.

The article...

Has anyone here seen the film "Shattered Glass?" Its about the reporter at the New York Times Stephen Glass who was caught fabricating news stories. It's not the same as...