select top 5 left(convert(varchar(10),EffectiveDate,101),10) [Date]
, convert(varchar,cast(NetMarketValue as money),1) [NetMarketValue]
, convert(varchar,cast(NetGainLoss as money),1) [NetGainLoss]
WHERE (EffectiveDate IN (SELECT MAX(EffectiveDate) FROM Investment.Portfolio.vForwardContractHolding))
AND (Broker = ' ')
AND (CustomGroup = ' ')
AND (SourceAccount = ' ')
AND (SourceAccountId = ' ')
ORDER BY NetGainLoss desc
THE field NetGainLoss is defined as a float field within the database table 'Investment.Portfolio.vForwardContractExposure'
What tricks if any would return the correct results for example with whole numbers 1, 55, 9
it would return results in this order ...