I am sending a select statement such as:

Select * into #mytemptbl from mytable where {condition}

but the select has no records matching my condition. But I still need the temp
table created.

Is there a setting to make the table even if the result set is empty?

Peter