Web Application Programmer

Let’s we have below table structure: create table Testdata ( SomeID int , OtherID int , Data varchar ( max ) ) This table contain below sample records insert Testdata select 1 , 9 , '18,20,22' insert Testdata select 2 , 8 , '17,19' insert Testdata select 3 , 7 , '13,19,20' insert Testdata select 4 , 6 , '' We want to get result like 1 9 18 1 9 20 1 9 22 2 8 17…. We can use below two options for this problem. Using function and table variable  CREATE FUNCTION dbo . Split (     @Line nvarchar ( MAX ),     @SplitOn nvarchar ( 5 ) = ',' ) RETURNS @RtnValue table (     Id INT NOT NULL IDENTITY ( 1 , 1 ) PRIMARY KEY CLUSTERED ,     Data nvarchar ( 100 ) NOT NULL ) AS BEGIN     IF @Line IS NULL RETURN     DECLARE @split_on_len INT = LEN ( @SplitOn )   ...

In this article we will see how CTE can be used to get manager information and its employee level. As CTE can be used in recursive and no-recursive queries. We will use recursive approach to get desired result 1. First create table with below structure IF OBJECT_ID('tEmployees', 'U') IS NOT NULL DROP TABLE dbo.tEmployees GO CREATE TABLE dbo.tEmployees (   EmployeeID int NOT NULL PRIMARY KEY,   FirstName varchar(50) NOT NULL,   LastName varchar(50) NOT NULL,   ManagerID int NULL ) GO 2. Insert some records into INSERT INTO tEmployees VALUES (101, 'Ken', 'Sánchez', NULL) INSERT INTO tEmployees VALUES (102, 'Terri', 'Duffy', 101) INSERT INTO tEmployees VALUES (103, 'Roberto', 'Tamburello', 101) INSERT INTO tEmployees VALUES (104, 'Rob', 'Walters', 102) INSERT INTO tEmployees VALUES (105, 'Gail', 'Erickson', 102) INSERT INTO tEmployees VALUES (106, 'Jossef', ...

In MVC application, we can register routes in RouteCollection using RouteConfig . This RouteConfig is called using Application_Start of application. RouteConfig is configured as below routes.MapRoute(                 name: "Default" ,                 url: "{controller}/{action}/{id}" ,                 defaults: new { controller = "ProgramConfigEditor" , action = "Index" , id = UrlParameter .Optional }             ); We can register route of the application using Route Class as below. After creation of Route collection, it will move to MvcRouteHandler object. Route route = new Route ( "{controller}/{action}/{id}" ,           ...