If it doesn't return any rows, then I want to do a SELECT INTO #Temp with criteria B. Not sure if it matters, but the first SELECT returns 2 columns and the ELSE Select returns 3.

I tried this in the past, but didn't have any luck.Is it possible to create a temp table on a remote server?Situation:I have to run a group of queries against a remote server.The first query is a ...