Good afternoon, It has been a while since I worked with linked servers, but here I find myself with this issue. I have a linked server that I am querying only one table called Street. What I need to do is to create a SP on my local server that will allow me to use this linked server.
For instance, on the linked server, the Street table has the following fields that I use: RecordID, Prefix, Name, Type and Suffix. In the local server, I have a table called Bus_Routes. That has the following fields: Schedule_ID, School_Id, Route_ID, Main_St_ID, X_Street_ID The fields Main_St_ID and X_Street_ID link to the RecordID field in the Street table on the linked server. The Street table on my linked server is updated by another application at another location so all I am doing is reading from this table. I need to pull Prefix, Name, Type and Suffix based on the RecordID from the Bus_Schedules table. I am building a string that will look like this: N Main [EMAIL PROTECTED] Elm Rd. I know how to build the string. I just need to know how to query the linked table by joining the local table. Hope this makes sense Bruce ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2962 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
