question

@dwcarr89 There is no any short hand for case statement per se, but it is occasionally possible to restate the query in such a way that the repetitive case statements are outsourced to yet another CTE. This may make the query look cleaner because there is but only one long case statement instead of multiple repetitions of the same, but will probably NOT make it any faster. The machines have no problems with parsing long, complex case statements without slowing down a bit, so there is no performance benefit from restating the query to reduce the line count and/or number of times the case statement is spelled out repetitively, but there certainly is a benefit for us, the wimps (a.k.a. humans :) ), any time we can make the query look simpler and easier to maintain. Please post your query as an attachment to your question (cleanup/obfuscate the object names if necessary), maybe someone can come up with the solution to reduce the number of repetitive case statements.

@dwcarr89 One way I can think of off the top of my head would be to Declare a variable and set the variable to resemble your Case statement e.g Declare @Casestmt Varchar(4000) SET @Casestmt = 'Case When...' (include the whole clause in the set) the encapsulate your query with apostrophes to make the entire query a string, replace ll existences of the case statement with the variable @Casestmt and execute the entire statement this way inside of an exec, the downside is the possibility of sql injection, as @oleg has advised, it's worth posting your query and then it helps to see what options are available based on your code.