No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
5 Posted Topics
Here is a statement that will return the correct results for you: SELECT et.ExpenseType, ISNULL(SUM(er.Cost),0.00) as Cost FROM ExpenseType et WITH(NOLOCK) LEFT OUTER JOIN ExpenseRecord er WITH(NOLOCK) ON er.ExpenseTypeId = et.ExpenseTypeId GROUP BY et.ExpenseType The query will return all data from the ExpenseType table (where you have identified the types …
For many years, I have been a server-side/database developer. I want to start doing more client-side development. But I can't seem to find much information concerning the overlap between ASP.Net and JavaScript. Can someone point me to any books/videos about how to do this? I know that using some constructs …
I suggest that you try Pluralsight at http://www.pluralsight.com Pluralsight has numerous training videos on C# and VB.Net.
From the information you have supplied, I cannot tell for sure what you are trying to do. Where is the Access database located, on your local machine or on the server? If you are trying to insert data into a local Access database, you can do this directly in Access …
I have found Pluralsight to be excellent. They have numerous courses on C# and SQL Server. http://www.pluralsight.com
The End.