Posted by markc600 on 12/18/06 16:30

select date,
user,
sum(case when transaction_type ='debit' then amount else 0 end)
/
sum(amount) as perc_Debit
from mytable
group by date, user

• Next in forum: Re: Help!? Combining SQL Queries? Can it be done??
• Prev in forum: Re: Weird millisecond part of datetime data in SQL Server 2000
• Thread view: Re: Help!? Combining SQL Queries? Can it be done??

[Reply to this message]