Alan Burstein questions

Alan Burstein answers

• 'CREATE FUNCTION' must be the only statement in the batch
• Using "UNION ALL" and "GROUP BY" to implement "Intersect"
• Find lowest and highest values split into rows from a single string of concatenated values
• Create #temp using SELECT INTO with desired data type
• Force parallel union execution
• SQL Server LEN function reports wrong result
• SQL Server user defined function to calculate age bracket
• Does CROSS APPLY WHERE clause work before cross apply or after on the results
• Extract phone number from noised string
• if statement in SQL computed Column Specification