Girl Programmers

Good $(date), /prog/! I'm the Symta guy (Nikita). If you still remember me, you will recall that I've found a programming job, so I've less time for text boards. Yet I promise to finish the Symta and join or start some Lisp OS project.

I also met a beautiful girl. She is a rare girl programmer, graduated from polytechnical university. She is cute, smart and wears glasses (http://minus.com/lwlti63gm5hO4). You wont find another girl like her in Russia, especially Serpukhov.

They only thing I fear is that she Jewish, because she is too smart for a Russian girl and cites Faina Ranevsky. I will kill myself if she is. Help me prog!

http://pastebin.com/kGGaY5L7


-- ungroup for SQL Server 2005
DECLARE @Table TABLE(id VARCHAR(20), quantity INT)
INSERT INTO @Table SELECT 'foo', 3
INSERT INTO @Table SELECT 'bar', 2

;WITH vals AS (
SELECT *
FROM (SELECT id, quantity FROM @Table) p
UNPIVOT (Cnt FOR Action IN (quantity)) unpvt
WHERE Cnt > 0
)
, Recurs AS (
SELECT id,
Action,
Cnt - 1 Cnt
FROM vals
UNION ALL
SELECT id,
Action,
Cnt - 1 Cnt
FROM Recurs
WHERE Cnt > 0

)
SELECT id,
(SELECT quantity FROM @Table t WHERE Recurs.id = t.id)
TotalQuantity --change this
FROM Recurs
ORDER BY id, action