if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Users]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Users]
GO

CREATE TABLE [dbo].[Users] (
	[UserID] [int] NOT NULL ,
	[DesignationID] [int] NOT NULL ,
	[FirstName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[LastName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[ManagerId] [int] NULL ,
	[AdministratorId] [int] NULL ,
	[Address] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[Sex] [nvarchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[Email] [nvarchar] (75) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[PasswordValue] [nvarchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[PhotographFileName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[IsAdmin] [nvarchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[IsActive] [nvarchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[DateOfJoin] [smalldatetime] NULL ,
	[IM1Type] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[IM1UserName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[IM2Type] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[IM2UserName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[IM3Type] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[IM3UserName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[IM4Type] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[IM4UserName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[IM5Type] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[IM5UserName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[Project] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL 
) ON [PRIMARY]
GO




if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SampleView]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[SampleView]
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

CREATE VIEW dbo.SampleView
AS
SELECT     UserID, FirstName, LastName, Email, FirstName + ' ' + LastName AS Name, PasswordValue, Project,ManagerId
FROM         dbo.Users Users_1


GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO


/*
Sample data
*/
INSERT INTO [Users] ([UserID],[DesignationID],[FirstName],[LastName],[ManagerId],[AdministratorId],[Address],[Sex],[Email],[PasswordValue],[PhotographFileName],[IsAdmin],[IsActive],[DateOfJoin],[IM1Type],[IM1UserName],[IM2Type],[IM2UserName],[IM3Type],[IM3UserName],[IM4Type],[IM4UserName],[IM5Type],[IM5UserName],[Project])VALUES(1,14,'John','Smith',0,0,'Address','M','john@skeltademo.com','john',NULL,'N','Y','Nov 14 2002 12:00:00:000AM','msn','skeltademo@hotmail.com','msn','skeltademoclient@hotmail.com','yahoo','chetan_hr','msn','chetan@netgalactic.com','','','Project1')
INSERT INTO [Users] ([UserID],[DesignationID],[FirstName],[LastName],[ManagerId],[AdministratorId],[Address],[Sex],[Email],[PasswordValue],[PhotographFileName],[IsAdmin],[IsActive],[DateOfJoin],[IM1Type],[IM1UserName],[IM2Type],[IM2UserName],[IM3Type],[IM3UserName],[IM4Type],[IM4UserName],[IM5Type],[IM5UserName],[Project])VALUES(2,2,'Kevin','Lane',1,0,'Addres','M','kevin@skeltademo.com','kevin',NULL,'N','Y','Nov 14 2002 12:00:00:000AM','msn','skeltademo@hotmail.com','msn','skeltademoclient@hotmail.com','yahoo','chetan_hr','msn','chetan@netgalactic.com',NULL,NULL,'Project1')
INSERT INTO [Users] ([UserID],[DesignationID],[FirstName],[LastName],[ManagerId],[AdministratorId],[Address],[Sex],[Email],[PasswordValue],[PhotographFileName],[IsAdmin],[IsActive],[DateOfJoin],[IM1Type],[IM1UserName],[IM2Type],[IM2UserName],[IM3Type],[IM3UserName],[IM4Type],[IM4UserName],[IM5Type],[IM5UserName],[Project])VALUES(3,3,'Lennard','Baker',1,13,'address','M','lennard@skeltademo.com','lennard',NULL,'N','Y','Nov 14 2002 12:00:00:000AM','msn','skeltademo@hotmail.com','msn','skeltademoclient@hotmail.com','yahoo','chetan_hr','msn','chetan@netgalactic.com',NULL,NULL,'Project1')
INSERT INTO [Users] ([UserID],[DesignationID],[FirstName],[LastName],[ManagerId],[AdministratorId],[Address],[Sex],[Email],[PasswordValue],[PhotographFileName],[IsAdmin],[IsActive],[DateOfJoin],[IM1Type],[IM1UserName],[IM2Type],[IM2UserName],[IM3Type],[IM3UserName],[IM4Type],[IM4UserName],[IM5Type],[IM5UserName],[Project])VALUES(4,1,'Ken','RutherFord',1,14,'address','M','ken@skeltademo.com','ken',NULL,'N','Y','Nov 14 2002 12:00:00:000AM','msn','skeltademo@hotmail.com','msn','skeltademoclient@hotmail.com','yahoo','chetan_hr','msn','chetan@netgalactic.com',NULL,NULL,'Project2')
INSERT INTO [Users] ([UserID],[DesignationID],[FirstName],[LastName],[ManagerId],[AdministratorId],[Address],[Sex],[Email],[PasswordValue],[PhotographFileName],[IsAdmin],[IsActive],[DateOfJoin],[IM1Type],[IM1UserName],[IM2Type],[IM2UserName],[IM3Type],[IM3UserName],[IM4Type],[IM4UserName],[IM5Type],[IM5UserName],[Project])VALUES(5,4,'Victor','Aslo',3,13,'address','M','victor@skeltademo.com','victor',NULL,'N','Y','Nov 14 2002 12:00:00:000AM','msn','skeltademo@hotmail.com','msn','skeltademoclient@hotmail.com','yahoo','chetan_hr','msn','chetan@netgalactic.com',NULL,NULL,'Project2')
INSERT INTO [Users] ([UserID],[DesignationID],[FirstName],[LastName],[ManagerId],[AdministratorId],[Address],[Sex],[Email],[PasswordValue],[PhotographFileName],[IsAdmin],[IsActive],[DateOfJoin],[IM1Type],[IM1UserName],[IM2Type],[IM2UserName],[IM3Type],[IM3UserName],[IM4Type],[IM4UserName],[IM5Type],[IM5UserName],[Project])VALUES(6,7,'George','Higgins',5,13,'address','M','george@skeltademo.com','george',NULL,'N','Y','Nov 14 2002 12:00:00:000AM','msn','skeltademo@hotmail.com','msn','skeltademoclient@hotmail.com','yahoo','chetan_hr','msn','chetan@netgalactic.com',NULL,NULL,'Project2')
INSERT INTO [Users] ([UserID],[DesignationID],[FirstName],[LastName],[ManagerId],[AdministratorId],[Address],[Sex],[Email],[PasswordValue],[PhotographFileName],[IsAdmin],[IsActive],[DateOfJoin],[IM1Type],[IM1UserName],[IM2Type],[IM2UserName],[IM3Type],[IM3UserName],[IM4Type],[IM4UserName],[IM5Type],[IM5UserName],[Project])VALUES(7,5,'Jim','Berkman',5,13,'address','M','jim@skeltademo.com','jim',NULL,'N','Y','Nov 14 2002 12:00:00:000AM','msn','skeltademo@hotmail.com','msn','skeltademoclient@hotmail.com','yahoo','chetan_hr','msn','chetan@netgalactic.com',NULL,NULL,'Project3')
INSERT INTO [Users] ([UserID],[DesignationID],[FirstName],[LastName],[ManagerId],[AdministratorId],[Address],[Sex],[Email],[PasswordValue],[PhotographFileName],[IsAdmin],[IsActive],[DateOfJoin],[IM1Type],[IM1UserName],[IM2Type],[IM2UserName],[IM3Type],[IM3UserName],[IM4Type],[IM4UserName],[IM5Type],[IM5UserName],[Project])VALUES(8,4,'Philip','Rogers',3,13,'address','M','philip@skeltademo.com','philip',NULL,'N','Y','Nov 14 2002 12:00:00:000AM','msn','skeltademo@hotmail.com','msn','skeltademoclient@hotmail.com','yahoo','chetan_hr','msn','chetan@netgalactic.com',NULL,NULL,'Project3')
INSERT INTO [Users] ([UserID],[DesignationID],[FirstName],[LastName],[ManagerId],[AdministratorId],[Address],[Sex],[Email],[PasswordValue],[PhotographFileName],[IsAdmin],[IsActive],[DateOfJoin],[IM1Type],[IM1UserName],[IM2Type],[IM2UserName],[IM3Type],[IM3UserName],[IM4Type],[IM4UserName],[IM5Type],[IM5UserName],[Project])VALUES(9,5,'Cathy','Zimmermann',8,13,'address','F','cathy@skeltademo.com','cathy',NULL,'N','Y','Nov 14 2002 12:00:00:000AM','msn','skeltademo@hotmail.com','msn','skeltademoclient@hotmail.com','yahoo','chetan_hr','msn','chetan@netgalactic.com',NULL,NULL,'Project3')
INSERT INTO [Users] ([UserID],[DesignationID],[FirstName],[LastName],[ManagerId],[AdministratorId],[Address],[Sex],[Email],[PasswordValue],[PhotographFileName],[IsAdmin],[IsActive],[DateOfJoin],[IM1Type],[IM1UserName],[IM2Type],[IM2UserName],[IM3Type],[IM3UserName],[IM4Type],[IM4UserName],[IM5Type],[IM5UserName],[Project])VALUES(10,5,'Mitchell','Carter',8,13,'address','M','mitchell@skeltademo.com','mitchell',NULL,'N','Y','Nov 14 2002 12:00:00:000AM','msn','skeltademo@hotmail.com','msn','skeltademoclient@hotmail.com','yahoo','chetan_hr','msn','chetan@netgalactic.com',NULL,NULL,'Project4')
INSERT INTO [Users] ([UserID],[DesignationID],[FirstName],[LastName],[ManagerId],[AdministratorId],[Address],[Sex],[Email],[PasswordValue],[PhotographFileName],[IsAdmin],[IsActive],[DateOfJoin],[IM1Type],[IM1UserName],[IM2Type],[IM2UserName],[IM3Type],[IM3UserName],[IM4Type],[IM4UserName],[IM5Type],[IM5UserName],[Project])VALUES(11,5,'Susan','Anderson',4,14,'address','M','susan@skeltademo.com','susan',NULL,'N','Y','Nov 14 2002 12:00:00:000AM','msn','skeltademo@hotmail.com','msn','skeltademoclient@hotmail.com','yahoo','chetan_hr','msn','chetan@netgalactic.com',NULL,NULL,'Project4')
INSERT INTO [Users] ([UserID],[DesignationID],[FirstName],[LastName],[ManagerId],[AdministratorId],[Address],[Sex],[Email],[PasswordValue],[PhotographFileName],[IsAdmin],[IsActive],[DateOfJoin],[IM1Type],[IM1UserName],[IM2Type],[IM2UserName],[IM3Type],[IM3UserName],[IM4Type],[IM4UserName],[IM5Type],[IM5UserName],[Project])VALUES(12,5,'Allen','Dorfman',4,14,'address','M','allen@skeltademo.com','allen',NULL,'N','Y','Nov 14 2002 12:00:00:000AM','msn','skeltademo@hotmail.com','msn','skeltademoclient@hotmail.com','yahoo','chetan_hr','msn','chetan@netgalactic.com',NULL,NULL,'Project4')
INSERT INTO [Users] ([UserID],[DesignationID],[FirstName],[LastName],[ManagerId],[AdministratorId],[Address],[Sex],[Email],[PasswordValue],[PhotographFileName],[IsAdmin],[IsActive],[DateOfJoin],[IM1Type],[IM1UserName],[IM2Type],[IM2UserName],[IM3Type],[IM3UserName],[IM4Type],[IM4UserName],[IM5Type],[IM5UserName],[Project])VALUES(13,11,'Daniel','Chong',1,0,'Address','M','daniel@skeltademo.com','daniel',NULL,'Y','Y','Nov 14 2002 12:00:00:000AM','msn','skeltademo@hotmail.com','msn','skeltademoclient@hotmail.com','yahoo','chetan_hr','msn','chetan@netgalactic.com',NULL,NULL,'Project4')
INSERT INTO [Users] ([UserID],[DesignationID],[FirstName],[LastName],[ManagerId],[AdministratorId],[Address],[Sex],[Email],[PasswordValue],[PhotographFileName],[IsAdmin],[IsActive],[DateOfJoin],[IM1Type],[IM1UserName],[IM2Type],[IM2UserName],[IM3Type],[IM3UserName],[IM4Type],[IM4UserName],[IM5Type],[IM5UserName],[Project])VALUES(14,11,'Thomas','Kensington',1,0,'address','M','thomas@skeltademo.com','thomas',NULL,'Y','Y','Nov 14 2002 12:00:00:000AM','msn','skeltademo@hotmail.com','msn','skeltademoclient@hotmail.com','yahoo','chetan_hr','msn','chetan@netgalactic.com',NULL,NULL,'Project4')