LDC & Stenographer Recruitment 2017 in Rajasthan High Court (Rajasthan Subordinate Courts Ministerial Establishment Rules, 1986)

Rajasthan High Court, Jodhpur invites online/offline applications for following posts -
 

Name of Post	Vacancy	Pay-scale
Lower Division Clerk	1726	5200-20200 (Grade Pay - 2400)
Stenographer & Stenographer Grade-II	313	9300-34800 (Grade Pay - 3600)

Educational Qualifications

Name of Post	Educational Qualification
Lower Division Clerk	A candidate for direct recruitment to the post of Stenographers/Stenographers Grade-II must have passed the Senior  Secondary Examination in Arts or Science or Commerce of the Rajasthan Board of Secondary Education or an Examination equivalent thereto recognized by the Government or any Higher Examination and must possess a good working knowledge of Hindi as written in Devanagri script & of Rajasthani Dialects and must have passed - "O" or Higher Level Certificate Course conducted by DOEACC under control of the Department of Electronics, Government of India; or Computer Operator & Programming Assistant (COPA)/Data Preparation & Computer Software (DPCS) certificate organized under National/State council of Vocational Training Scheme; or Diploma in Computer Science/ Computer Applications from any university established by Law in India or from an institution recognized by the Government; or Diploma in Computer Science & Engineering from a Polytechnic Institution recognized by the Government; or Rajasthan State Certificate Course in Information Technology (RSCIT) Conducted by Vardhaman Mahaveer Open University, Kota under control of Rajasthan Knowledge Corporation Limited; or Senior Secondary School Examination with Computer Science as an optional subject; or Any equivalent or higher qualification.
Stenographer & Stenographer Grade-II	A candidate for direct recruitment to the Lower Divisional Clerk must have passed the Senior Secondary Examination of the Rajasthan Board of Secondary Education or any Examination of University or Board recognized as equivalent thereto by the Government, or any higher examination, and must in addition possess a good knowledge of Hindi written in Devnagri script and must have passed:- "O" or Higher Level Certificate course conducted by DOEACC under control of the Department of Electronics, Government of India; Or Computer Operator & Programming Assistant (COPA)/Data preparation and Computer Software (DPCS) Certificate organized under National/State Council of Vocational Training Scheme; Or Diploma in Computer Science/Computer Applications from a University established by law in India or from an Institution recognized by the Government, Or Diploma in Computer Science & Engineering from a polytechnic institution recognized by the Governement; Or Rajatshan State Certificate Course in Information Technology (RSCIT) Conducted by Vardhaman Mahaveer Open University, Kota under control of Rajasthan Knowledge Corporation Limited; Or Senior Secondary school examination with computer science as an optional subject; Or Any equivalent or higher qualification.

Application Fee

General	OBC/SBC	SC/ST/Widow/ Divorced female/PWD
100	100	25

For more details visit : http://hcraj.nic.in/recruitment.aspx

RECRUITMENT 2017 IN JAIPUR METRO RAIL CORPORATION LIMITED

Jaipur Metro Rail Corporation Ltd. (JMRC), a Government of Rajasthan Undertaking, registered under the Companies Act, 1956, is implementing Metro Rail Transit System in Jaipur operations of its first line in June, 2015.

The recruitment is being undertaken under the provisions of the JMRC Recruitment Rules, 2012, hereinafter referred to as ‘the Rules’, JMRC websites: www.jaipurmetrorail.in http://transport.rajasthan.gov.in/jmrc portal, i.e., www.jmrcrecruitment.in. This manpower is being recruited against the vacant posts in JMRC and given the transitory nature of the mode of project operations & maintenance, the nature of service is temporary, as explained in the Rules, especially Preamble thereof.  

S. No.	Name of Post	Total number of vacant posts	General (Open Competition)		Scheduled Castes		Scheduled Tribes		Other Backward Classes		Horizontal Reservation
			General	Woman	General	Woman	General	Woman	General	Woman	Ex-service man
