resultVar += (((var1 * var2) + var3) % (var4 / var5))
% has the same presedence as /, so the answer should be
resultVar = resultVar + ( (var1*var2) + ( (var3%var4) /var5) )

Yes, we just had a thread on this same exercise & answer a few days ago.

I like your final answer, where you decompose the += operator! We didn't do that. I think your version makes this even clearer.

Hopefully somebody at WROX will get around to fixing this one.

Problem!
What's wrong in this code?


CREATETABLE BLOBTest
(
BLOBID intIDENTITYNOTNULL,
BLOBData varbinary(max)NOTNULL
)
GO
INSERTINTO BLOBTest(BLOBData)
SELECT*FROMOPENROWSET(BULKN'C:\x.jpg',SINGLE_BLOB);