Yes each code would be unique to the set of decisions that were made.

Thanks for your help.

I can be anything: view, stored procedure, scalar function, etc. It doesn't matter to me.

Yes that exactly what I'm trying to do. Return a single code from a list...

Actually what I did was use the CHECKSUM_AGG() function on product Id. I then did a distinct query to get the individual store records. Even though the CHECKSUM_AGG() value changes...

I had the same problem...

I went to the logs located: Microsoft SQL Server\MSSQL10.\MSSQL\Log and saw that i was getting a login failed for the user MYDOMAIN\MYMACHINENAME$. All I did...