SQLTeam.com | Weblogs | Forums

Error message help


#1

hi guys

i am getting this error message below

Msg 102, Level 15, State 1, Line 28
Incorrect syntax near ')'.

when running the below quert
SELECT *
FROM TEST_TAB3
UNPIVOT ( field_data
FOR field_name IN (t_name, c_name, u_name)
);

can anyone help with this?