Logic Puzzle – Dice SubstituteCommented on: 5 years ago
(June 30, 2009)
My last attempt did not work well... :)
Here is another try with different format to present the logic:
1). flip coin 1
2). head > go to 4).
3). tail > go to 7).
4). flip coin 2
5). head > go to 10...
T-SQL Puzzle – Custom SequenceCommented on: 5 years ago
(January 26, 2009)
Here is SQL Server 2008 solution using composable DML:
INSERT INTO Invoices(invoiceid, custid, invdate, amt)
SELECT invoiceid, @custid, @invdate, @amt
FROM (UPDATE dbo.Sequence
Microsoft seems to be bent on marginalizing SQL Server Standard Edition—both in the sense of the artificial constraints placed upon how much memory it can use, and in terms of what seems to be a shift in focus on the role of Standard Edition from Microsoft....More