Hi Jeff.

Thank you for the fast reply. The business logic dictates that we would never have to identify a single row, per se. Using the 'garden' analogy i...

Thank you all for your replies and suggestions.

I am going to jump down the Table Valued Parameters rabbit hole to see where that leads.

Thanks again.

Hello Jeff.

No worries at all. I think the code/querying is working pretty well now.

Thanks for the followup and all your time and advice.

Tom

Hi Jeff.

Thank you for your follow up. I do greatly appreciate your time.

I am not sure if this is too much information, but hopefully it is helpful....

A...

Hi Wayne.

Thanks for the follow up.

I am always happy and eager to learn more techniques (for example, i had no idea that one could use 'between / and'...

Hi Jeff.

Thanks for your suggestion; it definitly sent me down what seems to be the right path. Not every location is associated with every segment so a 'straight-up' cross...

Here is a slightly more robust collection of Location data (at least it breaks the sequential nature of the data and adds a second 'key' value):

INSERT INTO location Values ('abc_123',...

I was pretty excited when I saw your first response, then reality set in .... You are right; the solution works because of the simplistic data set i provided....

Hi Wayne.

I apologize for being too casual and too quick on my original post. Below are some sample data and the code that i am currently using.

Sample data for...

Thank you all for your help. I took opc.three's suggestion and moved the newid() computation into the CTE. Now it works like hoped for.

Thanks again.

WITH CTE AS

(SELECT LOC_ID,...

@leju

I recently found out that when using RAND in a SELECT statement, the RAND number is always the same. That's why i am not using RAND.

Here is the...

Thanks for your quick reply.

I see the exact same behavior you describe when I set "(ABS(CAST(CAST(NEWID() AS VARBINARY) AS INT)) % 10)" to a parameter and then test the parameter.

However,...

First, thank you for your time. I do appreciate it.

The segment id is a varchar(24), and its value is assigned randomly-ish. There are some pertinent bits of info in the...

It was just coincidence / convenience regarding the order of segment IDs in the example I created. I think the method proposed by Celko wouldn't work out for that...

Thank you for the code and the article references. I am excited to read and understand both.

(I was a bit too casual in my table definition. I am using an...