Page 1 of 1

Pass values from file to WHERE clause

Posted: Thu Sep 10, 2009 5:11 am
by pratyusha
I have a flat file which has some 20 values in it. I have to run a query for these 20 values. So these values need to come into a WHERE clause. I have searched the forums to check for an answer but I am not able to find one. Is this approach possible? Can any one please suggest some ideas?

These values would be updated everyday. So I run a job to load the values into the flat file and then run another job with these new values.

Thanks
Prathyusha

Posted: Thu Sep 10, 2009 5:50 am
by chulett
If this is truly a Server job question as marked rather than a TX question per the forum of choice, then you've posted in the wrong forum and you need to repost it over in the actual Server forum.