>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?
There's no setting because table is always created by SELECT INTO regardless how many records are returned.
--sb--