As I mentioned earlier, I have stopped receiving e-mail notifications of replies, for some reason.

The actual procs are not named with numbers! They are named based on the tables they...

PQ can be used in many other places, including Power...

Something like this?

DROP TABLE IF EXISTS #product;
DROP TABLE IF EXISTS #VendorRank;

--Product table and data
CREATE TABLE #Product
(
    ProductID INT
  , ProductSKU INT
  ,...

Thanks, Brian. There is no parallelism requirement. The fact that T3 and T4 are at the same level implies only that they are independent of each other and can be...

Steve, thank you for taking the time to code and test this. I've not written many rCTEs in the past and my brain has trouble composing them. I'd tried and...

Wow, I just wrote a long response to Brian's message and after hitting Submit, I got an 'Are you sure you want to do that?' error and my text got...

I have not tested the script, but I am interested to hear of the use case.

Why would you do this in preference to simply doing a schema compare in a...

Are you requesting an article? Because that's the forum you're in.

Or simply regurgitating a load of AI-generated waffle?

I just set up five levels, and there's no end in sight, so that's a resounding 'yes'.

OK, so all of the steps need to be configured as 'On failure: go to the next step'

Your final step should be one which collects details of any execution errors...

Do you want the job to fail immediately, and stop, in the event of failure of any steps? Also, you want the e-mail to come from SQL Agent itself, is...

Yeah I did know we can do that but was hoping to understand more about why it is happening because some records are null and some are the blank...

I really don't know. But for a quick fix, you could try

select NULLIF(cast(col as varchar(128)),'') as column_name

OK. The source is SQL Server and it's a simple query?

SELECT col = cast(x as VARCHAR(50)) FROM tab1

sort of thing?

What is the target? SQL Server, Excel, CSV, ...