Use VALUES clause to get the maximum value from some columns [SQL Server, T-SQL]http://sqlblog.com/blogs/jamie_thomson/archive/2012/01/20/use-values-clause-to-get-the-maximum-value-from-some-columns-sql-server-t-sql.aspxMy ex-colleague Paul Mcmillan pointed me at a thread on Stack Overflow that demonstrated a neat T-SQL trick to get the maximum value from a collection of columns in a row. Paul had never seen it before and neither had I so I figure one or two of you outenCommunityServer 2.1 SP2 (Build: 61129.1)re: Use VALUES clause to get the maximum value from some columns [SQL Server, T-SQL]http://sqlblog.com/blogs/jamie_thomson/archive/2012/01/20/use-values-clause-to-get-the-maximum-value-from-some-columns-sql-server-t-sql.aspx#41192Fri, 20 Jan 2012 14:44:14 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:41192James<p>excellent, very useful.</p> <p>Thank You!</p> re: Use VALUES clause to get the maximum value from some columns [SQL Server, T-SQL]http://sqlblog.com/blogs/jamie_thomson/archive/2012/01/20/use-values-clause-to-get-the-maximum-value-from-some-columns-sql-server-t-sql.aspx#41193Fri, 20 Jan 2012 15:23:39 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:41193siva<p>good one, some time i wil fact this issue </p> re: Use VALUES clause to get the maximum value from some columns [SQL Server, T-SQL]http://sqlblog.com/blogs/jamie_thomson/archive/2012/01/20/use-values-clause-to-get-the-maximum-value-from-some-columns-sql-server-t-sql.aspx#41209Fri, 20 Jan 2012 23:06:42 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:41209Gianluca Sartori<p>Nice, thanks for sharing!</p> <p>However, not as efficient as you would think.</p> <p>See this for a faster solution:</p> <p><a rel="nofollow" target="_new" href="http://www.sqlservercentral.com/Forums/FindPost1190488.aspx">http://www.sqlservercentral.com/Forums/FindPost1190488.aspx</a></p> re: Use VALUES clause to get the maximum value from some columns [SQL Server, T-SQL]http://sqlblog.com/blogs/jamie_thomson/archive/2012/01/20/use-values-clause-to-get-the-maximum-value-from-some-columns-sql-server-t-sql.aspx#41227Mon, 23 Jan 2012 07:34:59 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:41227Jennyfer<p>Very nice.... thanks for sharing </p> re: Use VALUES clause to get the maximum value from some columns [SQL Server, T-SQL]http://sqlblog.com/blogs/jamie_thomson/archive/2012/01/20/use-values-clause-to-get-the-maximum-value-from-some-columns-sql-server-t-sql.aspx#41249Tue, 24 Jan 2012 00:02:51 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:41249Gil<p>Before Row Constructors, I used to do that with (SELECT a UNION ALL SELECT b UNION ALL SELECT c)</p> re: Use VALUES clause to get the maximum value from some columns [SQL Server, T-SQL]http://sqlblog.com/blogs/jamie_thomson/archive/2012/01/20/use-values-clause-to-get-the-maximum-value-from-some-columns-sql-server-t-sql.aspx#41341Thu, 26 Jan 2012 13:50:12 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:41341Ramakrishna Rao<p>Good one. It really helped me.</p> re: Use VALUES clause to get the maximum value from some columns [SQL Server, T-SQL]http://sqlblog.com/blogs/jamie_thomson/archive/2012/01/20/use-values-clause-to-get-the-maximum-value-from-some-columns-sql-server-t-sql.aspx#41587Tue, 07 Feb 2012 13:45:45 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:41587Dattatrey Sindol (Datta)<p>Nice article Jamie !!</p> <p>Here is an article by Robert Sheldon on this feature called Table Value Constructors (TVCs) - <a rel="nofollow" target="_new" href="http://www.simple-talk.com/sql/sql-training/table-value-constructors-in-sql-server-2008/">http://www.simple-talk.com/sql/sql-training/table-value-constructors-in-sql-server-2008/</a></p>