Welcome to the forums.

Check this link out on how to post these kinds of questions here. http://www.sqlservercentral.com/articles/Best+Practices/61537/

Since this is your first post I'll give you this first one as a...

Steve Jones - SSC Editor (5/18/2016)

---

Contracts in baseball, AFAIK, are real contracts. Can't get out of them even if you cut the guy. I think a player retiring is the...

drew.allen (5/18/2016)

---

yb751 (5/18/2016)

---

Ok, back from my meeting and thanks to Lowell's for the CTE.

;WITH MyOriginalTable([TransactionID],[LineItemNumber],[Amount])

AS

(

SELECT 1,1,1.00 UNION ALL

SELECT 2,1,2.00 UNION ALL

SELECT 2,2,3.00 UNION ALL

SELECT 2,3,1.00 UNION ALL

SELECT 3,1,4.00 UNION ALL

SELECT...

Ok, back from my meeting and thanks to Lowell's for the CTE.

;WITH MyOriginalTable([TransactionID],[LineItemNumber],[Amount])

AS

(

SELECT 1,1,1.00 UNION ALL

SELECT 2,1,2.00 UNION ALL

SELECT 2,2,3.00 UNION ALL

SELECT 2,3,1.00 UNION ALL

SELECT 3,1,4.00 UNION ALL

SELECT 3,2,3.00

)

SELECT

TransactionID,

LineItemNumber,

Amount,

SUM...

This is easily done grouping your rows using a window function. Look up SUM OVER() and see. If you still need some help I'll post back with an...

J Livingston SQL (5/18/2016)

---

Lynn Pettis (5/18/2016)

---

J Livingston SQL (5/18/2016)

---

Lynn Pettis (5/18/2016)

---

Grumpy DBA (5/18/2016)

---

jasona.work (5/18/2016)

---

Brandie Tarvin (5/18/2016)

---

Oh, my. SS just rebuked someone for asking what SS thinks is an irrelevant question....

I'm more of an NFL guy so maybe it's hard to compare. I mean thanks to TO and his antics (sharpie, Dallas Star, etc...) the league had to institute...

Jackson

Action

Caz68 (5/12/2016)

---

I dont know what IFCode is sorry.

I am using SQL server 2008 so assume that is MS SQL and not MYSQL as per my title apologies as I said...

German Shepherd

Bill Talada (5/11/2016)

---

Sure, the TOP clause accepts a parameter, just in case someone wants to make this a table valued function for returning 3, 12, or 300 dates. BTW, I...

lol...it was worth it!

Or possibly a started on filter when clicking on Recent Posts would be nice...

Dragon