I start by asking the business what things they care about (nouns). I then request business definitions of all of those things. These things are either entities or facts of...

Why don't you just keep the latest backup table and delete the rest?

Try this:

SELECT        fd.Warehouse, I.StockCode, I.Description, fd.QtyOnHand, fd.QtyOnOrder, fd.DateLastSale

FROM        InvMaster AS I

JOIN    InvWarehouse fd

ON    fd.StockCode = I.StockCode

WHERE        '2016-09-01' > ALL (select isnull(DateLastSale, '2016-01-01') from InvWarehouse where StockCode =...

Have you tried '57590,12100' with the quotes?

Other considerations that I have had to make for TCO are that it sometimes takes multiple COTS products to "cover the ground". Individually, many of them are poorly architected. Collectively,...

I had a boss long ago that had a pendulum clock on the wall behind his desk. On a brass plate behind the pendulum was engraved "If you don't have...

The $DataSet that you are piping to Export-Csv is not in the same scope as the $DataSet that you filled. You might try removing the $DataSet within your loop and...

Thanks Stewart. I have always used identity columns as primary keys and never realized that it wasn't unique in and of itself.

Steve, I found something interesting (in SQL Server 2014). If I repeat the inserts after the reseed and select all rows from the table, I get duplicate rows numbered 1,2,3,1,2,3....

From a strictly product point of view I can understand and even agree with the decoupling. However, for those of us who have to maintain SQL Server instances that cannot...

I won't argue with your premise or your conclusion, but in this case a SQL Server provided function (assuming FirstNumber and SecondNumber are integers) and simple math would have solved the problem...

One thing that I have wondered about for years is how an open source OS can be secure. It seems to me that it makes it far less difficult for...

I am a proponent of tell, show, watch, let go when it comes to teaching almost anything. A well documented and organized toolbox can also help someone get up to...

I agree that 57418 (from the most current order) will be returned for each row and that all three rows will be returned. However, the list of answers to choose...

FYI, this trigger will fail if more than one row is updated with the update query because a select into a scalar variable cannot result in more than one value.