SQL Server Websites

By: Jeremy Kadlec | Updated: 2022-03-14 | Comments (3) | Related: More > Professional Development Community

Problem

Time is of the essence when SQL Server is down or when pressure is mounting from multiple project deadlines. So finding accurate information quickly is difficult at best. When you are not sure where to turn for valuable information stress levels only increase.

Solution

The Internet remains one of the best resources to find valuable information quickly. Below is a list of SQL Server sites that we know of today that have valuable information. Some are focused on particular aspects of SQL Server while others offer more general information.

Updated: 3/14/2022

Microsoft SQL Server Resources

Independent SQL Server Web Sites

Do not forget about using your favorite search engine such as Google to find the answer to your SQL Server question.

Next Steps

Bookmark this page as a centralized SQL Server resource for future research.
As time permits, browse these sites to pickup some good information.
When the need arises, take a look at these sites to address your questions.
Keep looking back at this list as we will continue to update it.

About the author

Jeremy Kadlec is a Co-Founder, Editor and Author at MSSQLTips.com with more than 300 contributions. He is also the CTO @ Edgewood Solutions and a six-time SQL Server MVP. Jeremy brings 20+ years of SQL Server DBA and Developer experience to the community after earning a bachelor's degree from SSU and master's from UMBC.

This author pledges the content of this article is based on professional experience and not AI generated.

View all my tips

Article Last Updated: 2022-03-14

Comments For This Article

Friday, January 3, 2020 - 11:57:41 AM - Clarens

Hi Jeremy,

Is this the most recent SQL Server Website list? I noticed this was posted/updated last on 2015. Can you provide or update it for 2020?

Thanks

Clarens

Wednesday, October 1, 2014 - 9:13:25 PM - Ichiro Okada

Hi Jeremy,

I'm new to SQL but need to learn fast as my job requires me.

Thanks for this great web site.

Monday, February 4, 2013 - 4:02:14 AM - Mahesh

Please find the below Query which has case with mutiple return value. I’m getting the following error: “Msg 512, Level 16, State 1, Line 4

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.”. I need a solution for this without using dynamic query.

1. The below Query is working fine but only for the Top 1 Record:

DECLARE @USERID NVARCHAR(MAX)

SET @USERID='1' //Paramter may be integer value or NULL.

SELECT * FROM USERDETAILS

WHERE REF_USER_ID

IN(CASE @USERID

WHEN '1' THEN (SELECT TOP(1) REF_USER_ID FROM USERDETAILS where Ref_Gender_ID in(1) )

ELSE REF_USER_ID END)

2. When I remove “TOP (1)” from sub-query, it returns more than one value and at that time I am getting the following error: “Msg 512, Level 16, State 1, Line 4

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.”

DECLARE @USERID NVARCHAR(MAX)

SET @USERID='1'

SELECT * FROM USERDETAILS

WHERE REF_USER_ID

IN(CASE @USERID

WHEN '1' THEN (SELECT REF_USER_ID FROM USERDETAILS where Ref_Gender_ID in(1) )

ELSE REF_USER_ID END)

Can you please provide me an alternate solution? Thanks in advance.

UserDetails Table Schema:

