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]

How to put breaklines between tags or the great notepad++

This is a small post that will be devoted to notepad++ - which i think, is a great tool for webdeveloper. This is free, lightweight, but smart code editor. Not that it can completely replace Visual Studio, but in some ways it seems to have advantages on Microsoft technology.
Take a quick look on what can you do with this notepad:

Say  you have to modify some details xml file that have all the tags gathered in one line. If you need each tag to be displayed in separate line you can do Replace with the following options:

Now you can see the result:: each tag on his own line.

Using Regular expressions:
Say you have an CSS file in which you need replace the images url of background property:
from  To  

And for some reason the code somtimes appears in this way:


and sometimes in this way:


You cannot replace all apearances with the same way. So you need to use RegularExpresson:
Firstly replace all appearances without brackets:

And after-with brackets:

Now you can anjoy the fixed code!

Thoughts about Jquery autocomplete plugin

I'm sure you have experinence of building autocomplete functionality in some way. There many ways to do it -for example with  AJAX Control Toolkit. Since i'm teaching myself a jquery now i want to implement the jquery autocomplete plugin in my ASP.NET site.



Its looks easy as it appears in the exapmle :


After placing this javascript you only need to create input with id -"LOCATION" and the things start working.

So far so good.
The only problem for me with this code is that values coming from the Array(cities). I want values to come from the WebService. So i desided to build some small  site project to experience with plugin.
This is the WebService code:

As you can see there is no logic at all- web method returns the ";" deleimted Cities names in string.
Firstly i tryed to fill the values in separate ajax request-But its
Just Not Worked


Why?
Because the AJAX request that fills data in 'cities' Array is asyncronic. It means that when compiler reaches the '.autocomlete(cities' -the cities is still empty.

One way to work this around is to put the 'autocomplete' inside the 'success'  function of request:

This works fine [Download source]
But I'm not content with this solution because i want the 'suggested' values to be filled in response of user enter characters:
For this ,as i saw in plugin documentation i can put the WebService Url directly inside statement:



Here the things started to be messy. The problem is the break point in the code of webservice became not reacheable.

It taked me a long time to figure out what is the problem. I figured that after inside plugin code (jquery.autocomplete.js) in the 'request' funciton i put the error handler



inside '$.ajax' call. Yes, the ajax call of the plugin cannot reach the server unless you put following code inside web.config under 'system.web' node:



Now, after i can reach the server i started to get another error inside 'parse' function inside the plugin that tryes to split the data to rows with '\n' key.
As solution to this problem i decided to override the 'parse' function:

Now the things started to work. Now we see all cities in the list no matter wath user has
entered.
To repair this i had modifyed the WebService- GetCities method:

So now the method getting user input as parameter.
The only thing left is to modify the 'data' sended with the request inside the 'request' function of the plugin:

Now the thing is realy working:

[Download the source]