#case statement

8 Essentials for Your Organization’s Case Statement

Are your fundraising efforts standing on the firm foundation of an outstanding case statement? Of all the documents an organization uses to aid fundraising, the case statement is one of the most important.

The case statement (or case for support) is used by a nonprofit as a basis for all communication and solicitations with donors. As a primary tool for fundraising, a nonprofit’s case statement…

New Post has been published on http://www.varindersandhu.in/2011/09/23/sql-server-denali-new-logical-functions/

SQL Server Denali – New Logical Functions

<!-- google_ad_client = "pub-2404605494811633"; google_alternate_color = "FFFFFF"; google_ad_width = 468; google_ad_height = 60; google_ad_format = "468x60_as"; google_ad_type = "text_image"; google_ad_channel =""; google_color_border = "FFFFFF"; google_color_link = "0000FF"; google_color_bg = "FFFFFF"; google_color_text = "000000"; google_color_url = "008000"; google_ui_features = "rc:6"; //-->

There are two new Logical functions are introduced in Denali. Let‘s have a look

IFF

CHOOSE

IFF

It Returns one of two values, depending on whether the Boolean expression evaluates to true or false.

IIF is a shorthand way for writing a CASE statement. It evaluates the Boolean expression passed as the first argument, and then returns either of the other two arguments based on the result of the evaluation. That is, the true_value is returned if the Boolean expression is true, and the false_value is returned if the Boolean expression is false or unknown. true_value and false_value can be of any type.

--Syntax IIF ( boolean_expression, true_value, false_value ) --Example SELECT IIF (50 > 20, True, False) AS Result; --Result True

CHOOSE

Returns the item at the specified index from a list of values.

CHOOSE acts like an index into an array, where the array is composed of the arguments that follow the index argument. The index argument determines which of the following values will be returned.

If - i ever seem to come across as an ass

Then - i'm just being dry with a dash of british sophistication

Else - there are rare occasions where i'm just being just a "smart"ass

End