/****** Object: Table [dbo].[UserDetails] Script Date: 02/04/2013 13:04:03 ******/

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[UserDetails](

[Ref_User_ID] [int] IDENTITY(1,1) NOT NULL,

[User_Salutation] [nvarchar](max) NULL,

[User_Code] [nvarchar](max) NULL,

[User_FirstName] [nvarchar](max) NULL,

[User_MiddleName] [nvarchar](max) NULL,

[User_SurName] [nvarchar](max) NULL,

[User_Password] [nvarchar](max) NULL,

[User_Password_Setdate] [datetime] NULL,

[Ref_Grade_ID] [int] NULL,

[Ref_Gender_ID] [int] NULL,

[Ref_CostCenter_ID] [int] NULL,

[User_Type] [nvarchar](max) NULL,

[Ref_Desig_ID] [int] NULL,

[User_Email] [nvarchar](max) NULL,

[User_AlternateEmail] [nvarchar](max) NULL,

[Ref_City_ID] [int] NULL,

[Ref_Dept_ID] [int] NULL,

[Ref_UserType_ID] [int] NOT NULL,

[Ref_TMSRole_ID] [int] NULL,

[Screen_Name] [nvarchar](max) NULL,

[User_Date_Of_Joining] [datetime] NULL,

[Ref_Authority_ID] [int] NULL,

[User_Id_Reporting_Authority] [int] NULL,

[User_Birthdate] [datetime] NULL,

[User_Photo] [nvarchar](max) NULL,

[User_Active] [int] NULL,

[User_LoginLock] [int] NULL,

[User_PhoneNumber] [nvarchar](50) NULL,

[Ref_UserGroup_ID] [int] NULL,

[User_Address1] [nvarchar](max) NULL,

[User_CourseGroup_IDs] [nvarchar](max) NULL,

[User_Address2] [nvarchar](max) NULL,

[User_Address3] [nvarchar](max) NULL,

[User_MobileNumber] [nvarchar](50) NULL,

[CREATED_BY] [nvarchar](max) NULL,

[CREATED_DATETIME] [datetime] NOT NULL,

[LAST_UPDATED_BY] [nvarchar](max) NULL,

[LAST_UPDATED_DATETIME] [datetime] NULL,

[ACTIVE_FLAG] [bit] NULL,

[Ref_Domain_ID] [int] NOT NULL,

[SecurityQuestion] [nvarchar](max) NULL,

[SecurityQuestionAnswer] [nvarchar](max) NULL,

CONSTRAINT [PK_UserDetails] PRIMARY KEY CLUSTERED

(

[Ref_User_ID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

SET IDENTITY_INSERT [dbo].[UserDetails] ON

INSERT [dbo].[UserDetails] ([Ref_User_ID], [User_Salutation], [User_Code], [User_FirstName], [User_MiddleName], [User_SurName], [User_Password], [User_Password_Setdate], [Ref_Grade_ID], [Ref_Gender_ID], [Ref_CostCenter_ID], [User_Type], [Ref_Desig_ID], [User_Email], [User_AlternateEmail], [Ref_City_ID], [Ref_Dept_ID], [Ref_UserType_ID], [Ref_TMSRole_ID], [Screen_Name], [User_Date_Of_Joining], [Ref_Authority_ID], [User_Id_Reporting_Authority], [User_Birthdate], [User_Photo], [User_Active], [User_LoginLock], [User_PhoneNumber], [Ref_UserGroup_ID], [User_Address1], [User_CourseGroup_IDs], [User_Address2], [User_Address3], [User_MobileNumber], [CREATED_BY], [CREATED_DATETIME], [LAST_UPDATED_BY], [LAST_UPDATED_DATETIME], [ACTIVE_FLAG], [Ref_Domain_ID], [SecurityQuestion], [SecurityQuestionAnswer]) VALUES (137, N'1', N'test', N'Zobble', N'', N'Solution', N'0', CAST(0x0000A14E0140FF19 AS DateTime), 0, 1, 0, N'Admin', 19, N'har***[email protected]', N'', 1, 72, 1, 1, N'', CAST(0x00009F5B00000000 AS DateTime), 152, 146, CAST(0x00007F9600000000 AS DateTime), NULL, 1, NULL, N'', NULL, N'Dadar', NULL, NULL, NULL, N'9826667472', N'Admin Admin', CAST(0x0000A14E0140FF19 AS DateTime), N'Admin Admin', CAST(0x0000A14E0140FF19 AS DateTime), 1, 1, N'', N'')

INSERT [dbo].[UserDetails] ([Ref_User_ID], [User_Salutation], [User_Code], [User_FirstName], [User_MiddleName], [User_SurName], [User_Password], [User_Password_Setdate], [Ref_Grade_ID], [Ref_Gender_ID], [Ref_CostCenter_ID], [User_Type], [Ref_Desig_ID], [User_Email], [User_AlternateEmail], [Ref_City_ID], [Ref_Dept_ID], [Ref_UserType_ID], [Ref_TMSRole_ID], [Screen_Name], [User_Date_Of_Joining], [Ref_Authority_ID], [User_Id_Reporting_Authority], [User_Birthdate], [User_Photo], [User_Active], [User_LoginLock], [User_PhoneNumber], [Ref_UserGroup_ID], [User_Address1], [User_CourseGroup_IDs], [User_Address2], [User_Address3], [User_MobileNumber], [CREATED_BY], [CREATED_DATETIME], [LAST_UPDATED_BY], [LAST_UPDATED_DATETIME], [ACTIVE_FLAG], [Ref_Domain_ID], [SecurityQuestion], [SecurityQuestionAnswer]) VALUES (141, N'3', N'Amol', N'Anmol', N'', N'Mandowara', N'100', CAST(0x0000A14E01328C8C AS DateTime), 0, 2, 0, N'Admin', 0, N'[email protected]', N'', 1, 36, 1, 2, N'Amol', CAST(0x0000A00D00000000 AS DateTime), 152, 146, CAST(0x000080BE00000000 AS DateTime), NULL, 1, NULL, N'', NULL, N'Neemuch', NULL, NULL, NULL, N'5295461654', N'Admin Admin', CAST(0x0000A14E01328C8C AS DateTime), N'Admin Admin', CAST(0x0000A14E01328C8C AS DateTime), 1, 2, N'', N'')

INSERT [dbo].[UserDetails] ([Ref_User_ID], [User_Salutation], [User_Code], [User_FirstName], [User_MiddleName], [User_SurName], [User_Password], [User_Password_Setdate], [Ref_Grade_ID], [Ref_Gender_ID], [Ref_CostCenter_ID], [User_Type], [Ref_Desig_ID], [User_Email], [User_AlternateEmail], [Ref_City_ID], [Ref_Dept_ID], [Ref_UserType_ID], [Ref_TMSRole_ID], [Screen_Name], [User_Date_Of_Joining], [Ref_Authority_ID], [User_Id_Reporting_Authority], [User_Birthdate], [User_Photo], [User_Active], [User_LoginLock], [User_PhoneNumber], [Ref_UserGroup_ID], [User_Address1], [User_CourseGroup_IDs], [User_Address2], [User_Address3], [User_MobileNumber], [CREATED_BY], [CREATED_DATETIME], [LAST_UPDATED_BY], [LAST_UPDATED_DATETIME], [ACTIVE_FLAG], [Ref_Domain_ID], [SecurityQuestion], [SecurityQuestionAnswer]) VALUES (145, N'1', N'E101', N'Sunil', N'', N'Mengane', N'2', CAST(0x0000A14E012FF696 AS DateTime), 0, 1, 0, N'Admin', 0, N'[email protected]', N'', 1, 72, 1, 3, N'', CAST(0x00009FF800000000 AS DateTime), 152, 146, CAST(0x000073BE00000000 AS DateTime), NULL, 1, 0, N'', NULL, N'Jogeshwari', NULL, NULL, NULL, N'1111111111', N'Admin Admin', CAST(0x0000A14E012FF696 AS DateTime), N'Admin Admin', CAST(0x0000A14E012FF696 AS DateTime), 1, 3, N'', N'')

INSERT [dbo].[UserDetails] ([Ref_User_ID], [User_Salutation], [User_Code], [User_FirstName], [User_MiddleName], [User_SurName], [User_Password], [User_Password_Setdate], [Ref_Grade_ID], [Ref_Gender_ID], [Ref_CostCenter_ID], [User_Type], [Ref_Desig_ID], [User_Email], [User_AlternateEmail], [Ref_City_ID], [Ref_Dept_ID], [Ref_UserType_ID], [Ref_TMSRole_ID], [Screen_Name], [User_Date_Of_Joining], [Ref_Authority_ID], [User_Id_Reporting_Authority], [User_Birthdate], [User_Photo], [User_Active], [User_LoginLock], [User_PhoneNumber], [Ref_UserGroup_ID], [User_Address1], [User_CourseGroup_IDs], [User_Address2], [User_Address3], [User_MobileNumber], [CREATED_BY], [CREATED_DATETIME], [LAST_UPDATED_BY], [LAST_UPDATED_DATETIME], [ACTIVE_FLAG], [Ref_Domain_ID], [SecurityQuestion], [SecurityQuestionAnswer]) VALUES (146, N'3', N'mahesh', N'Admin', N'', N'Admin', N'1', CAST(0x0000A10900C5D430 AS DateTime), 4, 1, 42, N'Admin', 0, N'[email protected]', N'', 1, 169, 1, 4, N'', CAST(0x0000A00D00F429F1 AS DateTime), 152, 146, NULL, NULL, 1, 0, N'', 245, N'malad', N'', NULL, NULL, N'1234567890', N'User', CAST(0x0000A10900C5D430 AS DateTime), N'User', CAST(0x0000A10900C5D430 AS DateTime), 1, 4, NULL, NULL)

INSERT [dbo].[UserDetails] ([Ref_User_ID], [User_Salutation], [User_Code], [User_FirstName], [User_MiddleName], [User_SurName], [User_Password], [User_Password_Setdate], [Ref_Grade_ID], [Ref_Gender_ID], [Ref_CostCenter_ID], [User_Type], [Ref_Desig_ID], [User_Email], [User_AlternateEmail], [Ref_City_ID], [Ref_Dept_ID], [Ref_UserType_ID], [Ref_TMSRole_ID], [Screen_Name], [User_Date_Of_Joining], [Ref_Authority_ID], [User_Id_Reporting_Authority], [User_Birthdate], [User_Photo], [User_Active], [User_LoginLock], [User_PhoneNumber], [Ref_UserGroup_ID], [User_Address1], [User_CourseGroup_IDs], [User_Address2], [User_Address3], [User_MobileNumber], [CREATED_BY], [CREATED_DATETIME], [LAST_UPDATED_BY], [LAST_UPDATED_DATETIME], [ACTIVE_FLAG], [Ref_Domain_ID], [SecurityQuestion], [SecurityQuestionAnswer]) VALUES (147, N'1', N'ArunAnant', N'Hindu', N'', N'Gyaan', N'Arun@123', CAST(0x0000A14E012FC518 AS DateTime), 0, 1, 0, N'Admin', 0, N'[email protected]', N'', 1, 227, 3, 5, N'', CAST(0x0000A02900000000 AS DateTime), 152, 146, CAST(0x0000734900000000 AS DateTime), NULL, 1, 0, N'', NULL, N'Mumbai', NULL, NULL, NULL, N'9876543210', N'Admin Admin', CAST(0x0000A14E012FC518 AS DateTime), N'Admin Admin', CAST(0x0000A14E012FC518 AS DateTime), 1, 5, N'', N'')

INSERT [dbo].[UserDetails] ([Ref_User_ID], [User_Salutation], [User_Code], [User_FirstName], [User_MiddleName], [User_SurName], [User_Password], [User_Password_Setdate], [Ref_Grade_ID], [Ref_Gender_ID], [Ref_CostCenter_ID], [User_Type], [Ref_Desig_ID], [User_Email], [User_AlternateEmail], [Ref_City_ID], [Ref_Dept_ID], [Ref_UserType_ID], [Ref_TMSRole_ID], [Screen_Name], [User_Date_Of_Joining], [Ref_Authority_ID], [User_Id_Reporting_Authority], [User_Birthdate], [User_Photo], [User_Active], [User_LoginLock], [User_PhoneNumber], [Ref_UserGroup_ID], [User_Address1], [User_CourseGroup_IDs], [User_Address2], [User_Address3], [User_MobileNumber], [CREATED_BY], [CREATED_DATETIME], [LAST_UPDATED_BY], [LAST_UPDATED_DATETIME], [ACTIVE_FLAG], [Ref_Domain_ID], [SecurityQuestion], [SecurityQuestionAnswer]) VALUES (148, N'1', N'Chris', N'Christopher', N'Anthony', N'Fernandes', N'chris', CAST(0x0000A11D00000000 AS DateTime), 1, 1, 33, N'Admin', 173, N'[email protected]', NULL, 1, 169, 3, 1, N'Christopher', CAST(0x0000A00D00F429F1 AS DateTime), 153, 146, CAST(0x00007F5C00000000 AS DateTime), NULL, 1, 0, NULL, 236, N'Khar', N'', NULL, NULL, N'1111111111', N'User', CAST(0x0000A11D00E3C380 AS DateTime), N'User', NULL, 1, 1, NULL, NULL)

INSERT [dbo].[UserDetails] ([Ref_User_ID], [User_Salutation], [User_Code], [User_FirstName], [User_MiddleName], [User_SurName], [User_Password], [User_Password_Setdate], [Ref_Grade_ID], [Ref_Gender_ID], [Ref_CostCenter_ID], [User_Type], [Ref_Desig_ID], [User_Email], [User_AlternateEmail], [Ref_City_ID], [Ref_Dept_ID], [Ref_UserType_ID], [Ref_TMSRole_ID], [Screen_Name], [User_Date_Of_Joining], [Ref_Authority_ID], [User_Id_Reporting_Authority], [User_Birthdate], [User_Photo], [User_Active], [User_LoginLock], [User_PhoneNumber], [Ref_UserGroup_ID], [User_Address1], [User_CourseGroup_IDs], [User_Address2], [User_Address3], [User_MobileNumber], [CREATED_BY], [CREATED_DATETIME], [LAST_UPDATED_BY], [LAST_UPDATED_DATETIME], [ACTIVE_FLAG], [Ref_Domain_ID], [SecurityQuestion], [SecurityQuestionAnswer]) VALUES (170, N'1', N'riyaz', N'Riyazii', N'', N'khan', N'123456789', CAST(0x0000A1500102FBDF AS DateTime), 0, 1, 0, N'Admin', 173, N'[email protected]', N'', 1, 169, 1, NULL, N'Walter', CAST(0x0000A11F00000000 AS DateTime), 153, NULL, NULL, NULL, 1, 0, N'', NULL, N'nbbvnbvb', NULL, NULL, NULL, N'', N'Admin Admin', CAST(0x0000A1500102FBDF AS DateTime), N'Admin Admin', CAST(0x0000A1500102FBDF AS DateTime), 1, 1, N'', N'')

INSERT [dbo].[UserDetails] ([Ref_User_ID], [User_Salutation], [User_Code], [User_FirstName], [User_MiddleName], [User_SurName], [User_Password], [User_Password_Setdate], [Ref_Grade_ID], [Ref_Gender_ID], [Ref_CostCenter_ID], [User_Type], [Ref_Desig_ID], [User_Email], [User_AlternateEmail], [Ref_City_ID], [Ref_Dept_ID], [Ref_UserType_ID], [Ref_TMSRole_ID], [Screen_Name], [User_Date_Of_Joining], [Ref_Authority_ID], [User_Id_Reporting_Authority], [User_Birthdate], [User_Photo], [User_Active], [User_LoginLock], [User_PhoneNumber], [Ref_UserGroup_ID], [User_Address1], [User_CourseGroup_IDs], [User_Address2], [User_Address3], [User_MobileNumber], [CREATED_BY], [CREATED_DATETIME], [LAST_UPDATED_BY], [LAST_UPDATED_DATETIME], [ACTIVE_FLAG], [Ref_Domain_ID], [SecurityQuestion], [SecurityQuestionAnswer]) VALUES (171, N'3', N'sanjeev', N'Sanjeev', N'Sumeet', N'Hira', N'123456789', CAST(0x0000A12C010363B0 AS DateTime), 0, 1, 0, N'Admin', 46, N'[email protected]', N'[email protected]', 70, 169, 1, NULL, N'Sanjeev', CAST(0x00009B8400000000 AS DateTime), 152, 146, CAST(0x0000542D00000000 AS DateTime), NULL, 1, 0, N'1122334455', NULL, N'Malad West', N'', NULL, NULL, N'5544332211', N'Admin Admin', CAST(0x0000A12C010363B0 AS DateTime), N'Admin Admin', CAST(0x0000A12C010363B0 AS DateTime), 1, 1, N'Y', N'Y')

INSERT [dbo].[UserDetails] ([Ref_User_ID], [User_Salutation], [User_Code], [User_FirstName], [User_MiddleName], [User_SurName], [User_Password], [User_Password_Setdate], [Ref_Grade_ID], [Ref_Gender_ID], [Ref_CostCenter_ID], [User_Type], [Ref_Desig_ID], [User_Email], [User_AlternateEmail], [Ref_City_ID], [Ref_Dept_ID], [Ref_UserType_ID], [Ref_TMSRole_ID], [Screen_Name], [User_Date_Of_Joining], [Ref_Authority_ID], [User_Id_Reporting_Authority], [User_Birthdate], [User_Photo], [User_Active], [User_LoginLock], [User_PhoneNumber], [Ref_UserGroup_ID], [User_Address1], [User_CourseGroup_IDs], [User_Address2], [User_Address3], [User_MobileNumber], [CREATED_BY], [CREATED_DATETIME], [LAST_UPDATED_BY], [LAST_UPDATED_DATETIME], [ACTIVE_FLAG], [Ref_Domain_ID], [SecurityQuestion], [SecurityQuestionAnswer]) VALUES (175, N'3', N'Gun', N'Gunjan', N'', N'Gupta', N'gupta', CAST(0x0000A12C0112B14E AS DateTime), 0, 1, 0, N'Admin', 173, N'[email protected]', N'', 1, 169, 1, NULL, N'Gunjan', CAST(0x0000A00D00000000 AS DateTime), 152, 146, NULL, NULL, 1, 0, N'111111111', NULL, N'Malad West', N'', NULL, NULL, N'9999999999', N'Admin Admin', CAST(0x0000A12C0112B14E AS DateTime), N'Admin Admin', CAST(0x0000A12C0112B14E AS DateTime), 1, 1, N'', N'')

INSERT [dbo].[UserDetails] ([Ref_User_ID], [User_Salutation], [User_Code], [User_FirstName], [User_MiddleName], [User_SurName], [User_Password], [User_Password_Setdate], [Ref_Grade_ID], [Ref_Gender_ID], [Ref_CostCenter_ID], [User_Type], [Ref_Desig_ID], [User_Email], [User_AlternateEmail], [Ref_City_ID], [Ref_Dept_ID], [Ref_UserType_ID], [Ref_TMSRole_ID], [Screen_Name], [User_Date_Of_Joining], [Ref_Authority_ID], [User_Id_Reporting_Authority], [User_Birthdate], [User_Photo], [User_Active], [User_LoginLock], [User_PhoneNumber], [Ref_UserGroup_ID], [User_Address1], [User_CourseGroup_IDs], [User_Address2], [User_Address3], [User_MobileNumber], [CREATED_BY], [CREATED_DATETIME], [LAST_UPDATED_BY], [LAST_UPDATED_DATETIME], [ACTIVE_FLAG], [Ref_Domain_ID], [SecurityQuestion], [SecurityQuestionAnswer]) VALUES (186, N'3', N'PL123', N'hj', N'', N'jjj', N'1', CAST(0x0000A12C01050640 AS DateTime), 0, 1, 0, N'Admin', 0, N'[email protected]', N'', 1, 72, 1, NULL, N'', CAST(0x0000A12800000000 AS DateTime), 152, NULL, NULL, NULL, 1, 0, N'', NULL, N'fgfg', N'', NULL, NULL, N'', N'Admin Admin', CAST(0x0000A12C01050640 AS DateTime), N'Admin Admin', CAST(0x0000A12C01050640 AS DateTime), 1, 1, N'hj', N'hk')

INSERT [dbo].[UserDetails] ([Ref_User_ID], [User_Salutation], [User_Code], [User_FirstName], [User_MiddleName], [User_SurName], [User_Password], [User_Password_Setdate], [Ref_Grade_ID], [Ref_Gender_ID], [Ref_CostCenter_ID], [User_Type], [Ref_Desig_ID], [User_Email], [User_AlternateEmail], [Ref_City_ID], [Ref_Dept_ID], [Ref_UserType_ID], [Ref_TMSRole_ID], [Screen_Name], [User_Date_Of_Joining], [Ref_Authority_ID], [User_Id_Reporting_Authority], [User_Birthdate], [User_Photo], [User_Active], [User_LoginLock], [User_PhoneNumber], [Ref_UserGroup_ID], [User_Address1], [User_CourseGroup_IDs], [User_Address2], [User_Address3], [User_MobileNumber], [CREATED_BY], [CREATED_DATETIME], [LAST_UPDATED_BY], [LAST_UPDATED_DATETIME], [ACTIVE_FLAG], [Ref_Domain_ID], [SecurityQuestion], [SecurityQuestionAnswer]) VALUES (187, N'1', N'nilesh', N'Niles', N'', N'Ghodse', N'0', CAST(0x0000A14E012F75F0 AS DateTime), 0, 1, 0, N'Admin', 46, N'[email protected]', N'[email protected]', 1, 72, 1, NULL, N'Nilesh Ghodse', CAST(0x0000A11E00000000 AS DateTime), 152, NULL, CAST(0x0000815D00000000 AS DateTime), NULL, 1, 0, N'999999999', NULL, N'nilesh ghodse', NULL, NULL, NULL, N'8888888888', N'Admin Admin', CAST(0x0000A14E012F75F0 AS DateTime), N'Admin Admin', CAST(0x0000A14E012F75F0 AS DateTime), 1, 1, N'GH', N'GH')

INSERT [dbo].[UserDetails] ([Ref_User_ID], [User_Salutation], [User_Code], [User_FirstName], [User_MiddleName], [User_SurName], [User_Password], [User_Password_Setdate], [Ref_Grade_ID], [Ref_Gender_ID], [Ref_CostCenter_ID], [User_Type], [Ref_Desig_ID], [User_Email], [User_AlternateEmail], [Ref_City_ID], [Ref_Dept_ID], [Ref_UserType_ID], [Ref_TMSRole_ID], [Screen_Name], [User_Date_Of_Joining], [Ref_Authority_ID], [User_Id_Reporting_Authority], [User_Birthdate], [User_Photo], [User_Active], [User_LoginLock], [User_PhoneNumber], [Ref_UserGroup_ID], [User_Address1], [User_CourseGroup_IDs], [User_Address2], [User_Address3], [User_MobileNumber], [CREATED_BY], [CREATED_DATETIME], [LAST_UPDATED_BY], [LAST_UPDATED_DATETIME], [ACTIVE_FLAG], [Ref_Domain_ID], [SecurityQuestion], [SecurityQuestionAnswer]) VALUES (205, N'2', N'prash123', N'Prashant', N'', N'Ahire', N'qwe', CAST(0x0000A13A0118E950 AS DateTime), 0, 1, 0, N'Admin', 0, N'[email protected]', N'', 1, 0, 1, NULL, N'', CAST(0x0000A13A00000000 AS DateTime), 153, NULL, NULL, NULL, 1, 0, N'', NULL, N'asdf', N'', NULL, NULL, N'', N'Admin Admin', CAST(0x0000A13A0118E950 AS DateTime), N'Admin Admin', CAST(0x0000A13A0118E950 AS DateTime), 1, 1, N'asd', N'asd')

INSERT [dbo].[UserDetails] ([Ref_User_ID], [User_Salutation], [User_Code], [User_FirstName], [User_MiddleName], [User_SurName], [User_Password], [User_Password_Setdate], [Ref_Grade_ID], [Ref_Gender_ID], [Ref_CostCenter_ID], [User_Type], [Ref_Desig_ID], [User_Email], [User_AlternateEmail], [Ref_City_ID], [Ref_Dept_ID], [Ref_UserType_ID], [Ref_TMSRole_ID], [Screen_Name], [User_Date_Of_Joining], [Ref_Authority_ID], [User_Id_Reporting_Authority], [User_Birthdate], [User_Photo], [User_Active], [User_LoginLock], [User_PhoneNumber], [Ref_UserGroup_ID], [User_Address1], [User_CourseGroup_IDs], [User_Address2], [User_Address3], [User_MobileNumber], [CREATED_BY], [CREATED_DATETIME], [LAST_UPDATED_BY], [LAST_UPDATED_DATETIME], [ACTIVE_FLAG], [Ref_Domain_ID], [SecurityQuestion], [SecurityQuestionAnswer]) VALUES (206, N'2', N'test11', N'XYZ', N'', N'ABC', N'123', CAST(0x0000A13A01448605 AS DateTime), 0, 1, 0, N'User', 0, N'[email protected]', N'', 1, 0, 1, NULL, N'', CAST(0x0000A13A01448605 AS DateTime), NULL, NULL, NULL, NULL, 1, 0, N'', NULL, N'fgh', N'', NULL, NULL, N'', N'Admin Admin', CAST(0x0000A13A01448605 AS DateTime), N'Admin Admin', CAST(0x0000A13A01448605 AS DateTime), 1, 1, N'asd', N'asd')

INSERT [dbo].[UserDetails] ([Ref_User_ID], [User_Salutation], [User_Code], [User_FirstName], [User_MiddleName], [User_SurName], [User_Password], [User_Password_Setdate], [Ref_Grade_ID], [Ref_Gender_ID], [Ref_CostCenter_ID], [User_Type], [Ref_Desig_ID], [User_Email], [User_AlternateEmail], [Ref_City_ID], [Ref_Dept_ID], [Ref_UserType_ID], [Ref_TMSRole_ID], [Screen_Name], [User_Date_Of_Joining], [Ref_Authority_ID], [User_Id_Reporting_Authority], [User_Birthdate], [User_Photo], [User_Active], [User_LoginLock], [User_PhoneNumber], [Ref_UserGroup_ID], [User_Address1], [User_CourseGroup_IDs], [User_Address2], [User_Address3], [User_MobileNumber], [CREATED_BY], [CREATED_DATETIME], [LAST_UPDATED_BY], [LAST_UPDATED_DATETIME], [ACTIVE_FLAG], [Ref_Domain_ID], [SecurityQuestion], [SecurityQuestionAnswer]) VALUES (209, N'2', N'qqqqqq', N'deletetest', N'', N'ABC', N'11111', CAST(0x0000A14100BE54A3 AS DateTime), 0, 1, 0, N'Admin', 0, N'[email protected]', N'', 1, 0, 1, NULL, N'', CAST(0x0000A14100BE54A3 AS DateTime), 153, NULL, NULL, NULL, 1, 0, N'', NULL, N'qqqqqqqqqqqqqq', N'', NULL, NULL, N'', N'Admin Admin', CAST(0x0000A14100BE54A3 AS DateTime), N'Admin Admin', CAST(0x0000A14100BE54A3 AS DateTime), 1, 1, N'', N'')

INSERT [dbo].[UserDetails] ([Ref_User_ID], [User_Salutation], [User_Code], [User_FirstName], [User_MiddleName], [User_SurName], [User_Password], [User_Password_Setdate], [Ref_Grade_ID], [Ref_Gender_ID], [Ref_CostCenter_ID], [User_Type], [Ref_Desig_ID], [User_Email], [User_AlternateEmail], [Ref_City_ID], [Ref_Dept_ID], [Ref_UserType_ID], [Ref_TMSRole_ID], [Screen_Name], [User_Date_Of_Joining], [Ref_Authority_ID], [User_Id_Reporting_Authority], [User_Birthdate], [User_Photo], [User_Active], [User_LoginLock], [User_PhoneNumber], [Ref_UserGroup_ID], [User_Address1], [User_CourseGroup_IDs], [User_Address2], [User_Address3], [User_MobileNumber], [CREATED_BY], [CREATED_DATETIME], [LAST_UPDATED_BY], [LAST_UPDATED_DATETIME], [ACTIVE_FLAG], [Ref_Domain_ID], [SecurityQuestion], [SecurityQuestionAnswer]) VALUES (212, N'3', N'SKH123', N'hirasanjeev', N'', N'hira', N'1', CAST(0x0000A14A01159008 AS DateTime), 0, 1, 0, N'Admin', 173, N'[email protected]', N'', 1, 227, 1, NULL, N'', CAST(0x0000A14400000000 AS DateTime), 152, NULL, NULL, NULL, 1, 0, N'', NULL, N'fgg', NULL, NULL, NULL, N'', N'Admin Admin', CAST(0x0000A14A01159008 AS DateTime), N'Admin Admin', CAST(0x0000A14A01159008 AS DateTime), 1, 1, N'', N'')

INSERT [dbo].[UserDetails] ([Ref_User_ID], [User_Salutation], [User_Code], [User_FirstName], [User_MiddleName], [User_SurName], [User_Password], [User_Password_Setdate], [Ref_Grade_ID], [Ref_Gender_ID], [Ref_CostCenter_ID], [User_Type], [Ref_Desig_ID], [User_Email], [User_AlternateEmail], [Ref_City_ID], [Ref_Dept_ID], [Ref_UserType_ID], [Ref_TMSRole_ID], [Screen_Name], [User_Date_Of_Joining], [Ref_Authority_ID], [User_Id_Reporting_Authority], [User_Birthdate], [User_Photo], [User_Active], [User_LoginLock], [User_PhoneNumber], [Ref_UserGroup_ID], [User_Address1], [User_CourseGroup_IDs], [User_Address2], [User_Address3], [User_MobileNumber], [CREATED_BY], [CREATED_DATETIME], [LAST_UPDATED_BY], [LAST_UPDATED_DATETIME], [ACTIVE_FLAG], [Ref_Domain_ID], [SecurityQuestion], [SecurityQuestionAnswer]) VALUES (213, N'3', N'klh123', N'ff', N'', N'fff', N'1', CAST(0x0000A14400F60600 AS DateTime), 0, 1, 0, N'Admin', 0, N'[email protected]', N'', 1, 0, 1, NULL, N'', CAST(0x0000A14400F60600 AS DateTime), 152, NULL, NULL, NULL, 1, 0, N'', NULL, N'dgfg', N'', NULL, NULL, N'', N'Admin Admin', CAST(0x0000A14400F60600 AS DateTime), N'Admin Admin', CAST(0x0000A14400F60600 AS DateTime), 1, 1, N'', N'')

INSERT [dbo].[UserDetails] ([Ref_User_ID], [User_Salutation], [User_Code], [User_FirstName], [User_MiddleName], [User_SurName], [User_Password], [User_Password_Setdate], [Ref_Grade_ID], [Ref_Gender_ID], [Ref_CostCenter_ID], [User_Type], [Ref_Desig_ID], [User_Email], [User_AlternateEmail], [Ref_City_ID], [Ref_Dept_ID], [Ref_UserType_ID], [Ref_TMSRole_ID], [Screen_Name], [User_Date_Of_Joining], [Ref_Authority_ID], [User_Id_Reporting_Authority], [User_Birthdate], [User_Photo], [User_Active], [User_LoginLock], [User_PhoneNumber], [Ref_UserGroup_ID], [User_Address1], [User_CourseGroup_IDs], [User_Address2], [User_Address3], [User_MobileNumber], [CREATED_BY], [CREATED_DATETIME], [LAST_UPDATED_BY], [LAST_UPDATED_DATETIME], [ACTIVE_FLAG], [Ref_Domain_ID], [SecurityQuestion], [SecurityQuestionAnswer]) VALUES (214, N'3', N'yuo123', N'riyaz', N'', N'khan', N'1', CAST(0x0000A14400F8ED5A AS DateTime), 0, 1, 0, N'Admin', 0, N'[email protected]', N'', 1, 72, 1, NULL, N'', CAST(0x0000A14400F8ED5A AS DateTime), 152, NULL, NULL, NULL, 1, 0, N'', NULL, N'ffgg', N'', NULL, NULL, N'', N'Admin Admin', CAST(0x0000A14400F8ED5A AS DateTime), N'Admin Admin', CAST(0x0000A14400F8ED5A AS DateTime), 1, 1, N'', N'')

INSERT [dbo].[UserDetails] ([Ref_User_ID], [User_Salutation], [User_Code], [User_FirstName], [User_MiddleName], [User_SurName], [User_Password], [User_Password_Setdate], [Ref_Grade_ID], [Ref_Gender_ID], [Ref_CostCenter_ID], [User_Type], [Ref_Desig_ID], [User_Email], [User_AlternateEmail], [Ref_City_ID], [Ref_Dept_ID], [Ref_UserType_ID], [Ref_TMSRole_ID], [Screen_Name], [User_Date_Of_Joining], [Ref_Authority_ID], [User_Id_Reporting_Authority], [User_Birthdate], [User_Photo], [User_Active], [User_LoginLock], [User_PhoneNumber], [Ref_UserGroup_ID], [User_Address1], [User_CourseGroup_IDs], [User_Address2], [User_Address3], [User_MobileNumber], [CREATED_BY], [CREATED_DATETIME], [LAST_UPDATED_BY], [LAST_UPDATED_DATETIME], [ACTIVE_FLAG], [Ref_Domain_ID], [SecurityQuestion], [SecurityQuestionAnswer]) VALUES (215, N'3', N'liooonnnhh', N'dfgf', N'', N'hghh', N'a', CAST(0x0000A14401155AEF AS DateTime), 0, 1, 0, N'Admin', 0, N'[email protected]', N'', 1, 72, 1, NULL, N'', CAST(0x0000A14401155AEF AS DateTime), 152, NULL, NULL, NULL, 1, 0, N'', NULL, N'hgjj', N'', NULL, NULL, N'', N'Admin Admin', CAST(0x0000A14401155AEF AS DateTime), N'Admin Admin', CAST(0x0000A14401155AEF AS DateTime), 1, 1, N'', N'')

INSERT [dbo].[UserDetails] ([Ref_User_ID], [User_Salutation], [User_Code], [User_FirstName], [User_MiddleName], [User_SurName], [User_Password], [User_Password_Setdate], [Ref_Grade_ID], [Ref_Gender_ID], [Ref_CostCenter_ID], [User_Type], [Ref_Desig_ID], [User_Email], [User_AlternateEmail], [Ref_City_ID], [Ref_Dept_ID], [Ref_UserType_ID], [Ref_TMSRole_ID], [Screen_Name], [User_Date_Of_Joining], [Ref_Authority_ID], [User_Id_Reporting_Authority], [User_Birthdate], [User_Photo], [User_Active], [User_LoginLock], [User_PhoneNumber], [Ref_UserGroup_ID], [User_Address1], [User_CourseGroup_IDs], [User_Address2], [User_Address3], [User_MobileNumber], [CREATED_BY], [CREATED_DATETIME], [LAST_UPDATED_BY], [LAST_UPDATED_DATETIME], [ACTIVE_FLAG], [Ref_Domain_ID], [SecurityQuestion], [SecurityQuestionAnswer]) VALUES (216, N'3', N'liooonnnhh', N'fggh', N'', N'ghhh', N'1', CAST(0x0000A14401164B7F AS DateTime), 0, 1, 0, N'Admin', 0, N'[email protected]', N'', 1, 0, 1, NULL, N'', CAST(0x0000A14401164B7F AS DateTime), 152, NULL, NULL, NULL, 1, 0, N'', NULL, N'jk', N'', NULL, NULL, N'', N'Admin Admin', CAST(0x0000A14401164B7F AS DateTime), N'Admin Admin', CAST(0x0000A14401164B7F AS DateTime), 1, 1, N'', N'')

INSERT [dbo].[UserDetails] ([Ref_User_ID], [User_Salutation], [User_Code], [User_FirstName], [User_MiddleName], [User_SurName], [User_Password], [User_Password_Setdate], [Ref_Grade_ID], [Ref_Gender_ID], [Ref_CostCenter_ID], [User_Type], [Ref_Desig_ID], [User_Email], [User_AlternateEmail], [Ref_City_ID], [Ref_Dept_ID], [Ref_UserType_ID], [Ref_TMSRole_ID], [Screen_Name], [User_Date_Of_Joining], [Ref_Authority_ID], [User_Id_Reporting_Authority], [User_Birthdate], [User_Photo], [User_Active], [User_LoginLock], [User_PhoneNumber], [Ref_UserGroup_ID], [User_Address1], [User_CourseGroup_IDs], [User_Address2], [User_Address3], [User_MobileNumber], [CREATED_BY], [CREATED_DATETIME], [LAST_UPDATED_BY], [LAST_UPDATED_DATETIME], [ACTIVE_FLAG], [Ref_Domain_ID], [SecurityQuestion], [SecurityQuestionAnswer]) VALUES (220, N'3', N'pui123', N'vbbb', N'', N'vvvv', N'1', CAST(0x0000A14A01178D99 AS DateTime), 0, 1, 0, N'Admin', 0, N'[email protected]', N'', 1, 72, 1, NULL, N'', CAST(0x0000A14A00000000 AS DateTime), 152, NULL, NULL, NULL, 1, 0, N'', NULL, N'cvcv', NULL, NULL, NULL, N'', N'Admin Admin', CAST(0x0000A14A01178D99 AS DateTime), N'Admin Admin', CAST(0x0000A14A01178D99 AS DateTime), 1, 1, N'', N'')

INSERT [dbo].[UserDetails] ([Ref_User_ID], [User_Salutation], [User_Code], [User_FirstName], [User_MiddleName], [User_SurName], [User_Password], [User_Password_Setdate], [Ref_Grade_ID], [Ref_Gender_ID], [Ref_CostCenter_ID], [User_Type], [Ref_Desig_ID], [User_Email], [User_AlternateEmail], [Ref_City_ID], [Ref_Dept_ID], [Ref_UserType_ID], [Ref_TMSRole_ID], [Screen_Name], [User_Date_Of_Joining], [Ref_Authority_ID], [User_Id_Reporting_Authority], [User_Birthdate], [User_Photo], [User_Active], [User_LoginLock], [User_PhoneNumber], [Ref_UserGroup_ID], [User_Address1], [User_CourseGroup_IDs], [User_Address2], [User_Address3], [User_MobileNumber], [CREATED_BY], [CREATED_DATETIME], [LAST_UPDATED_BY], [LAST_UPDATED_DATETIME], [ACTIVE_FLAG], [Ref_Domain_ID], [SecurityQuestion], [SecurityQuestionAnswer]) VALUES (221, N'3', N'newuser', N'test', N'a', N'z', N'asdfgh', CAST(0x0000A14E00C12D4E AS DateTime), 0, 1, 0, N'User', 38, N'[email protected]', N'', 1, 165, 1, NULL, N'test', CAST(0x0000A14E00C12D4E AS DateTime), NULL, 171, NULL, NULL, 1, 0, N'', NULL, N'dfds sfdf fds', NULL, NULL, NULL, N'', N'Admin Admin', CAST(0x0000A14E00C12D4E AS DateTime), N'Admin Admin', CAST(0x0000A14E00C12D4E AS DateTime), 1, 1, N'a', N'b')

INSERT [dbo].[UserDetails] ([Ref_User_ID], [User_Salutation], [User_Code], [User_FirstName], [User_MiddleName], [User_SurName], [User_Password], [User_Password_Setdate], [Ref_Grade_ID], [Ref_Gender_ID], [Ref_CostCenter_ID], [User_Type], [Ref_Desig_ID], [User_Email], [User_AlternateEmail], [Ref_City_ID], [Ref_Dept_ID], [Ref_UserType_ID], [Ref_TMSRole_ID], [Screen_Name], [User_Date_Of_Joining], [Ref_Authority_ID], [User_Id_Reporting_Authority], [User_Birthdate], [User_Photo], [User_Active], [User_LoginLock], [User_PhoneNumber], [Ref_UserGroup_ID], [User_Address1], [User_CourseGroup_IDs], [User_Address2], [User_Address3], [User_MobileNumber], [CREATED_BY], [CREATED_DATETIME], [LAST_UPDATED_BY], [LAST_UPDATED_DATETIME], [ACTIVE_FLAG], [Ref_Domain_ID], [SecurityQuestion], [SecurityQuestionAnswer]) VALUES (222, N'1', N'sdsde', N'a', N'sd', N'ds', N'hggkjyy', CAST(0x0000A14E00D66BD9 AS DateTime), 0, 1, 0, N'User', 38, N'[email protected]', N'[email protected]', 1, 72, 2, NULL, N'fgfg', CAST(0x0000A14E00000000 AS DateTime), NULL, 171, CAST(0x00006FEC00000000 AS DateTime), NULL, 1, 0, N'', NULL, N'dfddf dfd', NULL, NULL, NULL, N'', N'Admin Admin', CAST(0x0000A14E00D66BD9 AS DateTime), N'Admin Admin', CAST(0x0000A14E00D66BD9 AS DateTime), 1, 1, N'', N'')

INSERT [dbo].[UserDetails] ([Ref_User_ID], [User_Salutation], [User_Code], [User_FirstName], [User_MiddleName], [User_SurName], [User_Password], [User_Password_Setdate], [Ref_Grade_ID], [Ref_Gender_ID], [Ref_CostCenter_ID], [User_Type], [Ref_Desig_ID], [User_Email], [User_AlternateEmail], [Ref_City_ID], [Ref_Dept_ID], [Ref_UserType_ID], [Ref_TMSRole_ID], [Screen_Name], [User_Date_Of_Joining], [Ref_Authority_ID], [User_Id_Reporting_Authority], [User_Birthdate], [User_Photo], [User_Active], [User_LoginLock], [User_PhoneNumber], [Ref_UserGroup_ID], [User_Address1], [User_CourseGroup_IDs], [User_Address2], [User_Address3], [User_MobileNumber], [CREATED_BY], [CREATED_DATETIME], [LAST_UPDATED_BY], [LAST_UPDATED_DATETIME], [ACTIVE_FLAG], [Ref_Domain_ID], [SecurityQuestion], [SecurityQuestionAnswer]) VALUES (223, N'3', N'asdwer', N'a', N'm', N'z', N'bbbbbbbbb', CAST(0x0000A14E00D8C77E AS DateTime), 0, 1, 0, N'User', 173, N'[email protected]', N'', 1, 72, 1, NULL, N'amz', CAST(0x0000A14F00000000 AS DateTime), NULL, 171, CAST(0x000070BD00000000 AS DateTime), NULL, 1, 0, N'', NULL, N'sddssd sdsdds', NULL, NULL, NULL, N'', N'Admin Admin', CAST(0x0000A14E00D8C77E AS DateTime), N'Admin Admin', CAST(0x0000A14E00D8C77E AS DateTime), 1, 1, N'', N'')

INSERT [dbo].[UserDetails] ([Ref_User_ID], [User_Salutation], [User_Code], [User_FirstName], [User_MiddleName], [User_SurName], [User_Password], [User_Password_Setdate], [Ref_Grade_ID], [Ref_Gender_ID], [Ref_CostCenter_ID], [User_Type], [Ref_Desig_ID], [User_Email], [User_AlternateEmail], [Ref_City_ID], [Ref_Dept_ID], [Ref_UserType_ID], [Ref_TMSRole_ID], [Screen_Name], [User_Date_Of_Joining], [Ref_Authority_ID], [User_Id_Reporting_Authority], [User_Birthdate], [User_Photo], [User_Active], [User_LoginLock], [User_PhoneNumber], [Ref_UserGroup_ID], [User_Address1], [User_CourseGroup_IDs], [User_Address2], [User_Address3], [User_MobileNumber], [CREATED_BY], [CREATED_DATETIME], [LAST_UPDATED_BY], [LAST_UPDATED_DATETIME], [ACTIVE_FLAG], [Ref_Domain_ID], [SecurityQuestion], [SecurityQuestionAnswer]) VALUES (224, N'3', N'fdrere', N'newuser', N'sd', N'z', N'sdsdsds', CAST(0x0000A14E00EA458A AS DateTime), 0, 1, 0, N'User', 0, N'[email protected]', N'', 1, 72, 1, NULL, N'Prash', CAST(0x0000A14F00000000 AS DateTime), NULL, 171, CAST(0x00007EF500000000 AS DateTime), NULL, 1, 0, N'', NULL, N'sdsd', NULL, NULL, NULL, N'', N'Admin Admin', CAST(0x0000A14E00EA458A AS DateTime), N'Admin Admin', CAST(0x0000A14E00EA458A AS DateTime), 1, 1, N'', N'')

INSERT [dbo].[UserDetails] ([Ref_User_ID], [User_Salutation], [User_Code], [User_FirstName], [User_MiddleName], [User_SurName], [User_Password], [User_Password_Setdate], [Ref_Grade_ID], [Ref_Gender_ID], [Ref_CostCenter_ID], [User_Type], [Ref_Desig_ID], [User_Email], [User_AlternateEmail], [Ref_City_ID], [Ref_Dept_ID], [Ref_UserType_ID], [Ref_TMSRole_ID], [Screen_Name], [User_Date_Of_Joining], [Ref_Authority_ID], [User_Id_Reporting_Authority], [User_Birthdate], [User_Photo], [User_Active], [User_LoginLock], [User_PhoneNumber], [Ref_UserGroup_ID], [User_Address1], [User_CourseGroup_IDs], [User_Address2], [User_Address3], [User_MobileNumber], [CREATED_BY], [CREATED_DATETIME], [LAST_UPDATED_BY], [LAST_UPDATED_DATETIME], [ACTIVE_FLAG], [Ref_Domain_ID], [SecurityQuestion], [SecurityQuestionAnswer]) VALUES (226, N'2', N'hjhjhj', N'PrashantA', N'm', N'prashant', N'ghhghg', CAST(0x0000A14E00F5E458 AS DateTime), 0, 1, 0, N'User', 173, N'[email protected]', N'', 1, 72, 2, NULL, N'Prash', CAST(0x0000A15B00000000 AS DateTime), NULL, 171, CAST(0x00007F9700000000 AS DateTime), NULL, 0, 0, N'', NULL, N'hjjhj', NULL, NULL, NULL, N'', N'Admin Admin', CAST(0x0000A14E00F5E458 AS DateTime), N'Admin Admin', CAST(0x0000A14E00F5E458 AS DateTime), 1, 1, N'', N'')

INSERT [dbo].[UserDetails] ([Ref_User_ID], [User_Salutation], [User_Code], [User_FirstName], [User_MiddleName], [User_SurName], [User_Password], [User_Password_Setdate], [Ref_Grade_ID], [Ref_Gender_ID], [Ref_CostCenter_ID], [User_Type], [Ref_Desig_ID], [User_Email], [User_AlternateEmail], [Ref_City_ID], [Ref_Dept_ID], [Ref_UserType_ID], [Ref_TMSRole_ID], [Screen_Name], [User_Date_Of_Joining], [Ref_Authority_ID], [User_Id_Reporting_Authority], [User_Birthdate], [User_Photo], [User_Active], [User_LoginLock], [User_PhoneNumber], [Ref_UserGroup_ID], [User_Address1], [User_CourseGroup_IDs], [User_Address2], [User_Address3], [User_MobileNumber], [CREATED_BY], [CREATED_DATETIME], [LAST_UPDATED_BY], [LAST_UPDATED_DATETIME], [ACTIVE_FLAG], [Ref_Domain_ID], [SecurityQuestion], [SecurityQuestionAnswer]) VALUES (227, N'1', N'vbcvbvc', N'hghh', N'gfhgf', N'gfhfgh', N'vbnnvbnb', CAST(0x0000A14E00F75523 AS DateTime), 0, 1, 0, N'User', 38, N'[email protected]', N'', 1, 72, 2, NULL, N'Prash', CAST(0x000070DA00000000 AS DateTime), NULL, 171, CAST(0x000070DA00000000 AS DateTime), NULL, 0, 0, N'', NULL, N'ghhh', NULL, NULL, NULL, N'', N'Admin Admin', CAST(0x0000A14E00F75523 AS DateTime), N'Admin Admin', CAST(0x0000A14E00F75523 AS DateTime), 1, 1, N'', N'')

INSERT [dbo].[UserDetails] ([Ref_User_ID], [User_Salutation], [User_Code], [User_FirstName], [User_MiddleName], [User_SurName], [User_Password], [User_Password_Setdate], [Ref_Grade_ID], [Ref_Gender_ID], [Ref_CostCenter_ID], [User_Type], [Ref_Desig_ID], [User_Email], [User_AlternateEmail], [Ref_City_ID], [Ref_Dept_ID], [Ref_UserType_ID], [Ref_TMSRole_ID], [Screen_Name], [User_Date_Of_Joining], [Ref_Authority_ID], [User_Id_Reporting_Authority], [User_Birthdate], [User_Photo], [User_Active], [User_LoginLock], [User_PhoneNumber], [Ref_UserGroup_ID], [User_Address1], [User_CourseGroup_IDs], [User_Address2], [User_Address3], [User_MobileNumber], [CREATED_BY], [CREATED_DATETIME], [LAST_UPDATED_BY], [LAST_UPDATED_DATETIME], [ACTIVE_FLAG], [Ref_Domain_ID], [SecurityQuestion], [SecurityQuestionAnswer]) VALUES (228, N'1', N'vbbvbvb', N'bvbvbv', N'm', N'prashant', N'fgfggfgf', CAST(0x0000A14E00F83241 AS DateTime), 0, 1, 0, N'User', 0, N'[email protected]', N'', 1, 72, 2, NULL, N'fgfg', CAST(0x0000627F00000000 AS DateTime), NULL, 171, CAST(0x0000627F00000000 AS DateTime), NULL, 0, 0, N'', NULL, N'bvbvbvb', NULL, NULL, NULL, N'', N'Admin Admin', CAST(0x0000A14E00F83241 AS DateTime), N'Admin Admin', CAST(0x0000A14E00F83241 AS DateTime), 1, 1, N'', N'')

INSERT [dbo].[UserDetails] ([Ref_User_ID], [User_Salutation], [User_Code], [User_FirstName], [User_MiddleName], [User_SurName], [User_Password], [User_Password_Setdate], [Ref_Grade_ID], [Ref_Gender_ID], [Ref_CostCenter_ID], [User_Type], [Ref_Desig_ID], [User_Email], [User_AlternateEmail], [Ref_City_ID], [Ref_Dept_ID], [Ref_UserType_ID], [Ref_TMSRole_ID], [Screen_Name], [User_Date_Of_Joining], [Ref_Authority_ID], [User_Id_Reporting_Authority], [User_Birthdate], [User_Photo], [User_Active], [User_LoginLock], [User_PhoneNumber], [Ref_UserGroup_ID], [User_Address1], [User_CourseGroup_IDs], [User_Address2], [User_Address3], [User_MobileNumber], [CREATED_BY], [CREATED_DATETIME], [LAST_UPDATED_BY], [LAST_UPDATED_DATETIME], [ACTIVE_FLAG], [Ref_Domain_ID], [SecurityQuestion], [SecurityQuestionAnswer]) VALUES (229, N'1', N'fgffggjj', N'afgf', N'sd', N'z', N'cvvcvcvc', CAST(0x0000A14E00FFAB7D AS DateTime), 0, 1, 0, N'User', 0, N'[email protected]', N'', 1, 72, 1, NULL, N'Prash', CAST(0x0000A14E00FFAB7D AS DateTime), NULL, 171, NULL, NULL, 0, 0, N'', NULL, N'fgfggf', NULL, NULL, NULL, N'', N'Admin Admin', CAST(0x0000A14E00FFAB7D AS DateTime), N'Admin Admin', CAST(0x0000A14E00FFAB7D AS DateTime), 1, 1, N'', N'')

INSERT [dbo].[UserDetails] ([Ref_User_ID], [User_Salutation], [User_Code], [User_FirstName], [User_MiddleName], [User_SurName], [User_Password], [User_Password_Setdate], [Ref_Grade_ID], [Ref_Gender_ID], [Ref_CostCenter_ID], [User_Type], [Ref_Desig_ID], [User_Email], [User_AlternateEmail], [Ref_City_ID], [Ref_Dept_ID], [Ref_UserType_ID], [Ref_TMSRole_ID], [Screen_Name], [User_Date_Of_Joining], [Ref_Authority_ID], [User_Id_Reporting_Authority], [User_Birthdate], [User_Photo], [User_Active], [User_LoginLock], [User_PhoneNumber], [Ref_UserGroup_ID], [User_Address1], [User_CourseGroup_IDs], [User_Address2], [User_Address3], [User_MobileNumber], [CREATED_BY], [CREATED_DATETIME], [LAST_UPDATED_BY], [LAST_UPDATED_DATETIME], [ACTIVE_FLAG], [Ref_Domain_ID], [SecurityQuestion], [SecurityQuestionAnswer]) VALUES (230, N'1', N'fgffggjjgff', N'afgfggfgg', N'sd', N'z', N'vbvbbvb', CAST(0x0000A14E0100AD48 AS DateTime), 0, 1, 0, N'User', 0, N'[email protected]', N'', 1, 72, 1, NULL, N'Prash', CAST(0x00007F2700000000 AS DateTime), NULL, 171, CAST(0x00007F2700000000 AS DateTime), NULL, 0, 0, N'', NULL, N'fgfggf', NULL, NULL, NULL, N'', N'Admin Admin', CAST(0x0000A14E0100AD48 AS DateTime), N'Admin Admin', CAST(0x0000A14E0100AD48 AS DateTime), 1, 1, N'', N'')

INSERT [dbo].[UserDetails] ([Ref_User_ID], [User_Salutation], [User_Code], [User_FirstName], [User_MiddleName], [User_SurName], [User_Password], [User_Password_Setdate], [Ref_Grade_ID], [Ref_Gender_ID], [Ref_CostCenter_ID], [User_Type], [Ref_Desig_ID], [User_Email], [User_AlternateEmail], [Ref_City_ID], [Ref_Dept_ID], [Ref_UserType_ID], [Ref_TMSRole_ID], [Screen_Name], [User_Date_Of_Joining], [Ref_Authority_ID], [User_Id_Reporting_Authority], [User_Birthdate], [User_Photo], [User_Active], [User_LoginLock], [User_PhoneNumber], [Ref_UserGroup_ID], [User_Address1], [User_CourseGroup_IDs], [User_Address2], [User_Address3], [User_MobileNumber], [CREATED_BY], [CREATED_DATETIME], [LAST_UPDATED_BY], [LAST_UPDATED_DATETIME], [ACTIVE_FLAG], [Ref_Domain_ID], [SecurityQuestion], [SecurityQuestionAnswer]) VALUES (231, N'1', N'fgffgmjjgffnn', N'afgfggfggnn', N'sd', N'z', N'nmnbmmnnmnb', CAST(0x0000A14E0101951D AS DateTime), 0, 1, 0, N'User', 0, N'[email protected]', N'', 1, 72, 1, NULL, N'Prash', CAST(0x000070DA00000000 AS DateTime), NULL, 171, CAST(0x000070DA00000000 AS DateTime), NULL, 0, 0, N'', NULL, N'fgfggf', NULL, NULL, NULL, N'', N'Admin Admin', CAST(0x0000A14E0101951D AS DateTime), N'Admin Admin', CAST(0x0000A14E0101951D AS DateTime), 1, 1, N'', N'')

INSERT [dbo].[UserDetails] ([Ref_User_ID], [User_Salutation], [User_Code], [User_FirstName], [User_MiddleName], [User_SurName], [User_Password], [User_Password_Setdate], [Ref_Grade_ID], [Ref_Gender_ID], [Ref_CostCenter_ID], [User_Type], [Ref_Desig_ID], [User_Email], [User_AlternateEmail], [Ref_City_ID], [Ref_Dept_ID], [Ref_UserType_ID], [Ref_TMSRole_ID], [Screen_Name], [User_Date_Of_Joining], [Ref_Authority_ID], [User_Id_Reporting_Authority], [User_Birthdate], [User_Photo], [User_Active], [User_LoginLock], [User_PhoneNumber], [Ref_UserGroup_ID], [User_Address1], [User_CourseGroup_IDs], [User_Address2], [User_Address3], [User_MobileNumber], [CREATED_BY], [CREATED_DATETIME], [LAST_UPDATED_BY], [LAST_UPDATED_DATETIME], [ACTIVE_FLAG], [Ref_Domain_ID], [SecurityQuestion], [SecurityQuestionAnswer]) VALUES (232, N'1', N'vbvbhgh', N'abvb', N'm', N'z', N'vbvbbvbb', CAST(0x0000A14E01101036 AS DateTime), 0, 1, 0, N'User', 38, N'[email protected]', N'[email protected]', 1, 165, 2, NULL, N'Prash', CAST(0x000070B700000000 AS DateTime), NULL, 171, CAST(0x000070B700000000 AS DateTime), NULL, 0, 0, N'', NULL, N'bvbvb', NULL, NULL, NULL, N'', N'Admin Admin', CAST(0x0000A14E01101036 AS DateTime), N'Admin Admin', CAST(0x0000A14E01101036 AS DateTime), 1, 1, N'', N'')

INSERT [dbo].[UserDetails] ([Ref_User_ID], [User_Salutation], [User_Code], [User_FirstName], [User_MiddleName], [User_SurName], [User_Password], [User_Password_Setdate], [Ref_Grade_ID], [Ref_Gender_ID], [Ref_CostCenter_ID], [User_Type], [Ref_Desig_ID], [User_Email], [User_AlternateEmail], [Ref_City_ID], [Ref_Dept_ID], [Ref_UserType_ID], [Ref_TMSRole_ID], [Screen_Name], [User_Date_Of_Joining], [Ref_Authority_ID], [User_Id_Reporting_Authority], [User_Birthdate], [User_Photo], [User_Active], [User_LoginLock], [User_PhoneNumber], [Ref_UserGroup_ID], [User_Address1], [User_CourseGroup_IDs], [User_Address2], [User_Address3], [User_MobileNumber], [CREATED_BY], [CREATED_DATETIME], [LAST_UPDATED_BY], [LAST_UPDATED_DATETIME], [ACTIVE_FLAG], [Ref_Domain_ID], [SecurityQuestion], [SecurityQuestionAnswer]) VALUES (233, N'1', N'cvcvgfgfg', N'PrashantAvcv', N'm', N'prashant', N'rtttrtrrgr', CAST(0x0000A14E0115EFC7 AS DateTime), 0, 1, 0, N'User', 38, N'[email protected]', N'', 1, 72, 2, NULL, N'fgfg', CAST(0x00007F9E00000000 AS DateTime), NULL, 171, CAST(0x00007F9E00000000 AS DateTime), NULL, 0, 0, N'', NULL, N'vcxcvvvc', NULL, NULL, NULL, N'', N'Admin Admin', CAST(0x0000A14E0115EFC7 AS DateTime), N'Admin Admin', CAST(0x0000A14E0115EFC7 AS DateTime), 1, 1, N'', N'')

INSERT [dbo].[UserDetails] ([Ref_User_ID], [User_Salutation], [User_Code], [User_FirstName], [User_MiddleName], [User_SurName], [User_Password], [User_Password_Setdate], [Ref_Grade_ID], [Ref_Gender_ID], [Ref_CostCenter_ID], [User_Type], [Ref_Desig_ID], [User_Email], [User_AlternateEmail], [Ref_City_ID], [Ref_Dept_ID], [Ref_UserType_ID], [Ref_TMSRole_ID], [Screen_Name], [User_Date_Of_Joining], [Ref_Authority_ID], [User_Id_Reporting_Authority], [User_Birthdate], [User_Photo], [User_Active], [User_LoginLock], [User_PhoneNumber], [Ref_UserGroup_ID], [User_Address1], [User_CourseGroup_IDs], [User_Address2], [User_Address3], [User_MobileNumber], [CREATED_BY], [CREATED_DATETIME], [LAST_UPDATED_BY], [LAST_UPDATED_DATETIME], [ACTIVE_FLAG], [Ref_Domain_ID], [SecurityQuestion], [SecurityQuestionAnswer]) VALUES (234, N'2', N'bnbnghg', N'PrashantAaa', N'm', N'z', N'bnbnnbb', CAST(0x0000A14E011A2DAB AS DateTime), 0, 1, 0, N'User', 0, N'[email protected]', N'', 1, 72, 2, NULL, N'amz', CAST(0x00007F9E00000000 AS DateTime), NULL, 171, CAST(0x00007F9E00000000 AS DateTime), NULL, 0, 0, N'', NULL, N'bnbbnb', NULL, NULL, NULL, N'', N'Admin Admin', CAST(0x0000A14E011A2DAB AS DateTime), N'Admin Admin', CAST(0x0000A14E011A2DAB AS DateTime), 1, 1, N'', N'')

INSERT [dbo].[UserDetails] ([Ref_User_ID], [User_Salutation], [User_Code], [User_FirstName], [User_MiddleName], [User_SurName], [User_Password], [User_Password_Setdate], [Ref_Grade_ID], [Ref_Gender_ID], [Ref_CostCenter_ID], [User_Type], [Ref_Desig_ID], [User_Email], [User_AlternateEmail], [Ref_City_ID], [Ref_Dept_ID], [Ref_UserType_ID], [Ref_TMSRole_ID], [Screen_Name], [User_Date_Of_Joining], [Ref_Authority_ID], [User_Id_Reporting_Authority], [User_Birthdate], [User_Photo], [User_Active], [User_LoginLock], [User_PhoneNumber], [Ref_UserGroup_ID], [User_Address1], [User_CourseGroup_IDs], [User_Address2], [User_Address3], [User_MobileNumber], [CREATED_BY], [CREATED_DATETIME], [LAST_UPDATED_BY], [LAST_UPDATED_DATETIME], [ACTIVE_FLAG], [Ref_Domain_ID], [SecurityQuestion], [SecurityQuestionAnswer]) VALUES (235, N'1', N'mnumn', N'Prashan', N'm', N'z', N'nmnmnmm', CAST(0x0000A14E0131662B AS DateTime), 0, 1, 0, N'User', 0, N'[email protected]', N'', 1, 72, 2, NULL, N'fgfg', CAST(0x0000714200000000 AS DateTime), NULL, 171, CAST(0x0000714200000000 AS DateTime), NULL, 1, 0, N'', NULL, N'nm gcgbvcb', NULL, NULL, NULL, N'', N'Admin Admin', CAST(0x0000A14E0131662B AS DateTime), N'Admin Admin', CAST(0x0000A14E0131662B AS DateTime), 1, 1, N'', N'')

INSERT [dbo].[UserDetails] ([Ref_User_ID], [User_Salutation], [User_Code], [User_FirstName], [User_MiddleName], [User_SurName], [User_Password], [User_Password_Setdate], [Ref_Grade_ID], [Ref_Gender_ID], [Ref_CostCenter_ID], [User_Type], [Ref_Desig_ID], [User_Email], [User_AlternateEmail], [Ref_City_ID], [Ref_Dept_ID], [Ref_UserType_ID], [Ref_TMSRole_ID], [Screen_Name], [User_Date_Of_Joining], [Ref_Authority_ID], [User_Id_Reporting_Authority], [User_Birthdate], [User_Photo], [User_Active], [User_LoginLock], [User_PhoneNumber], [Ref_UserGroup_ID], [User_Address1], [User_CourseGroup_IDs], [User_Address2], [User_Address3], [User_MobileNumber], [CREATED_BY], [CREATED_DATETIME], [LAST_UPDATED_BY], [LAST_UPDATED_DATETIME], [ACTIVE_FLAG], [Ref_Domain_ID], [SecurityQuestion], [SecurityQuestionAnswer]) VALUES (236, N'1', N'mnumnghghh', N'Prashan', N'm', N'z', N'fhfhhh', CAST(0x0000A14E0132743B AS DateTime), 0, 2, 0, N'User', 0, N'[email protected]', N'', 1, 0, 2, NULL, N'fgfg', CAST(0x00007F2800000000 AS DateTime), NULL, 171, CAST(0x0000629400000000 AS DateTime), NULL, 0, 0, N'', NULL, N'nm gcgbvcb', NULL, NULL, NULL, N'', N'Admin Admin', CAST(0x0000A14E0132743B AS DateTime), N'Admin Admin', CAST(0x0000A14E0132743B AS DateTime), 1, 1, N'', N'')

INSERT [dbo].[UserDetails] ([Ref_User_ID], [User_Salutation], [User_Code], [User_FirstName], [User_MiddleName], [User_SurName], [User_Password], [User_Password_Setdate], [Ref_Grade_ID], [Ref_Gender_ID], [Ref_CostCenter_ID], [User_Type], [Ref_Desig_ID], [User_Email], [User_AlternateEmail], [Ref_City_ID], [Ref_Dept_ID], [Ref_UserType_ID], [Ref_TMSRole_ID], [Screen_Name], [User_Date_Of_Joining], [Ref_Authority_ID], [User_Id_Reporting_Authority], [User_Birthdate], [User_Photo], [User_Active], [User_LoginLock], [User_PhoneNumber], [Ref_UserGroup_ID], [User_Address1], [User_CourseGroup_IDs], [User_Address2], [User_Address3], [User_MobileNumber], [CREATED_BY], [CREATED_DATETIME], [LAST_UPDATED_BY], [LAST_UPDATED_DATETIME], [ACTIVE_FLAG], [Ref_Domain_ID], [SecurityQuestion], [SecurityQuestionAnswer]) VALUES (237, N'2', N'vnnhj', N'PrashantAnn', N'm', N'prashant', N'cvcvvc', CAST(0x0000A14E0140F3A7 AS DateTime), 0, 1, 0, N'User', 0, N'[email protected]', N'', 1, 72, 2, NULL, N'Prash', CAST(0x000070B700000000 AS DateTime), NULL, 171, CAST(0x000070B700000000 AS DateTime), NULL, 0, 0, N'', NULL, N'vbnvnn', NULL, NULL, NULL, N'', N'Admin Admin', CAST(0x0000A14E0140F3A7 AS DateTime), N'Admin Admin', CAST(0x0000A14E0140F3A7 AS DateTime), 1, 1, N'', N'')

INSERT [dbo].[UserDetails] ([Ref_User_ID], [User_Salutation], [User_Code], [User_FirstName], [User_MiddleName], [User_SurName], [User_Password], [User_Password_Setdate], [Ref_Grade_ID], [Ref_Gender_ID], [Ref_CostCenter_ID], [User_Type], [Ref_Desig_ID], [User_Email], [User_AlternateEmail], [Ref_City_ID], [Ref_Dept_ID], [Ref_UserType_ID], [Ref_TMSRole_ID], [Screen_Name], [User_Date_Of_Joining], [Ref_Authority_ID], [User_Id_Reporting_Authority], [User_Birthdate], [User_Photo], [User_Active], [User_LoginLock], [User_PhoneNumber], [Ref_UserGroup_ID], [User_Address1], [User_CourseGroup_IDs], [User_Address2], [User_Address3], [User_MobileNumber], [CREATED_BY], [CREATED_DATETIME], [LAST_UPDATED_BY], [LAST_UPDATED_DATETIME], [ACTIVE_FLAG], [Ref_Domain_ID], [SecurityQuestion], [SecurityQuestionAnswer]) VALUES (238, N'4', N'rupali', N'Rupali', N'', N'Bhor', N'123', CAST(0x0000A15000E8C21B AS DateTime), 0, 2, 0, N'Admin', 195, N'[email protected]', N'', 1, 227, 1, NULL, N'', CAST(0x0000A15000E8C21B AS DateTime), 152, 146, NULL, NULL, 1, 0, N'', NULL, N'kk', NULL, NULL, NULL, N'', N'Admin Admin', CAST(0x0000A15000E8C21B AS DateTime), N'Admin Admin', CAST(0x0000A15000E8C21B AS DateTime), 1, 1, N'', N'')

INSERT [dbo].[UserDetails] ([Ref_User_ID], [User_Salutation], [User_Code], [User_FirstName], [User_MiddleName], [User_SurName], [User_Password], [User_Password_Setdate], [Ref_Grade_ID], [Ref_Gender_ID], [Ref_CostCenter_ID], [User_Type], [Ref_Desig_ID], [User_Email], [User_AlternateEmail], [Ref_City_ID], [Ref_Dept_ID], [Ref_UserType_ID], [Ref_TMSRole_ID], [Screen_Name], [User_Date_Of_Joining], [Ref_Authority_ID], [User_Id_Reporting_Authority], [User_Birthdate], [User_Photo], [User_Active], [User_LoginLock], [User_PhoneNumber], [Ref_UserGroup_ID], [User_Address1], [User_CourseGroup_IDs], [User_Address2], [User_Address3], [User_MobileNumber], [CREATED_BY], [CREATED_DATETIME], [LAST_UPDATED_BY], [LAST_UPDATED_DATETIME], [ACTIVE_FLAG], [Ref_Domain_ID], [SecurityQuestion], [SecurityQuestionAnswer]) VALUES (239, N'3', N'ahmersss', N'Ahmer', N'md', N'Siddiqui', N'asasss', CAST(0x0000A15000F8B95E AS DateTime), 0, 1, 0, N'User', 173, N'[email protected]', N'', 1, 72, 2, NULL, N'', CAST(0x00007F2000000000 AS DateTime), NULL, 171, CAST(0x00007F2000000000 AS DateTime), NULL, 0, 0, N'', NULL, N'mumbai', NULL, NULL, NULL, N'', N'Admin Admin', CAST(0x0000A15000F8B95E AS DateTime), N'Admin Admin', CAST(0x0000A15000F8B95E AS DateTime), 1, 1, N'', N'')

INSERT [dbo].[UserDetails] ([Ref_User_ID], [User_Salutation], [User_Code], [User_FirstName], [User_MiddleName], [User_SurName], [User_Password], [User_Password_Setdate], [Ref_Grade_ID], [Ref_Gender_ID], [Ref_CostCenter_ID], [User_Type], [Ref_Desig_ID], [User_Email], [User_AlternateEmail], [Ref_City_ID], [Ref_Dept_ID], [Ref_UserType_ID], [Ref_TMSRole_ID], [Screen_Name], [User_Date_Of_Joining], [Ref_Authority_ID], [User_Id_Reporting_Authority], [User_Birthdate], [User_Photo], [User_Active], [User_LoginLock], [User_PhoneNumber], [Ref_UserGroup_ID], [User_Address1], [User_CourseGroup_IDs], [User_Address2], [User_Address3], [User_MobileNumber], [CREATED_BY], [CREATED_DATETIME], [LAST_UPDATED_BY], [LAST_UPDATED_DATETIME], [ACTIVE_FLAG], [Ref_Domain_ID], [SecurityQuestion], [SecurityQuestionAnswer]) VALUES (240, N'2', N'yuiop', N'mnmn', N'm', N'n', N'fghfghgf', CAST(0x0000A15001021D16 AS DateTime), 0, 1, 0, N'User', 19, N'[email protected]', N'', 1, 72, 1, NULL, N'', CAST(0x0000715800000000 AS DateTime), NULL, NULL, NULL, NULL, 0, 0, N'', NULL, N'tyyui', NULL, NULL, NULL, N'', N'Admin Admin', CAST(0x0000A15001021D16 AS DateTime), N'Admin Admin', CAST(0x0000A15001021D16 AS DateTime), 1, 1, N'', N'')

INSERT [dbo].[UserDetails] ([Ref_User_ID], [User_Salutation], [User_Code], [User_FirstName], [User_MiddleName], [User_SurName], [User_Password], [User_Password_Setdate], [Ref_Grade_ID], [Ref_Gender_ID], [Ref_CostCenter_ID], [User_Type], [Ref_Desig_ID], [User_Email], [User_AlternateEmail], [Ref_City_ID], [Ref_Dept_ID], [Ref_UserType_ID], [Ref_TMSRole_ID], [Screen_Name], [User_Date_Of_Joining], [Ref_Authority_ID], [User_Id_Reporting_Authority], [User_Birthdate], [User_Photo], [User_Active], [User_LoginLock], [User_PhoneNumber], [Ref_UserGroup_ID], [User_Address1], [User_CourseGroup_IDs], [User_Address2], [User_Address3], [User_MobileNumber], [CREATED_BY], [CREATED_DATETIME], [LAST_UPDATED_BY], [LAST_UPDATED_DATETIME], [ACTIVE_FLAG], [Ref_Domain_ID], [SecurityQuestion], [SecurityQuestionAnswer]) VALUES (241, N'1', N'kunal', N'kunal', N'', N'vohra', N'vohra', CAST(0x0000A1500102B2CF AS DateTime), 0, 1, 0, N'Admin', 38, N'[email protected]', N'', 1, 72, 1, NULL, N'', CAST(0x0000631200000000 AS DateTime), 152, 171, CAST(0x0000631200000000 AS DateTime), NULL, 0, 0, N'', NULL, N'goregaon', NULL, NULL, NULL, N'', N'Admin Admin', CAST(0x0000A1500102B2CF AS DateTime), N'Admin Admin', CAST(0x0000A1500102B2CF AS DateTime), 1, 1, N'', N'')

INSERT [dbo].[UserDetails] ([Ref_User_ID], [User_Salutation], [User_Code], [User_FirstName], [User_MiddleName], [User_SurName], [User_Password], [User_Password_Setdate], [Ref_Grade_ID], [Ref_Gender_ID], [Ref_CostCenter_ID], [User_Type], [Ref_Desig_ID], [User_Email], [User_AlternateEmail], [Ref_City_ID], [Ref_Dept_ID], [Ref_UserType_ID], [Ref_TMSRole_ID], [Screen_Name], [User_Date_Of_Joining], [Ref_Authority_ID], [User_Id_Reporting_Authority], [User_Birthdate], [User_Photo], [User_Active], [User_LoginLock], [User_PhoneNumber], [Ref_UserGroup_ID], [User_Address1], [User_CourseGroup_IDs], [User_Address2], [User_Address3], [User_MobileNumber], [CREATED_BY], [CREATED_DATETIME], [LAST_UPDATED_BY], [LAST_UPDATED_DATETIME], [ACTIVE_FLAG], [Ref_Domain_ID], [SecurityQuestion], [SecurityQuestionAnswer]) VALUES (245, N'3', N'hjgjhj', N'fggfg', N'', N'dfgfgf', N'hjhghg', CAST(0x0000A15800CBA4CC AS DateTime), 0, 1, 0, N'Admin', 19, N'[email protected]', N'', 1, 227, 1, NULL, N'', CAST(0x00007F9F00000000 AS DateTime), 152, NULL, CAST(0x00007F9F00000000 AS DateTime), NULL, 0, 0, N'', NULL, N'yututy', NULL, NULL, NULL, N'', N'Anmol Mandowara', CAST(0x0000A15800CBA4CC AS DateTime), N'Anmol Mandowara', CAST(0x0000A15800CBA4CC AS DateTime), 1, 1, N'', N'')

INSERT [dbo].[UserDetails] ([Ref_User_ID], [User_Salutation], [User_Code], [User_FirstName], [User_MiddleName], [User_SurName], [User_Password], [User_Password_Setdate], [Ref_Grade_ID], [Ref_Gender_ID], [Ref_CostCenter_ID], [User_Type], [Ref_Desig_ID], [User_Email], [User_AlternateEmail], [Ref_City_ID], [Ref_Dept_ID], [Ref_UserType_ID], [Ref_TMSRole_ID], [Screen_Name], [User_Date_Of_Joining], [Ref_Authority_ID], [User_Id_Reporting_Authority], [User_Birthdate], [User_Photo], [User_Active], [User_LoginLock], [User_PhoneNumber], [Ref_UserGroup_ID], [User_Address1], [User_CourseGroup_IDs], [User_Address2], [User_Address3], [User_MobileNumber], [CREATED_BY], [CREATED_DATETIME], [LAST_UPDATED_BY], [LAST_UPDATED_DATETIME], [ACTIVE_FLAG], [Ref_Domain_ID], [SecurityQuestion], [SecurityQuestionAnswer]) VALUES (246, N'2', N'ahmer', N'gfhfh', N'fghgfhgf', N'gfhgf', N'jhjkj', CAST(0x0000A15800CC9D83 AS DateTime), 0, 1, 0, N'Admin', 173, N'[email protected]', N'', 1, 72, 2, NULL, N'', CAST(0x0000A15800CC9D83 AS DateTime), 152, NULL, NULL, NULL, 0, 0, N'', NULL, N'tryrytr', NULL, NULL, NULL, N'', N'Anmol Mandowara', CAST(0x0000A15800CC9D83 AS DateTime), N'Anmol Mandowara', CAST(0x0000A15800CC9D83 AS DateTime), 1, 1, N'', N'')

INSERT [dbo].[UserDetails] ([Ref_User_ID], [User_Salutation], [User_Code], [User_FirstName], [User_MiddleName], [User_SurName], [User_Password], [User_Password_Setdate], [Ref_Grade_ID], [Ref_Gender_ID], [Ref_CostCenter_ID], [User_Type], [Ref_Desig_ID], [User_Email], [User_AlternateEmail], [Ref_City_ID], [Ref_Dept_ID], [Ref_UserType_ID], [Ref_TMSRole_ID], [Screen_Name], [User_Date_Of_Joining], [Ref_Authority_ID], [User_Id_Reporting_Authority], [User_Birthdate], [User_Photo], [User_Active], [User_LoginLock], [User_PhoneNumber], [Ref_UserGroup_ID], [User_Address1], [User_CourseGroup_IDs], [User_Address2], [User_Address3], [User_MobileNumber], [CREATED_BY], [CREATED_DATETIME], [LAST_UPDATED_BY], [LAST_UPDATED_DATETIME], [ACTIVE_FLAG], [Ref_Domain_ID], [SecurityQuestion], [SecurityQuestionAnswer]) VALUES (247, N'3', N'YU123', N'xxx', N'', N'xxx', N'1', CAST(0x0000A159011F8502 AS DateTime), 0, 1, 0, N'User', 0, N'[email protected]', N'', 1, 0, 1, NULL, N'', CAST(0x0000A159011F8502 AS DateTime), NULL, NULL, NULL, NULL, 1, 0, N'', NULL, N'tt', NULL, NULL, NULL, N'', N'Admin Admin', CAST(0x0000A159011F8502 AS DateTime), N'Admin Admin', CAST(0x0000A159011F8502 AS DateTime), 1, 1, N'', N'')

SET IDENTITY_INSERT [dbo].[UserDetails] OFF

/****** Object: Default [DF_UserDetails_Ref_Dept_ID] Script Date: 02/04/2013 13:04:03 ******/