How do I write an update with a case and join.

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 2000 Forums

Transact-SQL (2000)

How do I write an update with a case and join.

Author

Topic

maevr
Posting Yak Master

169 Posts

Posted - 2008-09-08 : 04:44:03

This is the select I want to use to update:

select
case
when "FB32 Area platta på mark/källargolv" <> 0 then
2 * 3.5 / (pi() * sqrt(6/25.00 * "FB32 Area platta på mark/källargolv") + 0.3 + 3.5 * "FB33 Summa R värmemotstånd" + 0.5 * convert(float, "FB42 Area källarvägg under mark") / (convert(float, "FB42 Area källarvägg under mark") + "FB46 Källarväggens totala area") * "FA19Kallare")
* log(pi() * sqrt(6/25.00 * "FB32 Area platta på mark/källargolv") / (0.3 + 3.5 * "FB33 Summa R värmemotstånd" + 0.5 * convert(float, "FB42 Area källarvägg under mark") / (convert(float, "FB42 Area källarvägg under mark") + "FB46 Källarväggens totala area") * "FA19Kallare") + 1)
else
NULL
end
from ss_fb, ss_fa
where ss_fb."Byggnadens ueNr" = ss_fa.FXByggnadensUEnr

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-09-08 : 04:47:29

Duplicate of http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=110208

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources