error: expression of non-boolean - help me

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.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

error: expression of non-boolean - help me

Author

Topic

mummy
Starting Member

9 Posts

Posted - 2009-02-20 : 02:36:10

I am getting the below error while executing my SP with parameters. Can you pleae assist me?

Msg 4145, Level 15, State 1, Line 229
An expression of non-boolean type specified in a context where a condition is expected, near 'and'.

Please check the below query :

select rpMonth,servicecode,portcode,terminalcode,'''' as transporttermid,'''' as trptterm,
sum(LOAD_20_Agncy) as load20teus,'''' as load20SOC,
sum(LOAD_40_Agncy) as load40teus,'''' as load40SOC,
sum(DISCH_20_Agncy) as disch20teus, '''' as disch20SOC,
sum(DISCH_40_Agncy) as disch40teus, '''' as disch40SOC,

sum(TS_LOAD_20_Agncy) as TSload20teus,
sum(TS_LOAD_40_Agncy) as TSload40teus,
sum(TS_DISCH_20_Agncy) as TSdisch20teus,
sum(TS_DISCH_40_Agncy) as TSdisch40teus,

sum(LOAD_EMPTY_20_Agncy) as loadEmpty20teus,
sum(LOAD_EMPTY_40_Agncy) as loadEmpty40teus,
sum(DISCH_EMPTY_20_Agncy) as dischEmpty20teus,
sum(DISCH_EMPTY_40_Agncy) as dischEmpty40teus,

sum(TS_LOAD_EMPTY_20_Agncy) as TSloadEmpty20teus,
sum(TS_LOAD_EMPTY_40_Agncy) as TSloadEmpty40teus,
sum(TS_DISCH_EMPTY_20_Agncy) as TSdischEmpty20teus,
sum(TS_DISCH_EMPTY_40_Agncy) as TSdischEmpty40teus into #temptsFinalrslt
from contribution group by rpmonth,servicecode,portcode,terminalcode
UNION
select rpMonth,servicecode,portcode,terminalcode,transporttermid,trptterm,'''' as load20teus,
sum(LOAD_20_SOC) as load20SOC,'''' as load40teus,
sum(LOAD_40_SOC) as load40SOC,'''' as disch20teus,
sum(DISCH_20_SOC) as disch20SOC,'''' as disch40teus,
sum(DISCH_40_SOC) as disch40SOC,
'''' as TSload20teus,'''' as TSload40teus,'''' as TSdisch20teus,'''' as TSdisch40teus,
'''' as loadEmpty20teus,'''' as loadEmpty40teus,'''' as dischEmpty20teus,'''' as dischEmpty40teus,
'''' as TSloadEmpty20teus,'''' as TSloadEmpty40teus,'''' as TSdischEmpty20teus,'''' as TSdischEmpty40teus
from contribution
group by rpmonth,servicecode,portcode,terminalcode,transporttermid,trptterm order by portcode

delete from #temptsFinalrslt where load20teus=0 and load20SOC=0 and load40teus=0 and load40SOC=0 and disch20teus=0 and
disch20SOC=0 and disch40teus=0 and disch40SOC=0 and TSload20teus=0 and TSload40teus=0 and TSdisch20teus=0 and
TSdisch40teus=0 and loadEmpty20teus=0 and loadEmpty40teus=0 and dischEmpty20teus=0 and dischEmpty40teus and
TSloadEmpty20teus=0 and TSloadEmpty40teus=0 and TSdischEmpty20teus=0 and TSdischEmpty40teus

select rpMonth,case when rpmonth=''1'' then ''January''
when rpmonth=''2'' then ''February''
when rpmonth=''3'' then ''March''
when rpmonth=''4'' then ''April''
when rpmonth=''5'' then ''May''
when rpmonth=''6'' then ''June''
when rpmonth=''7'' then ''July''
when rpmonth=''8'' then ''August''
when rpmonth=''9'' then ''September''
when rpmonth=''10'' then ''October''
when rpmonth=''11'' then ''November''
when rpmonth=''12'' then ''December'' else '''' end as rpMonthdes,
servicecode,portcode,terminalcode,transporttermid,trptterm,load20teus,load20SOC,load40teus,load40SOC,
disch20teus,disch20SOC,disch40teus,disch40SOC,TSload20teus,TSload40teus,TSdisch20teus,TSdisch40teus,
loadEmpty20teus,loadEmpty40teus,dischEmpty20teus,dischEmpty40teus,TSloadEmpty20teus,TSloadEmpty40teus,
TSdischEmpty20teus,TSdischEmpty40teus
from #temptsFinalrslt

bklr
Master Smack Fu Yak Hacker

1693 Posts

Posted - 2009-02-20 : 02:41:00

delete from #temptsFinalrslt where load20teus=0 and load20SOC=0 and load40teus=0 and load40SOC=0 and disch20teus=0 and
disch20SOC=0 and disch40teus=0 and disch40SOC=0 and TSload20teus=0 and TSload40teus=0 and TSdisch20teus=0 and
TSdisch40teus=0 and loadEmpty20teus=0 and loadEmpty40teus=0 and dischEmpty20teus=0 and dischEmpty40teus= 0 and
TSloadEmpty20teus=0 and TSloadEmpty40teus=0 and TSdischEmpty20teus=0 and TSdischEmpty40teus=0

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources