Additionally, I want to run some additional queries off of that data that is returned from the SQL Server. I have concluded that the easiest way may be to create a temporary table that I can ...

This example creates a temporary table with a single column called tempId (the # at ... Listing 1: A General-Purpose T-SQL Function for Splitting Up Strings Create Function [dbo].[fnSplit] ( @List ...

Use temp tables to improve cursor performance ... It’s common practice to return the results of a scalar function as a column in a SELECT query. SQL Server Enterprise offers “partitioning ...

By using the nomenclature #localtable or ##globaltable SQL Server knows to create a table in TempDB. If you use a local temp table, it is only available for your current session. If you create a ...