Can't you download the software from maybe github or did you need the physical media?

How to obtain the latest service pack for SQL Server 2014 - SQL Server |...

Why create a UDF for something that trivial? You could just write the query without it like this:

SELECT t.CustomerID, t.CustomerName, t.MinimumOrderValue, mo.OrderValue
FROM dbo.CustomerThresholds t
CROSS APPLY (
SELECT o.OrderValue
FROM...

Which version did you want? Took me a minute or two to find some sources...

Microsoft SQL Server All Versions Direct Download Links [2008, 2012, 2014, 2016]

Here? Download Microsoft® SQL Server® 2022 Express from Official Microsoft Download Center

I would think so.

Especially if VendorsAssignedToTask  is properly indexed. (One would think it would be indexed on both TaskID and VendorID). Best way to check is to show the execution...

• This reply was modified 3 weeks, 2 days ago by pietlinden.

I was asking about a "VendorTask" table because I was thinking "what happens the next time we need to do this, but for a different task?" If you have a...

Looks like you're missing a table... the "Assignment" table...

CREATE TABLE Assignment(
AssignmentID INT IDENTITY,
TaskID INT NOT NULL,
VendorID INT NOT NULL,
DateCompleted DATE
PRIMARY KEY (TaskID, VendorID)
FOREIGN KEY (TaskID) REFERENCES Task(TaskID),
FOREIGN...

• This reply was modified 3 weeks, 5 days ago by pietlinden. Reason: Not sure I know how to speak English

I think you could do it sort of like this... (well, the gory details are a bit off, but the core structure is close). Basically, you'd create your SQL statement...

Ray,

Could you post the solution you came up with? Just wondering how you did it.

So maybe do everything inside a stored procedure, write the results to a temporary table, and at the end, query that table? (Only really necessary if the data changes all...

• This reply was modified 1 months ago by pietlinden.

(writing this article now seems like a bit late...?? I mean, The solutions have been in Itzik Ben-Gan's book on T-SQL for like 15+ years now. Gaps & Islands etc....

What do you want to do with the records returned from your query? If you want to update them, then you can't use a UNION query, because they're not updateable....

Steve,

isn't the only other option doing something like Scott started (return all the tables ending in "_Modify" and containing a column with the correct name), and then inserting the results...

What I want to do next, is to query each table in that result set for some criteria using that User column.

I don't really want to use a cursor to...

• This reply was modified 1 months, 1 weeks ago by pietlinden.
• This reply was modified 1 months, 1 weeks ago by pietlinden.

(But you have to start the counter table at 0 instead of 1 in order to include the first date.)

use tempdb;
go

DECLARE @StartDate DATE = '2026-01-01';

SELECT value, DATEADD(day,value,@StartDate)
FROM...