> I apologize, I am used to using PHP and MySQL so I am a little out of
> what I am used to
>
> At work they asked me to help them with something and thus I am here
> asking for your assistance :)
>
> We have a Database that we use with SQL 2000
>
> In this database is a very simple table
>
> UserID, EmpNum, FirstName, LastName
>
> I have a comma delimited file of about 8000 Employee Numbers.
>
> I need to run a query to get the UserID, FirstName and LastName for those.
> Of course a 1 at a time query is no problem, but I have NO CLUE how to go
> about getting it to run a query on all of the Emploee Numbers that are in
> this CSV file and compiling a report

Erland Sommarskog <sommar@algonet.se> wrote in message news:<Xns94B111493057Yazorman@127.0.0.1>...
> Cliff Roman (cliffno_spamnone@theromans.us) writes:
> > I apologize, I am used to using PHP and MySQL so I am a little out of
> > what I am used to
> >
> > At work they asked me to help them with something and thus I am here
> > asking for your assistance :)
> >
> > We have a Database that we use with SQL 2000
> >
> > In this database is a very simple table
> >
> > UserID, EmpNum, FirstName, LastName
> >
> > I have a comma delimited file of about 8000 Employee Numbers.
> >
> > I need to run a query to get the UserID, FirstName and LastName for those.
> > Of course a 1 at a time query is no problem, but I have NO CLUE how to go
> > about getting it to run a query on all of the Emploee Numbers that are in
> > this CSV file and compiling a report
>
> You could build a string from the file, and then use the function
> iter_intlist_to_table on
> http://www.sommarskog.se/arrays-in-sql.html#iter-list-of-integers.