If U'll Learn to play with Variables U'll learn lot more.

DECLARE @Table NVARCHAR(128)

SELECT @Table =

   CASE Condition

      WHEN 'Condition 1' THEN 'Table1'

      WHEN 'Condition 2' THEN 'Table2'

      ELSE 'Table3'

   END

EXEC('SELECT...

Hi,

U can give breath to you will. Simply make a Stored Procedure. I'm giving the smaple query as below...

CREATE PROCEDURE mst_spJoinTableConditionally

@Condition NVARCHAR(2000)

AS

DECLARE @Table NVARCHAR(200)

SELECT @Table = CASE @Condition WHEN...

Hi jmowery 

If there is proper Indexing on working tables then it must improve the performance.

There is Simple concept behind Indexing. Make...