From the MS SQL Server online documentation (http://technet.microsoft.com/en-us/library/ms186734.aspx), here is their example that I have tested and works, for retrieving a specific set of rows. ROW_NUMBER requires an OVER, but you can order by whatever you like:
Wash you hair the night before or even a few hours before you do the color job. The coloring clings better to hair without any product in it but I always use conditioner on mine.The products tend to mess with the final color of the hair once it is dry. Thats why most pros say NO to washing for 24 hours and NO products in your hair. They want you to be happy with the finished look.Best thing is, wash the night before, let dry naturally and don't use any products, ie., gel, hair spray, etc.he products tend to mess with the final color of the hair once it is dry. Thats why most pros say NO to washing for 24 hours and NO products in your hair. They want you to be happy with the finished look. Best thing is, wash the night before, let dry naturally and don't use any products, ie., gel, hair spray, etc.
Those with light to medium brown hair tend to have the most success dyeing their hair a red or auburn shade, whether at home or at the salon. But, if you try this at home, ALWAYS do a strand test first so you know how long to time the dye and what the color will look like.hen You Absolutely Should Get Your Hair Dyed at the Salon. There are five major situations where a salon experience is preferred to dyeing your hair yourself: You want to lighten your hair more than three shades from your natural color.