SQL Multiplication

i was shocked to find that there is no aggregate multiplication functions in SQL, something like

select mul(number) from table

but i needed to use a multiplication function…, so as usual i googled it and found this statement

select exp(sum(log(cast(number as float)))) from table

that does the multiplication,

so with a mouth half opened i tested this line and it worked

Manipulating Visio “Shape Data” using VBA

recently i needed to write a macro that processes an MS  Visio 2007 page and and does some actions based on the contents of a custom defined stencil shapes, where this contents are saved as a Shape Data field in the shape

Hidden Options [2]

after  Hidden Options

here is the second post with the hidden options i’ve been collecting since then…

1-On Windows

• Ctrl+C

some times you need to copy the contents of a message box and the text is unselectable

just press Ctrl+C when this message box is in focus and all it’s contents will be copied

Thanx to Roaa “The Undocumented Feature”