Alternative to SQL Server Query statement
I tested Solution 1 and it does not return the result set that you required.The Stored Procedure below has been tested and returns the result set that you showed in your example. Create this Stored Procedure in your SQL Server database and execute the Stored Procedure in your program. The...
SQL Optimizer for Visual Studio: Automatically make your queries faster using this extension from Quest Software