How to get the parent child relation in same table In Sql Server

-

SELECT

ChildUserType.Id as CategoryId,ChildUserType.Category as CategoryName,

ChildUserType.IsActive,ChildUserType.CategoryURL as CategoryURL,

ChildUserType.CreatedOn,ChildUserType.ParentId,

ParentUserType.Category as ChildParentname,ChildUserType.NoofOrgs

FROM 

[dbo].[Categories] AS ChildUserType

LEFT JOIN 

[dbo].[Categories] AS ParentUserType 

ON 

ChildUserType.ParentId = ParentUserType.Id 

Comments

Post a Comment

Popular posts from this blog

How to use youtube api's in your application.

-
Image
First of all, go to the google developer console site and add your google account. URL:  https://console.developers.google.com/ Then the screen shows up, Now, click on select a project on the navbar. Then the screen shows up, Now enter your project name and organization etc, then click on enter. Then it will ask for 2 types of access,  1.OAuth 2.0,  2.API Key   you can use OAuth 2.0 if you want. Here i have selected API Key to get access Then the screen shows up, Now, you have the API Key to get access to google api's. Note: Copy and paste the API Key in a notepad for further use. Now go to the youtube for the developers site. Url:  https://developers.google.com/youtube Then below screen shows up, Here, click on samples from nav bar and select the language you are using and again select references from the navbar. Then the below screen shows up. Now, Here i want to show th...
Read more

Implement virtualisation in kendo drop down list using jquery ajax in mvc, aspx page

-
virtualization helps to load huge data fastly. $("#abcd").kendoDropDownList({                 filter: "contains",                 dataTextField: "WorkOrderNumber",                 dataValueField: "WorkOrderNumber",                 virtual: {                     itemHeight: 26,                     valueMapper: function (options) {                     }     ...
Read more

Interview Questions-2

-
 output of following program and if any errors what should be the correct syntax class baseclass {​​​​​​​​​      public void func1() {​​​​​​​​ Console.WriteLine ("Base Fun1()")​}​​​​​​​​​      public virtual void func2() {​​​​​​​​ Console.WriteLine ("Base Fun2()")​}​​​​​​​​​      public virtual  void func3() {​​​​​​​​​ Console.WriteLine ("Base Fun3()")}​​​​​​​​​ }​​​​​​​​​ class derivedclass :baseclass {​​​​​​​​​      new public void func1() {​​​​​​​​ Console.WriteLine ("derived Fun1()")​}​​​​​​​​​      public override void func2() {​​​​​​​​ Console.WriteLine ("derived Fun2()")​}​​​​​​​​​      public new void func3() {​​​​​​​​ Console.WriteLine ("derived Fun3()")​}​​​​​​​​​ }​​​​​​​​​ class Program {​​​​​​​​​      static void Main(string[] args)      {​...
Read more