General information
Forum:
Microsoft SQL Server
Environment versions
SQL Server:
SQL Server 2005
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only