As far as I'm concerned, SQL History works much the same way Tab history used to except that it's much more flexible and easy to use. I really don't see...

There's a good explanation of SQL injection (and how to prevent it) here.

https://www.sqlinthewild.co.za/index.php/2009/04/03/dynamic-sql-and-sql-injection/#more-230

I don't rent music. I like having the physical medium along with the cover artwork and lyrics (if provided).

Just last week I added 6 hour "meetings" to my calendar on 2 days a week just to preserve some time to do "proper" work. I can still accept invitations...

I always assumed we were supposed to answer them without pasting the code into SSMS. Otherwise you're just...

Our C# developers (who know just enough SQL to be dangerous) write code using Entity Framework and I have trust that Microsoft will generate good SQL. So far so...

I wrote an application years ago that loaded data from spreadsheets, stored it in a database, mashed it around a bit and then produced reports. It took around 5 minutes...

Why bother? Because 2 years after implementing the system, the data volume had increased to the point where the overnight batch ran well into the following morning (who'd have thought...

• This reply was modified 4 years, 3 months ago by Chris Wooding.

On a slightly separate point; I sincerely hope the appointment data you provided is invented data for a dev/test database rather than production as it looks as if it contains...

In case anyone else comes across this as the solution to a similar problem, I had to add ral.id to the partition in order to get it to work with...

Thanks. That works perfectly.

So I would have an Ingredient table (IngredientKey, IngredientSK, IngredientName, Category, UnitPrice, ActiveDate) and then use FILTER() and/or TOPN() to get the most recent active Ingredient value relative to...

I think your Ingredient table containing the price should be set up as a slowly changing dimension (even if it changes fast). That way the Recipe fact doesn't have to...

I think the problem is that you're trying to use the same parameter for two procedures that are running concurrently. You'll need to have a separate set of parameters for...

A few things occur to me.

1. Read the ImportHistory table before attempting to load the file. That way, if the file has already been loaded, nothing needs to be rolled...