There is no single answer to your question as it all "Depends". Without further information, any response will be pure guesswork!

😎

To Steve's good point, you are working with set-based data,...

My hunch was right, you are running a database in full recovery mode without log backups! This is not good!

😎

Instead of writing the full instructions here as the documentation and...

We will need your help in order to be able to help you, so please help us!

😎

It would be greatly appreciated if you could provide the DDL (create table) script,...

This is the first part of the information we need

😎

and then also this part

thanks Everyone i have tried using above left outer join using power bi and this resolved my issue with conditional formatting.

From next time i will try to post as...

Thanks!

I am pretty sure that the log is the problem. Theese DB's were created in 2011, and the logs are pretty big.

And i do not need them anyway.

Which restore...

Quick question, what is the recovery model of the database?

😎

Just further on this subject for the sake of completion, what if entries are deleted?

😎

Here is a simple suggestion:

USE TEEST;
GO
SET NOCOUNT ON;
GO
---------------------------------------------------------------------
-- https://www.sqlservercentral.com/forums/topic/compare-2-tables-and-highlight-where-the-column-values-has-been-updated
---------------------------------------------------------------------
-- Sample data set
---------------------------------------------------------------------

DECLARE @SNAP01...

This problem is absolutely elementary but the answer would have been here sooner if the OP had posted the requested DDL and data!

😎

Most of us are far too busy to...

Quick thought, the results do not match the data posted unless there is some hidden logic 😉

We will need your help in order to be able to help you, so...

The answer should be: "strips all leading '9' from the input 😉

😎

This method is useful when dealing with prefixes like leading zero.

An additional data file will be used if it is in the same filegroup as the existing data files.

😎

You might want to look into creating a new filegroup for indices...

Suggest you start by reading the documentation 😉

😎

Can you please post the DDL (create table) script, sample data as an insert statement and the desired output from the sample data?

😎

When it comes to validating users’ input, dynamic SQL or not, I like to use the belt and braces method of validating the input by running it through...