Huh! That's a really clever approach (of course relying in the implicit ordering of those tables). Very interesting food for though. But yeah, maybe I should just push for a...

That's very helpful. Thanks for taking the time to put that together for me.

Sergiy (12/7/2016)

You may have many identical indexes, all with different names.

To check if an index with the same structure as...

I figured out a solution

if exists (select 1

from sys.indexes

...

Well that's the first part of it, yes. But what I really want to check is if it's already on the partition scheme.

The table already has a clustered index which...

Thanks for pointing that out.

Use it to your heart's content.

Here's my approach. Forgive the verbosity, the only way I can think through string manipulation in SQL is to do it in steps.

-- fictious source data

;with src as

(

...

Gotcha. Unfortunately, that function doesn't have the same signature as the one in your original code sample. I modified the function to accept all three parameters (start, end and increment;...

Could you provide the code for TallyGenerator? Since I'm not actually trying to just generate random numbers, it's difficult to see where I'd slot in my legitimate symbols, or how...

Ew... you're right. Nice catch.

Hi Erikur,

Thanks again for the reply. To preface this, your post was VERY helpful, and I doubt I would have got to the version I'm happy with now without your...