Learn more about SQL Server tools

mssqltips logo
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

SQL Server Websites


By:   |   Read Comments (2)   |   Related Tips: More > Professional Development Community

Attend this free live MSSQLTips webcast

SQL Server Performance Tuning Tips and Tricks
click here to learn more


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: 7/17/2015

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.


Last Update:

First Published: 2006-06-14


next webcast button


next tip button



About the author
MSSQLTips author Jeremy Kadlec Since 2002, Jeremy Kadlec has delivered value to the global SQL Server community as an MSSQLTips.com co-founder and Edgewood Solutions SQL Server Consultant.

View all my tips
Related Resources





Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 


Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



    



Wednesday, October 01, 2014 - 9:13:25 PM - Ichiro Okada Back To Top

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 04, 2013 - 4:02:14 AM - Mahesh Back To Top

 

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:


GO

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

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

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]

GO

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'[email protected]', 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 ******/

 


 


Learn more about SQL Server tools