Lynn Pettis (8/16/2012)
Here is the problem we face, we can't see what you see. You are using a temporary table, great. Are you exporting directly from the table using a query? Based on what little you have provided, probably. Well, how is the data getting INTO the temporary table? Are you running a query to populate this table or is the data just magically appearing in the table for you? If you are using a query, use that query in the Import/Export wizard to create your csv file.
in my task, i need to load into temp table by year wise and then join to actual table. so i am using temp table
and thats why i having some trouble