The Very simple android app i desided to build

I decided to build simple android  shopping list application, to try my skills in this  hot programming field.
Since I'm completely new to android and to java it is very interesting experiment if i will succeed...
The shopping  list application -is for help the people who going to shop, to remember what they planned  to buy.

Something like Out Of Milk Application (No way my application will be good as OutOfMilk, but i must start somewhere if i want to learn android development...)

All the products the user plan to buy are displayed in list  along with 'done' checkbox - which indicates if product is already in the cart.

SQL code for fetching first 10 records starting with 50

In many interviews i had been asked questions like this:
Write a code for fetching first 10 records starting with 50.
Now i decided to post it here for me and everyone else who may need it:
(You may run this query in AdventureWorks sample Database )

WITH Persons AS

(

    SELECT FirstName,LastName,

    ROW_NUMBER() OVER (ORDER BY LastName) AS 'RowNumber'

    FROM Person.Contact

)

SELECT FirstName,LastName

FROM Persons

WHERE RowNumber BETWEEN 50 AND 60;

Jquery animations

I'm trying to build simple javascript-based navigation that will display different content each time user clicks one the of links in the navbar.

The content stored in separate HTML files that containing only specific article wrapped in "description" div:

Each link on the navbar has the url to proper content file.


I'm using following jquery code to place content in response of user clicks:


The code working fine, but (to improve user experience) i want to make an fadeIn -fadeOut animation: I want the content fade out and after, the other content fade in.
Its looks like this code will do the work:

Looks like, but not.
The new content appears in the content panel even before the fading out starts.
The 'load' function didnt wait to 'fadeOut' to finish.
Here is some solution to fix this:

Now the 'load' is inside the 'fadeOut' - that means it will happen in the end
of fade out animation
[Download code]