I have data in a text file that contains the Lender Number.
789 $4,000 May 2008
456 $5,000 May 2008
I require the Lender name that is contained in the Lender table (Lender No
is the Primary Key).
789 LenderABC
456 LenderQLE
How do I setup a query that joins the results in the text file to the Lender
Table to obtain the Lender number for all the records in the text file?

You could create a linked server to the flat file, but the performance would
likely not be very good. I'd create a table for the lender stuff, bulk
insert the file and then join onto the table. Don't forget to index the
table appropriately.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Query Analyzer User" <Query Analyzer User (AT) discussions (DOT) microsoft.com> wrote
in message news:5AC494E9-9C07-4C47-85CA-E6DB2C17066D (AT) microsoft (DOT) com...
I have data in a text file that contains the Lender Number.
789 $4,000 May 2008
456 $5,000 May 2008
I require the Lender name that is contained in the Lender table (Lender No
is the Primary Key).
789 LenderABC
456 LenderQLE
How do I setup a query that joins the results in the text file to the Lender
Table to obtain the Lender number for all the records in the text file?

You could create a linked server to the flat file, but the performance would
likely not be very good. I'd create a table for the lender stuff, bulk
insert the file and then join onto the table. Don't forget to index the
table appropriately.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Query Analyzer User" <Query Analyzer User (AT) discussions (DOT) microsoft.com> wrote
in message news:5AC494E9-9C07-4C47-85CA-E6DB2C17066D (AT) microsoft (DOT) com...
I have data in a text file that contains the Lender Number.
789 $4,000 May 2008
456 $5,000 May 2008
I require the Lender name that is contained in the Lender table (Lender No
is the Primary Key).
789 LenderABC
456 LenderQLE
How do I setup a query that joins the results in the text file to the Lender
Table to obtain the Lender number for all the records in the text file?

You could create a linked server to the flat file, but the performance would
likely not be very good. I'd create a table for the lender stuff, bulk
insert the file and then join onto the table. Don't forget to index the
table appropriately.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Query Analyzer User" <Query Analyzer User (AT) discussions (DOT) microsoft.com> wrote
in message news:5AC494E9-9C07-4C47-85CA-E6DB2C17066D (AT) microsoft (DOT) com...
I have data in a text file that contains the Lender Number.
789 $4,000 May 2008
456 $5,000 May 2008
I require the Lender name that is contained in the Lender table (Lender No
is the Primary Key).
789 LenderABC
456 LenderQLE
How do I setup a query that joins the results in the text file to the Lender
Table to obtain the Lender number for all the records in the text file?

You could create a linked server to the flat file, but the performance would
likely not be very good. I'd create a table for the lender stuff, bulk
insert the file and then join onto the table. Don't forget to index the
table appropriately.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Query Analyzer User" <Query Analyzer User (AT) discussions (DOT) microsoft.com> wrote
in message news:5AC494E9-9C07-4C47-85CA-E6DB2C17066D (AT) microsoft (DOT) com...
I have data in a text file that contains the Lender Number.
789 $4,000 May 2008
456 $5,000 May 2008
I require the Lender name that is contained in the Lender table (Lender No
is the Primary Key).
789 LenderABC
456 LenderQLE
How do I setup a query that joins the results in the text file to the Lender
Table to obtain the Lender number for all the records in the text file?

You could create a linked server to the flat file, but the performance would
likely not be very good. I'd create a table for the lender stuff, bulk
insert the file and then join onto the table. Don't forget to index the
table appropriately.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Query Analyzer User" <Query Analyzer User (AT) discussions (DOT) microsoft.com> wrote
in message news:5AC494E9-9C07-4C47-85CA-E6DB2C17066D (AT) microsoft (DOT) com...
I have data in a text file that contains the Lender Number.
789 $4,000 May 2008
456 $5,000 May 2008
I require the Lender name that is contained in the Lender table (Lender No
is the Primary Key).
789 LenderABC
456 LenderQLE
How do I setup a query that joins the results in the text file to the Lender
Table to obtain the Lender number for all the records in the text file?

You could create a linked server to the flat file, but the performance would
likely not be very good. I'd create a table for the lender stuff, bulk
insert the file and then join onto the table. Don't forget to index the
table appropriately.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Query Analyzer User" <Query Analyzer User (AT) discussions (DOT) microsoft.com> wrote
in message news:5AC494E9-9C07-4C47-85CA-E6DB2C17066D (AT) microsoft (DOT) com...
I have data in a text file that contains the Lender Number.
789 $4,000 May 2008
456 $5,000 May 2008
I require the Lender name that is contained in the Lender table (Lender No
is the Primary Key).
789 LenderABC
456 LenderQLE
How do I setup a query that joins the results in the text file to the Lender
Table to obtain the Lender number for all the records in the text file?

You could create a linked server to the flat file, but the performance would
likely not be very good. I'd create a table for the lender stuff, bulk
insert the file and then join onto the table. Don't forget to index the
table appropriately.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Query Analyzer User" <Query Analyzer User (AT) discussions (DOT) microsoft.com> wrote
in message news:5AC494E9-9C07-4C47-85CA-E6DB2C17066D (AT) microsoft (DOT) com...
I have data in a text file that contains the Lender Number.
789 $4,000 May 2008
456 $5,000 May 2008
I require the Lender name that is contained in the Lender table (Lender No
is the Primary Key).
789 LenderABC
456 LenderQLE
How do I setup a query that joins the results in the text file to the Lender
Table to obtain the Lender number for all the records in the text file?

You could create a linked server to the flat file, but the performance would
likely not be very good. I'd create a table for the lender stuff, bulk
insert the file and then join onto the table. Don't forget to index the
table appropriately.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Query Analyzer User" <Query Analyzer User (AT) discussions (DOT) microsoft.com> wrote
in message news:5AC494E9-9C07-4C47-85CA-E6DB2C17066D (AT) microsoft (DOT) com...
I have data in a text file that contains the Lender Number.
789 $4,000 May 2008
456 $5,000 May 2008
I require the Lender name that is contained in the Lender table (Lender No
is the Primary Key).
789 LenderABC
456 LenderQLE
How do I setup a query that joins the results in the text file to the Lender
Table to obtain the Lender number for all the records in the text file?

You could create a linked server to the flat file, but the performance would
likely not be very good. I'd create a table for the lender stuff, bulk
insert the file and then join onto the table. Don't forget to index the
table appropriately.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Query Analyzer User" <Query Analyzer User (AT) discussions (DOT) microsoft.com> wrote
in message news:5AC494E9-9C07-4C47-85CA-E6DB2C17066D (AT) microsoft (DOT) com...
I have data in a text file that contains the Lender Number.
789 $4,000 May 2008
456 $5,000 May 2008
I require the Lender name that is contained in the Lender table (Lender No
is the Primary Key).
789 LenderABC
456 LenderQLE
How do I setup a query that joins the results in the text file to the Lender
Table to obtain the Lender number for all the records in the text file?