I had executed twin.devil code and it works on my side. I am using SQL Server 2012.

Apart from that, I am interested to know how to populate few records into...

Luis Cazares (8/18/2014)

---

I hope that this is part of a data cleansing process because it's complicated and won't be great for performance.

Here's a possible solution. Be sure to understand it....

Lynn Pettis (7/1/2012)

---

Using the following sample data, what would your expected results be?

DECLARE @SAMPLE TABLE

(

ID INT NOT NULL,

ACCOUNT CHAR(4) NOT NULL,

ORGANIZATION CHAR(3) NOT NULL,

SUBGROUP CHAR(2) NOT NULL,

AMOUNT int NOT NULL

)

INSERT...

Lynn Pettis (7/1/2012)

---

What is the criteria for eliminating subgroups from the result set? Hard to give you an answer when we don't know the rules that need to be...

Thanks to all the feedback. It is actually a work problem, not a homework problem 🙂

Moderator,

Please close this topic as I put in the wrong title.

Thanks.

Hi imex and Eugene,

Yeah, you guys are right. If 'aaa' exists in INBOUND and 'bbb' exists in OUTBOUND, then 'bbb' and 'aaa' should not exists in INBOUND and OUTBOUND which...

Hi Eugene,

There is really no rule to make 'aaa' to be only "inbound" but 'bbb' and 'ccc' only "outbound.

If there is an amount for 'aaa' to 'bbb' (FLAG1 to FLAG2)...

GilaMonster (4/10/2012)

---

You're missing my point.

All three of those sets of data are identical, there is no such thing as 'order' of rows in a table. You cannot say that a...

GilaMonster (4/10/2012)

---

Which columns determine that?

SQL does not have any concept of a row's position within a table, a table...

Hi Cadavre,

bbb will be Inbound and aaa will be Outbound.

Cadavre (4/10/2012)

---

Not really.

What I want to know is how can you tell which is inbound and which is outbound?

In your sample data, aaa and bbb are the FLAG1 and...

Cadavre (4/10/2012)

---

After 320 visits, you should know by now that you need to provide DDL, readily consumable sample data and expected results as per this article.[/url]

First, I've build some...

Yes. Every account code will have transactions in every period. The differences is that BS account will...

dwain.c (3/15/2012)

---

Here's another solution:

;WITH PLYTD AS (

SELECT Account, Organization, Period, [Year]

,(SELECT SUM(Amount) FROM @acct a2

WHERE a1.Account = a2.Account and a1.Organization = a2.Organization and a1.[Year] = a2.[Year] and

a2.Period <= a1.Period

) As...