1 Resources for

totalsalesamount

Sponsored White Papers, Webcasts, and Downloads

Using SQL Server 2008's MERGE statement: Can you get the Identity key back?This is a great idea. It can reduce the "CU" of my CRUD stored procedures to have one for both create and update.When doing the "WHEN MATCHED", can you do a begin/end block there so that you can capture the @@IDENTITY value?YesYou could do...; Tags: Paul C., Using SQL Server 2008, SELECT CustomerID, TotalSalesCount, TotalSalesAmount, GetDate, LoadDate; Discussion threads 2007-09-25

Using SQL Server 2008's MERGE statement: SQL Server 2008's new MERGE statement allows you to insert, update, or delete data based on certain join conditions in the same statement. In previous versions of SQL Server, you have to create separate statements if you need to insert, update, or delete data in one table based on certain conditions...; Tags: Microsoft SQL Server, Data, Statement, Table, SQL Server 2008, MERGE, MERGE Statement, Tim, Sales Strategy, Sales Force Management, Databases, Enterprise Software, Sales, Software, Data Management, Tim Chapman; Blog posts 2007-09-24

Troubleshooting Patch Cables Power Checklist: Call them what you want: patch, Ethernet, category 5, or even cat 5e cables. Regardless of the moniker, Ethernet patch cables perform the bulk of the ...; Buy Now

Windows XP vs. Mac OS X: This presentation, entitled Standardizing on Windows XP Instead of MAC OS X, provides a pre-packaged option for defending Windows XP against MAC OS X. ...; Buy Now