Re: [sqr-users] How can I sneak a text file into a load-lookup?

[Leon Shraibman <leon.shraibman@gmail.com>]

Oops did not see notes. Create a temp table?

On Feb 11, 2010 2:46 PM, "Simon, Jason (MBS)" <
Jason.Simon@mortgagefamily.com> wrote:

Hey Everyone,

           I need some help please.  I have to use a text file with
about 3k rows in it to exclude data from my final output in a report.
This text file changes on a daily basis. A text file was thought to be
the easiest way for the end users to add and remove names from the list.
:(    Normally, I would just loop through the data one row at a time
comparing the two text fields to each other and setting a include flag
based on the comparison.  As you can already see though the time it
takes to do this comparison is way too long.  If I can somehow get this
text file into a load-lookup I can do this comparison much faster.  I
was thinking that if I could build a query that uses a fake table like
dual and trick the load-lookup into accepting it my life would be much
easier.



Notes:  I cannot create tables or do any other changes that require
admin rights.  We use both oracle and sql server databases.



Please HELP!

Thanks

Jason

http://sqrhelpers.wordpress.com/

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users