Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vaidyanathanpc
Starting Member
24 Posts |
 Posted - 2002-05-08 : 02:30:04
|
| Hi, I'm having a problem while writing cross tab queries. The fact is I'm getting errors when I execute the query.The query is as follows.SELECT skill_Id, count(CASE final_rating WHEN 5 THEN assoc_name ELSE 0 END) AS "5", count(CASE final_rating WHEN 4 THEN assoc_name ELSE 0 END) AS "4", count(CASE final_rating WHEN 3 THEN assoc_name ELSE 0 END) AS "3", count(CASE final_rating WHEN 2 THEN assoc_name ELSE 0 END) AS "2"FROM viewfinalratingGROUP BY skill_idMy purpose is to get the count of the assoc_name for each final_rating grouped by skill_id. When I execute the above query I'm getting the errorServer: Msg 245, Level 16, State 1, Line 1Syntax error converting the varchar value 'Name1' to a column of data type int. Name1 is an assoc_name in the view viewfinalrating. Why is SQL server trying to convert the assoc_name to int. Isn't the query supposed to get the count of assoc name based on the CASE statements?What could be the problem?Thanks in advanceRegards,P.C. Vaidyanathan |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
|
|
|
|
|
Cross Tab Query giving error