(SQL Server 2000)<BR><BR>I have a query that basically selects a lot of "complicated" stuff and then dumps it into a #temp table.<BR><BR>I then have a correlated subquery that runs against the temp ...

I have a result set stored in #Results.<BR><BR>Now I need to add MORE records to that #Results table.<BR><BR>The first query selects all of our employees and stores it in #Results.<BR><BR>Now what I ...

A free tool to reduce coding for developers who like to surface T-SQL database recordsets in a simple collection of customized POCO objects. Every so often, I find myself wishing that I had a utility ...

See performance gains by using indexed views in SQL Server Your email has been sent A view is a saved T-SQL query in SQL Server. The view definition is stored by SQL Server so that it can be used as a ...