1 Resources for

totalsalescount

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

Windows XP Network Troubleshooting Power Checklist: Windows XP is pretty easy to connect to a network. Sometimes, however, things just go awry. That's when you need a strategy. This power checklist walks you through how to figure out what's wrong with Windows XP networking and how to get it fixed.; Buy Now

Windows Server 2003 Migration Tool Kit: This product sells with B061- Windows Server 2003 Migration Pack and can not be sold separately.; Buy Now