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 |
|
ejoeyz_85
Yak Posting Veteran
54 Posts |
 Posted - 2008-01-12 : 18:44:59
|
| below is my sql query statement... hope u understandSELECT u.User_fname, pv.PV_address, p.Start_monitoring, p.Last_monitoring, p.Period_of_monitoring, m.Ongoing_maintenance,m.Savings_for_inverter_replacement, m.Monitoring, m.Total_anual_maint_and_monitorFROM PerformanceData p, MonitoringCost m, Photovoltaic pv, Users uWHERE p.Performance_id=m.MonitoringCost_id and pv.PV_id=p.Performance_id andpv.PV_id=m.MonitoringCost_id and u.User_id =p.Performance_id and u.User_id =pv.PV_id and u.User_id = m.MonitoringCost_idwhen i execute this query, it cannot executed because i got this error message... Msg 245, Level 16, State 1, Line 1Conversion failed when converting the varchar value 'ejoy' to data type int.what should i do?? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-12 : 19:54:51
|
| Dup post:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=95422 |
 |
|
|
|
|
|
|
|
help me