Krishan Kayat

select ename,Salary from Emp a group by Ename,Salary    having 4=(select COUNT(distinct( salary) )from Emp b where a.salary<=b.Salary)

with some easy step you can hide this notification form your desktop. so lets start........ Uninstalling Windows Update: KB971033 Go to Windows Update Hit Installed Updates (link at the bottom left corner). If that link isn’t there, hit “view update history” and hit the “installed updates” link at the top. Scroll down to the section titled “Microsoft Windows” and look for update KB971033. Right click it and hit “uninstall”. Hit okay. Reboot now. after the reboot  1 Click start and simply type COMMAND PR in the start menu’s search box. Right click COMMAND PROMPT and select RUN AS ADMINISTRATOR.      2.   In the command prompt window type: slmgr.vbs -rearm            and press enter. (Note that there is a space between slmgr.vbs and -rearm.)  3.  Now reboot and you're good to go. This method is tested by me and a lot of other people(see comments) and it is working fine. If you ...

The following steps will give you the opportunity to change your Picture Tile image and the background image in your Picture Hub. 1  Home screen 2  Select Pictures 3  Under the Title “Pictures”  Tap and Hold 4  A menu pops up and select ‘Change background” 5  Select a images in one of your your albums 6  Move the image around within the given frame. 7  Select the “v” check mark 8  Now your Picture Hub background image has been changed as well as your Picture Tile on the home screen.

1  From your PC go to the start menu and in the search area type regedit. This will open the registry editor. 2  In the bar located on the left of the editor navigate to the given path     HKEY_LOCAL_MACHINE –> SYSTEM –> CurrentControlSet –> Enum –> USB 3  This will give you a long list in your side bar. Select the USB folder you have just reached but don’t do anything else yet. 4  Hit Ctrl+F, which will open the Find dialog box. Input ZuneDriver and enter. This will automatically bring you to the WUDF folder. 5  Select the folder just above WUDF, named Device Parameters, opening a number of entries in the main screen on the right. 6  Among the many entries look for “ShowInShell”, double click and change the value from 0 to 1. 7  The registry value marked as “PortableDeviceNameSpaceExcludeFromShell” goes to 1 from the default 0 8  Set “EnableLegacySupport” to 1. 9  Exit registry editor. guys hope ...

Go to the Phone section (as if you were going to make a call) Enter  ##634# It did not call anything.  There should now be a “Diagnosis” option on the top of your screen; Go to Diagnosis and a keypad comes up and enter  *#1234#  –It should bring up a menu that includes the WiFi Mac Address; Please let me know if this works with any other Samsung Windows Phone 7 or for that matter any Windows Phone 7 ?  

I'd suggest you find out the MAC address of your WP7 and then set up a DHCP reservation at a particular IP for that MAC address (I've done this on my little home WiFi router, but it should be no problem within a company architecture).  Apparantly there is no way to determine the MAC address through the phone itself; you'll have to find it off the network itself.  Talk to your network guys or sys admins about setting up a reservation for the MAC once you have it.

if your Tabel has a duplicate data and you want to delete only duplicate records and want to save only single records in your table then this single line of code will help you.......... select * from tblname where tblname. %%physloc%% not in(select MAX(b.%%physloc%%)  from tblname   group by b.coloumnname) Hope it helped you........ plz comments.........