1	Station Controller/ Train Operator	16	6	2	2	0	3	0	3	0	2
2	Junior Engineer (Civil)	6	3	0	1	0	1	0	1	0	0
3	Junior Engineer (Electronics)	1	0	0	0	0	1	0	0	0	0
4	Junior Engineer (Mechanical)	1	1	0	0	0	0	0	0	0	0
5	Junior Engineer (Electrical)	4	3	1	0	0	0	0	0	0	0
6	Junior Accountant	1	1	0	0	0	0	0	0	0	0
7	Customer Relations Assistant	6	2	0	1	0	1#	0	2	0	0
8	Maintainer (Fitter)	4	3	0	0	0	0	0	1	0	0
9	Maintainer (Electronics)	6	4	1	0	0	1	0	0	0	0
Total		45	23	4	4	0	7	0	7	0	2

# One post of Customer Relations Assistant in ST category is tentative and subject to outcome of court case or availability of vacancy in ST category at the time of final result. 

• The online application window shall open from 22nd February 2017 and the last date for submission of online applications is 31st March 2017.
• Please read the abridged advertisement, detailed advertisement and “How to fill Application form” along with other information available on this portal before registration and filling of application form.
• The number of vacancies indicated above are provisional and subject to increase /decrease as per requirement of JMRC.
• Corrigendum/addendum to this advertisement, if any, shall be published only on JMRC website / this recruitment portal.
• In case of any query, JMRC may be contacted on careers@jaipurmetrorail.in

  #Jaipur Metro Vacancy 2017, #Rajasthan Govt Vacancy

MS SQL Server Scalar Valued Function for Difference Between Two Dates

-- =============================================
-- Author: <Author,,Kapil Dev Mehra>
-- Create date: <Create Date, ,30/12/2016>
-- Description: <Description, ,Get difference between two dates>
-- =============================================
CREATE FUNCTION [dbo].[funGetDiffDates]
(
@NewDate nvarchar(10),
@OldDate nvarchar(10)
)
RETURNS nvarchar(50)
AS
BEGIN
DECLARE @Diff_Day int, @Diff_Month int, @Diff_Year int
DECLARE @OldDate_Day int, @OldDate_Month int, @OldDate_Year int
DECLARE @NewDate_Day int, @NewDate_Month int, @NewDate_Year int
SELECT @OldDate_Day = SUBSTRING(@OldDate,1,2), @OldDate_Month = SUBSTRING(@OldDate,4,2), @OldDate_Year = SUBSTRING(@OldDate,7,4)
SELECT @NewDate_Day = SUBSTRING(@NewDate,1,2), @NewDate_Month = SUBSTRING(@NewDate,4,2), @NewDate_Year = SUBSTRING(@NewDate,7,4)

IF @OldDate_Day > @NewDate_Day
BEGIN
SET @NewDate_Month = @NewDate_Month - 1
SET @NewDate_Day = @NewDate_Day + 30

END
SET @Diff_Day = @NewDate_Day - @OldDate_Day

IF @OldDate_Month > @NewDate_Month
BEGIN
SET @NewDate_Year = @NewDate_Year - 1
SET @NewDate_Month = @NewDate_Month + 12
END
SET @Diff_Month = @NewDate_Month - @OldDate_Month
SET @Diff_Year = @NewDate_Year - @OldDate_Year

DECLARE @Return_Year nvarchar(15), @Return_Month nvarchar(15), @Return_Day nvarchar(15)
IF @Diff_Year > 1
SET @Return_Year = CONVERT(nvarchar, @Diff_Year) + ' Years, '
ELSE
SET @Return_Year = CONVERT(nvarchar, @Diff_Year) + ' Year, '

IF @Diff_Month > 1
SET @Return_Month = CONVERT(nvarchar, @Diff_Month) + ' Months, '
ELSE
SET @Return_Month = CONVERT(nvarchar, @Diff_Month) + ' Month, '

IF @Diff_Day > 1
SET @Return_Day = CONVERT(nvarchar, @Diff_Day) + ' Days'
ELSE
SET @Return_Day = CONVERT(nvarchar, @Diff_Day) + ' Day'

RETURN @Return_Year + @Return_Month + @Return_Day
END


#how to difference between two dates in sql
#how to calculate age by date of birth
#how to get age from date of birth in sql