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 |
|
anjan
Starting Member
21 Posts |
 Posted - 2005-10-17 : 15:51:49
|
| I am using cross tab query as follows...(using crosstab procedure given in this forum)exec crosstab 'SELECT temp2 FROM temp GROUP BY temp2','sum(temp11)','temp1','temp'but i'm ettting the following problem...why its coming..plz help me#errorCannot use empty object or column names. Use a single space if necessary. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-09-05 : 04:43:37
|
| I think it should be 'SUM(Temp11) AS SomeColName'Peter LarssonHelsingborg, Sweden |
 |
|
|
KenW
Constraint Violating Yak Guru
391 Posts |
Posted - 2006-09-06 : 15:55:49
|
| Peter,A little bored? (The message you replied to is almost 11 months old.) <g>Ken |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-09-06 : 20:58:13
|
No problem. If the questioner is subscribed to this topic, he/she will be notified by mail  MadhivananFailing to plan is Planning to fail |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-09-07 : 00:38:05
|
quote:
Originally posted by KenW
A little bored? (The message you replied to is almost 11 months old.)
How did you guess that?  Peter LarssonHelsingborg, Sweden |
|
|
|
|
|
|
crosstab query problem.....