SELECT * INTO new_table FROM old_table WHERE last_name LIKE 'Ja%'; GO The LIKE keyword allows you to filter results based on a wildcard expression. In this example, Transact-SQL will create a new ...

If you’ve got several sources of data that you need to get into ... SELECT * FROM #dataTMP GO DROP TABLE #dataTMP You’ll need to change the table schema to match your data of course, but this ...

So, it looks like you can't do a statement like this:<BR><BR>IF <BR> SELECT *<BR> INTO #Temp<BR>ELSE<BR> SELECT *<BR> INTO #Temp<BR> WHERE....<BR><BR>What the best way to work around this?

BR><BR>Anyway I could do another select query from tbl_ContractedEmployees and then INTO #Results ... BR><BR>(Granted this is a crappy example, but you get the idea).<BR><BR>My real world issue ...