This perhaps? 

SELECT FullName, NewType, SUM(Amount1), SUM(Amount2)
FROM
(
SELECT TOP (1) FullName, NewType, Amount1, Amount2
FROM @test-2
ORDER BY TDate...

I stumbled across this while looking to create my own and would like to propose a couple changes:  
First, I have noticed lately moving filters from a WHERE clause to a...

Can you provide an example of what the array looks like and what type of array it is? 

Problem is that the array can contain up to 250...

Fixing your data model to avoid this type of tomfoolery is always my first choice.

Thanks folks for the replies. After a little more research I discovered that the problem was related to periodic connectivity issues between the server and the SAN. I never saw...

Another really fast way to tackle this (using NGrams8k - link is in my signature):

SELECT *
FROM #stringsplit s
CROSS APPLY
(
SELECT STUFF(REPLACE((

I must admit, when I saw the title, TRIM() in T-SQL my first thought was, "boring!" 
That said - I was quite impressed and found the article to be quite...

For those who have not read this book I highly suggest it. I picked up a physical copy at SQL In the City 2012 and could not put it down....

i have a [tables] which contains ssn, city, state, zip columns after i run this report and save as xml 
then reopen it shows columns order as xip, state, city,...