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 8 hours, 45 minutes 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 4 days, 2 hours 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 weeks, 4 days 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 2 weeks ago by pietlinden.
• This reply was modified 2 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...

I can understand returning random *rows* from a table, but what's the use case for returning random *columns*??? That's just odd.

Wasnt that the gist of Firefox? (I know, I should have actually read it!) but it was supposed to be an fighter jet that you controlled with your mind... and...

CROSS APPLY is analogous to INNER JOIN,

OUTER APPLY is analogous to OUTER JOIN

there, fixed it for you

I checked the obvious way -- through my profile, but there's no way to filter them for keywords etc. =(

Use Google. LOL.

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