sql query
i have a table which has got market name, balance and datediff shows how many day between getdate() - invoice date
select market,convert(varchar,convert(money,sum(balance),1)) as [AR Receivables] from #arreceivables group by market order by market

i am trying to get like eg: market name total balance between 0 -30 days 30 -60 days, 60 -90 days and 90 + days.

Can someone help me with the query please
0
LVL 33

Comment

by:Brian B
You have entered this as a post, but it looks like you are asking for help. To get the best response from the Experts, you should probably re-submit this as a question using the "ask a question" button at the top of the page, or this link: https://www.experts-exchange.com/askQuestion.jsp

If you do ask a question, please post the link to it back here so others can find your question and help you more quickly.

Please see here for further details: http://support.experts-exchange.com/customer/portal/articles/756544-how-to-succeed-at-ee-as-an-asker
0

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month