Some notes on software development... RSS 2.0
# Tuesday, 29 April 2008
Tuesday, 29 April 2008 07:52:49 (GMT Standard Time, UTC+00:00)  #    -
SQL Server
# Monday, 28 April 2008

Scott Gu has a nice article describing the null coalescing operator when used with LINQ queries.

A quick example:
image 

The Qty & Size properties for the anonymous type will be defined as integer types NOT nullable integers. If any of the spec.Attribute("x") values are null or don't exist for any reason, the value returned will be a simple integer zero.
This is because using the null coalescing operator (??) is enforcing that null can never ever happen.

LINKS
Scott Gu blog article

Monday, 28 April 2008 17:01:12 (GMT Standard Time, UTC+00:00)  #    -
C#
# Tuesday, 15 April 2008

To get the rightmost value in a range you can use the Lookup function:

image

The 1st parameter is the value to lookup in the range. However if the value cannot be found the lookup function will return the highest value in the range by default.
So setting the 1st parameter to 1E+100 basically sets the lookup value to be a huge numeric value, 1 + 100 zeros. If you know what your max value will be you can change this to be max value + 1.

Links
Microsoft Discussion Groups - Microsoft.Public.Excel.Misc

Tuesday, 15 April 2008 08:07:19 (GMT Standard Time, UTC+00:00)  #    -
Office
# Tuesday, 08 April 2008

To put a new line inside an Microsoft Excel cell you can use ALT+ENTER.
Handy for keeping text neat :)

Tuesday, 08 April 2008 11:37:05 (GMT Standard Time, UTC+00:00)  #    -
Office
Navigation

Sign In
Extras
Statistics
Total Posts: 116
This Year: 0
This Month: 0
This Week: 0
Comments: 36
About the author/Disclaimer

Disclaimer
The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.

© Copyright 2017
Hadrian Phillips

All Content © 2017, Hadrian Phillips
DasBlog theme 'Business' created by Christoph De Baene (delarou)