Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails
select (a.balance + sum(s.amount) - sum(s.payoutamount)) balance from account a inner join subtransaction s on s.accountid = a.id and s.payoutaccountid = a.id where year(s.subdatetime) = '2009' and month(s.subdatetime) = '04' group by a.balance
|How to extract substring from string using CHARINDEX in SQL Server 2008R2||28||75|
|T-SQL - Get Same Address1 with Different Address2||6||24|
|SQL Where not exists in same table||3||32|
|Testing connection to sql||7||35|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
19 Experts available now in Live!