Use columns from select statement as parameter in function when joining
112780
pass parameter in table valued function using select statement
68213
pure functions in nested select
64606
reuse sql with view or function
108393
Update a table using JOIN in SQL Server?
46174
Using an Alias in a WHERE clause
141193
combining results of two select statements
44806
Error 1052 Field is Ambiguous using Inner Join Function
56165
Parameterise table name in .NET/SQL?
115623
SQL Server 2008 - How do i return a User-Defined Table Type from a Table-Valued Function?
40225
Select statement with dynamic columns where these columns are rows in another table
54895
Why is the join built-in having no influence on my code?
149449
Better query to select multiple columns into a single output column?
82301
How to use a variable name in a SQL statement?
65699
'IF' in 'SELECT' statement - choose output value based on column values
132463
Unioning two tables with different number of columns
77466
Select columns from result set of stored procedure
115344
Using a literal string in SELECT statement