Use the SELECT...INTO...FROM... syntax, e.g.:

SELECT <select list from your query here>

INTO ##TempTable

FROM <rest of your query here>

--Jonathan

quote:

---

how about Multiple columns

such as

declare @OrderBy varchar(200)

set @OrderBy = 'FIRST_NAME,LAST_NAME'

END SELECT * FROM RESOURCE

order by case @OrderBy

WHEN 'FIRST_NAME,LAST_NAME' THEN FIRST_NAME,LAST_NAME

...

SELECT CAST(LEFT([Date]+19000000,8) AS datetime)+STUFF(STUFF(REPLACE(STR([Time],6),' ',0),5,0,':'),3,0,':')

FROM StrangeDates

--Jonathan

There's a good list here:

http://www.sqlsecurity.com/DesktopDefault.aspx?tabindex=3&tabid=4

--Jonathan

Use a CASE expression, e.g.:

...

ORDER BY CASE @OrderBy

 WHEN 'Col1' THEN Col1

 WHEN 'Col2' THEN Col2

 WHEN 'Col3' THEN Col3

 ELSE 'Col4' END

If the columns are...

See if you can get it working using bcp interactively and then use the generated format file with BULK INSERT.

--Jonathan

Not sure I understand your question, but did you try SET QUOTED_IDENTIFIER OFF at the beginning of the script?

--Jonathan

quote:

---

but is there a way of changing the underlying default so I don't have to run a convert?

---

--Jonathan