Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Local table used in remote queries?
Hi all
I have a situation. I have a table of IDs on a local drive. I want SQL Server to return records matching those IDs. There are possibly too many for them to be concatenated into a string. Can I have SQL create a table for a particular user, append these records, use that table in one or more other SPTs and drop that table when I'm done?
If so, can you provide a small example?
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