I still prefer my single int as a metakey method.  16 bytes is a lot of overhead for a linking key.  I don't see an advantage to it.  And...

Like I said in the comments in the code...

     --...

Like I said in the comments in the code...

     -- You can...

It had a great run and built one heck of a community.  The community isn't dead and neither is the spirit of sharing knowledge that it inspired.  We're going to...

Oh my... now I understand why you were...

It's probably not a "table", Joe.  It's probably something that only looks like a table used to hold the results of a reporting query from somewhere.  Having VARCHAR(2) for both...

Ok, KT... here you go.  I made a million row table just for test purposes.  Although the use of HASH(MD5) is no guarantee of avoiding collisions forever, the "PIPES" in...

First, thank you for posting the readily consumable data that you did.  It made it a pleasure to help.

The following code will do the trick...

 SELECT *...

• This reply was modified 5 years, 4 months ago by Jeff Moden. Reason: Added partitioning by year, which is a bit necessary for YTD to Monthly calculations. :D

They do make it difficult to find. 😀

Please see the following link...

https://docs.microsoft.com/en-us/sql/ssms/agent/manage-job-steps?view=sql-server-ver15#transact-sql-job-steps

In that section of the article, you'll find the following (emphasis is mine)...

Transact-SQL job steps do not use...

While it seems...

Heh... it's not the security risk that people...

@pamkagel ,

Based on a phone call I got earlier today, do you work in Michigan, U.S.A.?  I ask because it basically the same question I was asked if I could...

I am using the below case statement

, CASE WHEN Attributes LIKE ',Size = %,' Then right(Attributes, len(Attributes) - charindex('Size ', Attributes)) ELSE '' END as Size

To get the below...

Thanks everyone.

As I'm developing under a deadline, I went with the first answer.  And I'm developing with limited data, and we are expecting no more than a few thousand...

The restore operation using WITH MOVE will allow you to rename the database and create new data files. However, the only thing that will change the code is changing...