Tim Riley-492074
SSCommitted
Points: 1549
More actions
October 26, 2007 at 8:24 am
#176603
I need to create a view combining data from two different libraries on an AS400. I already have linked servers, (SAL and SQS), to the libraries, but I can't figure out how to use them within the T-SQL.
Grant Fritchey
SSC Guru
Points: 398880
October 26, 2007 at 9:47 am
#745795
CREATE VIEW x
AS
SELECT * from linkedserver..schema.table
Works great.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"- Theodore Roosevelt
Author of:SQL Server Execution PlansSQL Server Query Performance Tuning
October 26, 2007 at 9:53 am
#745799
Boy, now I feel really stupid:blush:
Thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply