06-12-2008
111,
0
Join Date: Dec 2007
Last Activity: 5 November 2015, 12:45 PM EST
Location: Gotham City
Posts: 111
Thanks Given: 1
Thanked 0 Times in 0 Posts
sql help
Hi all,
I have a sql like this.
select a, b from my_schema.my_table
where a in (
5000, 5001, 5002, 5003, 5004, 5005, 5006, 5007, 5008, 5009,
5010, 5011, 5012, 5013, 5014, 5015, 5016, 5017, 5018, 5019,
5020, 5021, 5022, 5023, 5024, 5025, 5026, 5027, 5028, 5029,
5030
);
Now i am expecting the values to grow. What i would like is if i can maintain a simple txt file which will store values like 5000,5001,5002,etc and if i can feed that txt file to the sql above. Is this possible?
Any help is appreciated
Thanks,
JAK