/nod

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...