How to reuse calculated columns avoiding duplicating the sql statement

by

You could try something like this.

SELECT 
    A.Val AS A, 
    B.Val AS B, 
    C.Val AS C 
FROM MYTABLE
  cross apply(select 1 + 2) as A(Val)
  cross apply(select A.Val + 3) as B(Val)
  cross apply(select B.Val * 7) as C(Val)

More Related Contents:

  1. SQL Server – error when creating stored procedure
  2. How can foreign key constraints be temporarily disabled using T-SQL?
  3. Insert multiple rows WITHOUT repeating the “INSERT INTO …” part of the statement?
  4. How can I escape square brackets in a LIKE clause?
  5. Does T-SQL have an aggregate function to concatenate strings? [duplicate]
  6. Parameter Sniffing (or Spoofing) in SQL Server
  7. SQL Server String or binary data would be truncated
  8. Datatype for storing ip address in SQL Server
  9. How to change identity column values programmatically?
  10. SQL Server Regular expressions in T-SQL
  11. Is there a way to loop through a table variable in TSQL without using a cursor?
  12. Maximum size of a varchar(max) variable
  13. best way to convert and validate a date string
  14. How to get a date in YYYY-MM-DD format from a TSQL datetime field?
  15. Concatenating Column Values into a Comma-Separated List
  16. Is there a way to simplify a NULL compare of 2 values
  17. TSQL Try / Catch within Transaction or vice versa?
  18. What is the maximum number of characters that nvarchar(MAX) will hold?
  19. TSQL: Create a view that accesses multiple databases
  20. Sequence as default value for a column
  21. Aggregate bitwise-OR in a subquery
  22. How do I flush the PRINT buffer in TSQL?
  23. Get ROWS as COLUMNS (SQL Server dynamic PIVOT query)
  24. OR Operator Short-circuit in SQL Server
  25. Cannot bulk load. Operating system error code 5 (Access is denied.)
  26. comparing a column to a list of values in t-sql
  27. Does query plan optimizer works well with joined/filtered table-valued functions?
  28. Random record from a database table (T-SQL)
  29. What are row, page and table locks? And when they are acquired?
  30. time format in SQL Server

Leave a Comment