Viewing 2 posts - 1 through 2 (of 2 total)
See Pivot and Unpivot http://msdn.microsoft.com/en-us/library/ms177410.aspx
September 21, 2010 at 8:41 am
#1224885
The nt_user_name also can be empty for 'SQL Authentication' .
SELECT 'Authentication Method'=(
CASE
WHEN nt_user_name IS not null And nt_user_name <> '' THEN 'Windows Authentication'
ELSE 'SQL Authentication'
END), nt_user_name,
...
May 25, 2010 at 6:30 am
#1172012