An alternative solution, not as efficient as QU but should be easier to understand

😎

USE tempdb;

GO

SET NOCOUNT ON;

declare @tbl table

(LineNum int,

Code varchar(2),

Amt money,

MaxAmt money

)

insert into @tbl (LineNum, Code, Amt, MaxAmt)

values

(1,'AA',10.00,50.00),

(2,'AA',20.00,50.00),

(3,'AA',10.00,50.00),

(4,'AA',40.00,50.00),

(5,'AA',10.00,50.00);

SELECT

...

Thank you for the question Steve.

Slightly off topic, prefer using RAISERROR to PRINT for progress reporting on long running scripts as it is almost instant and the printf functionality is...

Ed Wagner (10/1/2014)

---

Eirikur Eiriksson (10/1/2014)

---

Nothing much, QoDs been controversial, SQL Server will become...

Nothing much, QoDs been controversial, SQL Server will become Hadoop only, aliens are...

Quick thought, on 2012 this will work

😎

SELECT * FROM sys.all_sql_modules WHERE object_id = OBJECT_ID('dbo.MYVIEW')

SELECT * from sys.dm_exec_describe_first_result_set(N'select * from dbo.MYVIEW',NULL,NULL) as x

Congratulations Jack!

😎

Brilliant and well deserved!!! Congratulations Jason!!!

😎

Guess the only think to do is to mix a salty soup cup and...

Quick question, are there frequent changes in the schema/tables? If not, you are better off using the import export wizard to create the packages and edit as needed. To dynamically...

I'm intrigued by this comment, could you elaborate further?

😎

happycat59 (9/30/2014)

---

As far as I am concerned, this is another dodgy question. The sample data includes 4 rows only. Personally, I read the suggested answer and treated the...

Thanks for the question Steve.

Misread the 1, 2, 3, 3, 4 as 1, 2, 3, 4 and of course ticked row_number:pinch: Off for making more industrial strength espresso

😎

TomThomson (9/30/2014)

---

Stewart "Arturius" Campbell (9/30/2014)

---

Randomness leads to unpredicatable outcomes, very much as depicted...

hakan.winther (9/30/2014)

---

Eirikur Eiriksson (9/30/2014)

---

Thank you for the question Amit.

Given options of 0,2 and 20 with the set's cardinality of 20 makes this kind of obvious; the granularity of syscolumns is...

Thank you for the question Amit.

Given options of 0,2 and 20 with the set's cardinality of 20 makes this kind of obvious; the granularity of syscolumns is {object,column}, one can...