I usually copy and paste the results of a query into excel and then data import the excel into sql for my newly constructed table.
Sometimes the data types and formatting get screwy. I have a new query that results a ton of columns so putting them into excel and reformatting them is a pain in the butt.
I have no destination table created for the results of this query. I the resulting table to be permanent so would like to avoid temp tables unless that would be an intermediary step. I would also like to forgo creating the new table before i insert it into one. That being said...
any ideas. i need the columns names and datatypes.
im open to anysuggestions...
if i have to create a table i can. my query has over a hundred columns though.
Thanks a ton!