>Hi
>
>I think I've managed to confuse you - I'm not passing any parameters into this stored procedure.
>
>1. The tables are SystemDataDictionary and ApplicationDataDictionary.
>2. If there's a value in ApplicationDataDictionary.myField that's also found in SystemDataDictionary.myField then I'd like to include the record found in ApplicationDataDictionary.
>
>So if:
>
>ApplicationDataDictionary.myField = 1
>ApplicationDataDictionary.myField = 2
>ApplicationDataDictionary.myField = 3
>SystemDataDictionary.myField = 1
>SystemDataDictionary.myField = 4
>
>The resulting table would be
>
>myField = 1 (from ApplicationDataDictionary)
>myField = 2 (from ApplicationDataDictionary)
>myField = 3 (from ApplicationDataDictionary)
>myField = 4 (from SystemDataDictionary)
>
>Does that make more sense?
>
>Regards

Yes, go with my alternative solution and just add a partition by myField.