Hi!

It's a decentralized system that tracks activity of some sort. Each local server gathers stat into its, local, DB, then relay it to the central server.

Old technology, but it works...

Thanks so much to everyone who replied!

• This reply was modified 2 years, 2 months ago by  nkat.

please, disregard this question, it was badly composed

Thank you, ratbak for the idea! I will learn from it

Hello!

Thank you, Thom for your questions!

Do all the linked servers definitely have the table dbo.qc in the database w?

Are all these objects exactly the same definition? 

The answer is yes to...

• This reply was modified 2 years, 5 months ago by  nkat.

Thank you, ratbak! Sorry, but I can't really catch your drift. Do you mean that with dynamic SQL it is somehow possible to do FOREACH or write less code?

just to update and close the problem

LEAD(return_value ,offset [,default]) 
OVER (
    [PARTITION BY partition_expression, ... ]
    ORDER BY sort_expression [ASC |...

Thank you everybody so much and especially @ScottPletcher for the invaluable input. I studied your approach and learned a lot from it!

Please, consider the following code

/* input *********************************/DECLARE...

• This reply was modified 2 years, 5 months ago by  nkat.

Very special thanks for the technique to check what dynamic produces!

It woks, thank you everybody!

Thank you, Jeff! I'll look into dynamic approach.

Thank you Jeff, for your follow-up!

The entire table might exist or not. The reason for that—versions of the particular app, so the query must be just one but run in...

Exactly! there's no way to nest 'with', but one can chain them.

Thank you!

found the answer

https://stackoverflow.com/questions/18010850/sql-with-clause-within-a-with-clause

Happy coding!

USE [LSWDS]
declare @tt table (dt date, QueueName varchar(10), Prm varchar(10))
insert into @tt(Dt, QueueName, Prm)
values
('2001-04-04','Queue0001','Q1P01'),
('2001-04-05','Queue0001','Q1P01'),
('2001-04-06','Queue0001','Q1P02'),
('2001-04-07','Queue0001','Q1P02'),
('2001-04-08','Queue0001','Q1P03'),
('2001-04-09','Queue0001','Q1P03'),
('2001-04-04','Queue0002','Q2P01'),
('2001-04-05','Queue0002','Q2P01'),
('2001-04-06','Queue0002','Q2P01'),
('2001-04-07','Queue0002','Q2P01'),
('2001-04-08','Queue0002','Q2P01'),
('2001-04-09','Queue0002','Q2P02');

with sinceQueueDate (QueueName,Prm,SinceDt) as
(
  select distinct QueueName, Prm, FIRST_VALUE(Dt) over(partition by QueueName,Prm order...