Monthly Archives: April 2008

Inserting Results of a Stored Procedure/Function into a temp table

How to insert the result of a SP into a temp table without declaring the table or without knowing the output values’ data types? So here is the solution: We have OPENQUERY () function, generally used to query the Linked … Continue reading

Posted in SQL Server | 3 Comments

SQL Server: Using CASE statement in Order By clause

Hi, I have come across a nice functionality to be used in SQL Server. Sometimes we need to order the records in some sets, like if there are 100 records, we may need to show 50-55 records IDs first, then … Continue reading

Posted in SQL Server | Tagged | 10 Comments

SQL Server 2008

Hi All, I have just added a new category for SQL Server 2008 related comments, suggestions and queries.

Posted in SQL Server 2008 | 3 Comments