August 4, 2008 at 7:47 am
/****** Object: Table [dbo].[Help_DishaSiteMap] Script Date: 08/04/2008 19:09:54 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Help_DishaSiteMap]') AND type in (N'U'))
DROP TABLE [dbo].[Help_DishaSiteMap]
GO
/****** Object: Table [dbo].[Help_DishaSiteMap] Script Date: 08/04/2008 19:09:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Help_DishaSiteMap]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Help_DishaSiteMap](
[LinkId] [int] IDENTITY(1,1) NOT NULL,
[LinkName] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LinkURL] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[description] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[keywords] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
CONSTRAINT [PK_Help_DishaSiteMap] PRIMARY KEY CLUSTERED
(
[LinkId] ASC
)WITH (IGNORE_DUP_KEY = OFF)
)
END
GO
SET IDENTITY_INSERT [dbo].[Help_DishaSiteMap] ON
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (1, N'Course Master', N'http://192.168.0.53/Student_Module/student_module/course_mast.aspx', N'temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp ', N'Description xcvxcvx')
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (2, N'Fee Master', N'http://192.168.0.53/Student_Module/student_module/fee_master.aspx', N'anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anuanudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anuanudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anuanudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anuanudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anuanudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anuanudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anuanudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anuanudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anuanudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anuanudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anuanudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anuanudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anuanudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anuanudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anuanudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anuanudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anuanudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anuanudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anuanudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anuanudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anuanudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anuanudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anuanudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anuanudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anuanudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anuanudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anuanudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anuanudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anuanudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anuanudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anuanudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anuanudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anuanudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anuanudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anuanudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anuanudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anuanudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anudeep
anu
lngs,.n,.msng
skljgklns,m.ngf', N'Description Description Description Description Description Description Description Description Description Description Description Description Description Description Description Description Description Description Description Description Description Desedddddddddddddd')
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (3, N'Subject Master', N'http://192.168.0.53/Student_Module/student_module/Master_Data.aspx', N'gvvv', N'fff')
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (4, N'Subject - Semester Master', N'http://192.168.0.53/Student_Module/student_module/Master_Data.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (5, N'Exam Master', N'http://192.168.0.53/Student_Module/Exam_Module/MAST_EXAM.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (6, N'Employee Entry ', N'http://192.168.0.53/Student_Module/Employee/emp1.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (7, N'Designation', N'http://192.168.0.53/Student_Module/student_module/Desig_Hall.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (8, N'Time Table Preparation', N'http://192.168.0.53/Student_Module/student_module/nTimeTable.aspx', N'Time Table Description', N'Time Table Description')
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (9, N'Time Table Editing', N'http://192.168.0.53/Student_Module/student_module/AdminTimeTable/TimeTableEditing.aspx', N'ffff', N'ff')
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (10, N'Exam Date sheet', N'http://192.168.0.53/Student_Module/Exam_Module/Exam_Time_Table.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (11, N'Admission Entry', N'http://192.168.0.53/Student_Module/student_module/admission_committee.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (12, N'Student - Batch Allotment', N'http://192.168.0.53/Student_Module/student_module/STUDENT_BATCH.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (13, N'Student - University-Dimat ID', N'http://192.168.0.53/Student_Module/student_module/frmUniversityID.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (14, N'Generate Period', N'http://192.168.0.53/Student_Module/AccessControl/frmPrdSmry_ACS.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (15, N'Generate Shift', N'http://192.168.0.53/Student_Module/AccessControl/frmShift_setup_AS.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (16, N'HoliDay Setup', N'http://192.168.0.53/Student_Module/AccessControl/frmholiday_Setup.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (17, N'Student Leave Post', N'http://192.168.0.53/Student_Module/AccessControl/Leave_setup.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (18, N'Faculty Manual Punch', N'http://192.168.0.53/Student_Module/AccessControl/frm_Manual_Punch.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (19, N'Staff Manual Punch', N'http://192.168.0.53/Student_Module/AccessControl/frm_staff_Manual_pnch.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (20, N'Student Manual Punch', N'http://192.168.0.53/Student_Module/AccessControl/frm_Stu_Manual_pnch.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (21, N'HR Panel', N'http://192.168.0.53/Student_Module/HR_module/HR_Panel_Login.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (22, N'HR Recruitment Process', N'http://192.168.0.53/Student_Module/HR_module/Recruitment_panel.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (23, N'Employee Panel', N'http://192.168.0.53/Student_Module/HR_module/Hr_Employee_Panel.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (24, N'Course-Semester-Faculty', N'http://192.168.0.53/Student_Module/student_module/Faculty.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (25, N'Time Table Editing', N'http://192.168.0.53/Student_Module/student_module/TimeTableEditing.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (26, N'Lecture Hall', N'http://192.168.0.53/Student_Module/student_module/Desig_Hall.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (27, N'Attendance Mark', N'http://192.168.0.53/Student_Module/student_module/student_attend.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (28, N'Student List', N'http://192.168.0.53/Student_Module/student_module/Student_Report/rpt_student_admin.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (29, N'Exam Marks Entry', N'http://192.168.0.53/Student_Module/Exam_Module/EXAM_MARKS.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (30, N'Exam Attendance', N'http://192.168.0.53/Student_Module/Exam_Module/exam_attend.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (31, N'Fee Submission ', N'http://192.168.0.53/Student_Module/student_module/fee.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (32, N'Student Attendance Report', N'http://192.168.0.53/Student_Module/student_module/attend_reports/AttendeceReport.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (33, N'Faculty Attendance Report', N'http://192.168.0.53/Student_Module/AccessControl/frmFacltyAttn_ACS.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (34, N'Faculty Day Attendence', N'http://192.168.0.53/Student_Module/AccessControl/frmFacltyAttn_ACS.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (35, N'Student Attendence Report', N'http://192.168.0.53/Student_Module/AccessControl/frmSTDAttn_ACS.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (36, N'Staff Attendence Report', N'http://192.168.0.53/Student_Module/AccessControl/fr_staff.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (37, N'Faculty Punch Details', N'http://192.168.0.53/Student_Module/AccessControl/frmFacltyPnchDtl_Admin.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (38, N'Student Punch Detail', N'http://192.168.0.53/Student_Module/AccessControl/frmStuPnchDtl_Admin.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (39, N'Staff Punch Detail', N'http://192.168.0.53/Student_Module/AccessControl/frmOtherStaffPnchDtl_Admin.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (40, N'Manual Punch Report', N'http://192.168.0.53/Student_Module/HR_module/HR_Reports_UI/AprslReportMain.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (41, N'Employee Reports', N'http://192.168.0.53/Student_Module/HR_module/HR_Reports_UI/frm_HR_empdetls_RPt_UI.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (42, N'Complaint Report', N'http://192.168.0.53/Student_Module/HR_module/HR_Reports_UI/ComplaintReportMain.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (43, N'Appraisal Reports', N'http://192.168.0.53/Student_Module/HR_module/HR_Reports_UI/AprslReportMain.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (44, N'Employee FeedBack Report', N'http://192.168.0.53/Student_Module/HR_module/frm_Hr_Emp_FeedbackReport.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (45, N'Official Visit Report', N'http://192.168.0.53/Student_Module/HR_module/frm_Hr_Emp_StaffManagementReport.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (46, N'Self Evaluation Report', N'http://192.168.0.53/Student_Module/HR_module/frmEmp_SelEvaluationReports.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (47, N'Time Table Report', N'http://192.168.0.53/Student_Module/student_module/Time%20Table%20Report.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (48, N'Faculty Load Report', N'http://192.168.0.53/Student_Module/student_module/Time%20Table%20Report.aspx?fl=1', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (49, N'Class Test Result Report', N'http://192.168.0.53/Student_Module/Exam_Module/frmClassTestResultReport.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (50, N'Class Test Result Analysis Report', N'http://192.168.0.53/Student_Module/Exam_Module/frmCTMarksReport.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (51, N'Semester wise Result Analysis Report', N'http://192.168.0.53/Student_Module/Exam_Module/frmSemesterWiserResultAnalysis.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (52, N'Exam Attendance Report', N'http://192.168.0.53/Student_Module/Exam_Module/RPT_STUD_ATTEND.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (53, N'Invigilator Report', N'http://192.168.0.53/Student_Module/ReportsAS/frmDutyChartContainer.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (54, N'Class Test & Teacher Assessment Report ', N'http://192.168.0.53/Student_Module/Exam_Module/frmfullExamReports.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (55, N'Fee Collection Report', N'http://192.168.0.53/Student_Module/UnderConstruction.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (56, N'Partial Payment Report', N'http://192.168.0.53/Student_Module/UnderConstruction.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (57, N'Defaulters List', N'http://192.168.0.53/Student_Module/UnderConstruction.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (58, N'Bank Instrument Realization', N'http://192.168.0.53/Student_Module/UnderConstruction.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (59, N'Fee Receipt', N'http://192.168.0.53/Student_Module/UnderConstruction.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (60, N'Student Fee Register ', N'http://192.168.0.53/Student_Module/UnderConstruction.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (61, N'Calendar ', N'http://192.168.0.53/Student_Module/Calendar/Calendar.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (62, N'Event Entry', N'http://192.168.0.53/Student_Module/Calendar/AddEvents.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (63, N'Alumni Login', N'http://192.168.0.53/Student_Module/Alumni/Lgin.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (64, N'View Profile', N'http://192.168.0.53/Student_Module/Alumni/View_member.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (65, N'Online Exam', N'http://192.168.0.53/Student_Module/Examination/ExamSelection.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (66, N'Exam Administration', N'http://192.168.0.53/Student_Module/Examination/Admin/Index.aspx', NULL, NULL)
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (69, N'temp', N'http://192.168.0.53/Student_Module/Examination/Adm', N'temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp temp ', N'temp')
INSERT [dbo].[Help_DishaSiteMap] ([LinkId], [LinkName], [LinkURL], [description], [keywords]) VALUES (70, N'temp', N'http://192.168.0.53/Student_Module/student_module/', N'temp', N'temp')
SET IDENTITY_INSERT [dbo].[Help_DishaSiteMap] OFF
i want to make a query that will search any no of keywords.
suppose if user give anudeep and description. then it search in table, and display the result which column found the anudeep and description. and user may be give any number of parameter.
August 4, 2008 at 7:54 am
IS this the same question as this:
http://www.sqlservercentral.com/Forums/Topic546066-338-1.aspx?Update=1
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
August 4, 2008 at 8:00 am
In your above example, is description a word to be searched or does it mean search for anudeep in the description column?
THanks
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
August 4, 2008 at 8:19 am
Ok I got a solution for you!
Please not the proc requires a Tally table if you don't have one the code for it is commented out in the beginning of the proc.
CREATE PROCEDURE dbo.MyProc
(@vcSearch VARCHAR(8000))
AS
--This Procedure Requires a Tally Table
/*
--===== Create and populate the Tally table on the fly
SELECT TOP 11000 --equates to more than 30 years of dates
IDENTITY(INT,1,1) AS N
INTO dbo.Tally
FROM Master.dbo.SysColumns sc1,
Master.dbo.SysColumns sc2
--===== Add a Primary Key to maximize performance
ALTER TABLE dbo.Tally
ADD CONSTRAINT PK_Tally_N
PRIMARY KEY CLUSTERED (N) WITH FILLFACTOR = 100
--===== Allow the general public to use it
GRANT SELECT ON dbo.Tally TO PUBLIC
*/
--DELIMIT YOUR STRING TO A TABLE.
;WITH MyCTE (Search)
AS
(SELECT TOP 1000 '%' + SUBSTRING(@vcSearch+',', n,
CHARINDEX(',', @vcSearch+',', n) - n) + '%'
FROM dbo.Tally
WHERE n <= LEN(@vcSearch)
AND SUBSTRING(',' + @vcSearch,
n, 1) = ','
ORDER BY n)
--USER THE TABLE TO SEARCH YOUR TABLE
SELECT t.*
FROM [Help_DishaSiteMap] t
INNER JOIN MyCTE cte
ON [description] like cte.Search
RETURN
GO
EXEC dbo.MyProc 'anudeep,temp'
The input param to the proc is a , seperated file. so you can pass 'anudeep' or 'anudeep,temp,Chris,whateva'.
AS long you you put a comma between each search item.
This proc only searches the description column I think that is what you were looking for.
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply