Happy New Year, Threadizens.

It's been ages since I had enough time to visit here and actually post something, and I wasn't sure if I'd have time today but there were...

• This reply was modified 1 month, 3 weeks ago by  ChrisM@Work.

I am looking  for an example on how to query several tables, around 50 tables, to find all unique records between them. I cant find anything other than a...

Here's exactly what I meant by using Paul White's method to grab the first column values only, then using that result set as the source for further processing. The first...

I can understand SQL having to scan the table / index, but I don't see why SQL would need to do a sort.  Btw, an asc index will...

I'm looking at that, but it's not going well. I have three columns,...

Here's one way of obtaining the distinct first-column values without performing an index scan.

https://www.sqlservercentral.com/forums/topic/calculating-interest-query/page/4/#post-1244493

Oh yeah, I forgot about the filter. It's actually the same filter as is used in my original query, but I forgot to put it back in when testing...

All the indexes show non-clustered. I'm sure I had a clustered index on this originally, but I've done a good bit of expermenting with this table, and probably forgot...

That index is seriously wide, and filtered. It will only be used by queries which have the same filter.

What proportion of the table columns does it include?

What's the clustered index...

• This reply was modified 6 months ago by  ChrisM@Work.

I think the optimiser doesn't use the index because there's no benefit in doing so. If you scale up the row count to something sensible and add a column to...

SELECT a, MAX(CAST(b AS varchar(2)) + c) 
FROM (VALUES 
	('A', 1, 'a'),
	('A', 1, 'b'),
	('A', 1, 'c'),
	('A', 2, 'a'),
	('B', 1, ''),
	('B', 1, 'a'),
	('B', 1, 'b'),
	('B', 2,...

• This reply was modified 6 months ago by  ChrisM@Work.

SELECT a, MAX(CAST(b AS varchar(2)) + c) 
FROM (VALUES 
	('A', 1, 'a'),
	('A', 1, 'b'),
	('A', 1, 'c'),
	('A', 2, 'a'),
	('B', 1, ''),
	('B', 1, 'a'),
	('B', 1, 'b'),
	('B', 2, ''),
	('C', 1,...

If the symbols were the other way around it could be a graphic of a euphemism for falling over.

Your result set is dependant upon an order  yet your source data has no column defining this order. Is there such a column?

If so, can you provide a script to...

Thanks for response. So if I understand it correct from the above ....

one block of insert for locations and another for individuals

INSERT into dbo.Locations ...SELECT ....FROM dbo.HouseholdTemp WHERE <conditions>...