Posted by signon77 on 10/30/07 16:44

Hi Roy,

Thanks for your help with this. My code now works looking like this:


SELECT
rr.BookName,
rr.ExternalId, -- Deal
rr.D1MTM, -- MTM on d-1
rr.PoolMTM, -- Pool MTM
abs(rr.[Difference]), -- Difference
rr.Comments -- Comments
FROM
#RevReps rr
UNION SELECT
d.BookName,
d.ExternalId, -- Deal
d.D1MTM, -- MTM on d-1
d.PoolMTM, -- Pool MTM
abs(d.[Difference]), -- Difference
d.Comments -- Comments
FROM
#RevRepDeals d
ORDER BY ExternalId desc, BookName asc, abs([Difference]) desc


Thanks again!!

Robert Ilechuku

• Next in forum: get some rows into one column
• Prev in forum: Re: Open SQL 2005 database question
• Thread view: Re: Error message on using union statement with order by using reserved words

[Reply to this message]