Krishan Kayat

ALTER PROCEDURE [dbo].[GetEmployeesstaffwise2] ( @id varchar(30) , @unitid varchar(40)) AS ;     WITH    EmployeeManager     AS(     SELECT distinct Boss.ID, tbl_Staff.Firstname+' '+tbl_Staff.Middlename+' '+tbl_Staff.Lastname  Employee ,  Boss.Firstname+' '+Boss.Middlename+' '+Boss.Lastname Boss FROM tbl_Staff  INNER JOIN tbl_Staff AS Boss ON tbl_Staff.mgr=Boss.ID   INNER JOIN  tbl_Staff BigBoss ON Boss.ID=BigBoss.mgr  or tbl_Staff.mgr=Boss.ID    where BigBoss.mgr=@id   and Boss.UnitID like'%'+@unitid+'%' and BigBoss.UnitID like'%'+@unitid+'%' and tbl_Staff .UnitID like'%'+@unitid+'%'  ) select ID,employee as name,Boss as manager from EmployeeManager ID ParentID name Children 1 NULL kk 9 2 1 jin 8 3 2 NULL 3 4 2 NULL 2 5 3 NULL 1 6 2 NULL 0 7 3 NULL 0 8 4 NULL 0 9 4 NULL 0 10 5 NULL 0  ;WITH ChildrenCTE AS (   SEL...

Last month i bought a Windows phone Samsung Omnia W.... After a few days i realise the some problem with it...... WP7.5 (Mango) is already in its second generation but it still has many restrictions, limitations and serious usability issues. This is a list of its shortcomings as compared with other smartphone OS in the market. We are not comparing special features or abilities but those which have become the norm for all smartphones and even dumb phones. An Android, Symbian or MeeGo phone would have almost none of these shortcomings. An iphone share some restrictions with WP7.5 but is still miles ahead. Even the Nokia N9 running the first generation MeeGo OS is far better with none of the disastrous issues which impact on the sheer usability of the phone. OS LIMITATIONS 1. No true multitasking - apps are frozen in the background. 2. No Divx/Xvid video codec support. Zune will convert with loss of quality. 3. No mass storage mode. 4. No micro-SD card support. 5. Only suppor...

Hello Guys... if u want to make a ringtone of ur favorite song into ur samsung omnia w...then just follow these simple steps. 1) In your computer keep the song in (My music). 2) Go to the property of that particular song. 3) Go to the details in the property. 4) In Genre type the Ringtone and click the apply  5) with the zune software transfer your song in your phn and enjoy it. hope this information will helpful for you ....

Go into the phone dial mode. Type: ##3282# If the screen does not change to “field test”, tap the dial button. On the next screen which opens up, pop up the settings options from the bottom of the screen via the … button. Tap settings In the Network type, select 2G only Hit the back arrow and go to your home screen. Your phone will now work on the 2G network and consume lesser battery. Hope this helps someone.

Dial  *43#  to enable call waiting on your GSM connection To disable call waiting, dial  #43#

Basics about State management: As we all know,web is stateless .A Web page is recreated every time it is posted back to the server.In traditional web programming, that all the information within the page and control gets wiped off on every  post back . To overcome this problem,ASP.NET framework provides various ways to preserve the states at various stages like controlstate,viewstate, cookies, session etc.These can be defined in at client side and server side state management. What is AppDomain An AppDomain can be defined as light weight process and is used for security isolation and availability. AppDomain is hosted on some process and a Process can host multiple AppDomains. So one AppDomain can go down/restarts without affecting other AppDomains in the same process. Role of AppDomain in ASP.NET: AppDomain  plays a key role in asp.net. When ASP.NET receives first request, the Application manager creates an application domain for it, Application domain are very importa...

Session state  is the feature of ASP.NET based web applications using which values of a variable may be persisted and then posted to another page. Viewstate  property of a page or a control, or a viewstate object for a variable value, may also be created to persist its value across a postback. However, the viewstate value are for page level  , i.e. they cannot be posted across to another page. Session State is useful for storing values that must be persisted across multiple pages by the same user. ViewState is useful for storing serializable data that must be persisisted across PostBacks by a single page. If you use Session State, the value you insert will remain in memory until (1) The Session times out, or (2) Your code removes it. If you use ViewState, the value you insert will remain in ViewState until the user requests a different page. ViewState stores data betwen PostBacks by putting it into a hidden form field on the client HTML doc. when the doc is Posted Back, t...