hey guys! i need a little sql help/advice. i have a table that has 2 columns from_zip to_zip
i get xls files from people in the office with massive zip entries. like: Zip Code 20106 22002 22401 22402 22404 22407 22408 22412 i want to go through this file and create the from/to fields... from_zip to_zip 20106 20106 22002 22002 22401 22402 22404 22404 22407 22408 where do i start.... i can import the xls as a new table in sql server. then i would like to great a view to do the from to by a id that i have... not sure if i am explaining this right at all... thanks for your help.. -m ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297458 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
