Simple Hindi Words

Mother: Maa (माँ)
Father: Baap (बाप) Pitah (पिता)
Paternal Grandfather: Dada (दादा)
Paternal Grandmother: Dadi (दादी)
Father’s (Elder) Brother: Taya (ताया)
Father’s (Elder) Brother’s Wife: Tayi (तायी)
Father’s (Younger) Brother: Chacha (चाचा)
Father’s (Younger) Brother’s Wife: Chachi (चाची)
Father’s Sister: Bua (बुआ)
Father’s Sister’s Husband: Phupha (pronounced as Fuffa) (फुफा)
Maternal Grandmother: Naani (नानी)
Maternal Grandfather: Nana (नाना)
Mother’s Brother: Mama (मामा)
Mother’s Brother’ Wife: Maami (मामी)
Mother’s Sister: Maasi (मासी)
Mother’s Sister’s Husband: Maasad ( माँसड़)
Son: Beta (बेटा)
Daughter: Beti (बेटी)
Grandson (Son’s Son): Potaa (पोता)
Grandson (Daughter’s Son): Naatii (नाती), Navasa (नवासा)
Granddaughter (Son’s Daughter): Potii (पोती)
Granddaughter (Daughter’s Daughter): Naatin (नातिन), Navaasii (न्वासी)
Sister: Behan (बहन)
Sister's Husband Jiija (जीजा)
Sister’s Son : Bhanja (भांजा)
Sister’s Daughter: Bhanji (भांजी)
Brother: Bhai (भाई)
Brother's Wife: Bhabhi (भाभी)
Brother’s Son : Bhatija (भतीजा)
Brother’s Daughter: Bhatiji (भतीजी)
Husband: Pati (पती)
Wife: Patni (पत्नी)
Wife’s/ Husband’s Mother: Saas (सास)
Wife’s/ Husband’s Father: Sasur (ससुर)
Son in Law: Damaad (दामाद)
Daughter in Law: Bahu (बहु)
Husband's (elder) Brother: Jeth (जेठ)
Husband's (elder) Brother's Wife: Jethanii (जेठानी)
Husband's Sister: Nanad (ननद)
Husband's Sister's Husband: Nandoii (ननदोइ)
Husband's (younger) Brother: Devar (देवर)
Husband's (younger) Brother's Wife: Devaraanii (देवरानी)
Wife's Sister: Saalii (साली)
Wife's Sister's Husband: Saadhuu (सांढु)
Wife’s Brother: Salaa (साला)
Wife’s Brother’s Wife: Salhaj (सैलहज)

Sample Merge SQL Query

if u dont mind can u me solution for 1 thing which i have prob
like for a string
ex:  this is a nice blog site for sql,


I want like @temp tables with 1 column
with rows like


this is
is a
a nice
nice blog
blog site
site for
for sql
sql


this is for 2 to words ……..is it possible


Solution:


Check if this helps…


declare @Sqlcmd1 varchar(100)
set @Sqlcmd1 = LTRIM(RTRIM(‘this is a nice blog site for sql ‘))
declare @Temp_Table table (Column1 varchar(100))


While len(@Sqlcmd1)>0
begin
if ( SELECT CHARINDEX(‘ ‘, @Sqlcmd1, CHARINDEX(‘ ‘, @Sqlcmd1)+1) ) > 0 -- checking for second space.
begin
insert into @Temp_Table (Column1) values (substring (@Sqlcmd1,1 , CHARINDEX(‘ ‘, @Sqlcmd1, CHARINDEX(‘ ‘, @Sqlcmd1)+1)))


select @Sqlcmd1 = (substring ( @Sqlcmd1
, (CHARINDEX(‘ ‘, @Sqlcmd1)+1)
, (len(@Sqlcmd1)- CHARINDEX(‘ ‘, @Sqlcmd1)+1)
)
)
End


Else
begin
insert into @Temp_Table (Column1) values (@Sqlcmd1)
Set @Sqlcmd1 =”
End


End
select * from @Temp_Table

Get Month and Year

DECLARE @date DATETIME;
SET @date = '2006-10-15';
SELECT DATENAME(MONTH,DATEADD(mm,-12,@date)),DATENAME(YEAR,DATEADD(mm,-12,@date)) 
UNION ALL
SELECT DATENAME(MONTH,DateAdd(mm,-11,@date)),DATENAME(YEAR,DATEADD(mm,-11,@date))
UNION ALL
SELECT DATENAME(MONTH,DATEADD(mm,-10,@date)),DATENAME(YEAR,DATEADD(mm,-10,@date)) 
UNION ALL
SELECT DATENAME(MONTH,DATEADD(mm,-09,@date)),DATENAME(YEAR,DATEADD(mm,-09,@date)) 
UNION ALL
SELECT DATENAME(MONTH,DATEADD(mm,-08,@date)),DATENAME(YEAR,DATEADD(mm,-08,@date)) 
UNION ALL
SELECT DATENAME(MONTH,DATEADD(mm,-07,@date)),DATENAME(YEAR,DATEADD(mm,-07,@date)) 
UNION ALL
SELECT DATENAME(MONTH,DATEADD(mm,-06,@date)),DATENAME(YEAR,DATEADD(mm,-06,@date)) 
UNION ALL
SELECT DATENAME(MONTH,DATEADD(mm,-05,@date)),DATENAME(YEAR,DATEADD(mm,-05,@date)) 
UNION ALL
SELECT DATENAME(MONTH,DATEADD(mm,-04,@date)),DATENAME(YEAR,DATEADD(mm,-04,@date)) 
UNION ALL
SELECT DATENAME(MONTH,DATEADD(mm,-03,@date)),DATENAME(YEAR,DATEADD(mm,-03,@date)) 
UNION ALL
SELECT DATENAME(MONTH,DATEADD(mm,-02,@date)),DATENAME(YEAR,DATEADD(mm,-02,@date)) 
UNION ALL
SELECT DATENAME(MONTH,DATEADD(mm,-01,@date)),DATENAME(YEAR,DATEADD(mm,-01,@date))

Get Day, Month, Years Separatly

WITH CTE AS
(
SELECT CONVERT(DATETIME,'01/01/2010') AS dt, 
DATENAME(dw,CONVERT(DATETIME,'01/01/2010')) AS dy,
DATENAME(mm,CONVERT(DATETIME,'01/01/2010')) AS mn, 
YEAR(CONVERT(DATETIME,'01/01/2010')) AS yr
UNION ALL
SELECT s.dt+3 AS dts, 
DATENAME(dw,dt+3) AS dy ,
DATENAME(mm,dt+3) AS dy, 
YEAR(dt+3) AS yr
FROM cte s
WHERE s.dt
)
SELECT MAX(dt) AS dt,dy,mn,yr 
FROM cte
GROUP BY dy,mn,yr
UNION
SELECT MIN(dt) AS dt,dy,mn,yr 
FROM cte
GROUP BY dy,mn,yr
ORDER BY dt
OPTION (MaxRecursion 0)

Get Dates From The Particular Day Number

DECLARE @FirstDateOfYear DATETIME
SET @FirstDateOfYear = '2010-01-01'
SELECT DISTINCT DATEADD(d, number, @FirstDateOfYear),
CASE DATEPART(dw, DATEADD(d, number, @FirstDateOfYear))
WHEN 7 THEN 'Saturday'
WHEN 1 THEN 'Sunday'
ELSE 'Work Day'
END
FROM master..spt_values
WHERE number BETWEEN 0 AND 364
AND (DATEPART(dw, DATEADD(d, number, @FirstDateOfYear)) = 1 
OR DATEPART(dw, DATEADD(d, number, @FirstDateOfYear)) = 7)
ORDER BY DATEADD(d, number, @FirstDateOfYear)

Get Dates From The Particular Daywise

DECLARE @Year AS INT,
@FirstDateOfYear DATETIME,
@LastDateOfYear DATETIME
-- You can change @year to any year you desire
SELECT @year = 2010
SELECT @FirstDateOfYear = DATEADD(yyyy, @Year - 1900, 0)
SELECT @LastDateOfYear = DATEADD(yyyy, @Year - 1900 + 1, 0)
-- Creating Query to Prepare Year Data
;WITH cte AS (
SELECT 1 AS DayID,
@FirstDateOfYear AS FromDate,
DATENAME(dw, @FirstDateOfYear) AS Dayname
UNION ALL
SELECT cte.DayID + 1 AS DayID,
DATEADD(d, 1 ,cte.FromDate),
DATENAME(dw, DATEADD(d, 1 ,cte.FromDate)) AS Dayname
FROM cte
WHERE DATEADD(d,1,cte.FromDate) < @LastDateOfYear
)
SELECT FromDate AS Date, Dayname
FROM CTE
WHERE DayName IN ('Saturday','Sunday')


--WHERE DayName IN ('Saturday,Sunday') -- For Weekend
--WHERE DayName NOT IN ('Saturday','Sunday') -- For Weekday
--WHERE DayName LIKE 'Monday' -- For Monday
--WHERE DayName LIKE 'Sunday' -- For Sunday


OPTION (MaxRecursion 370)

Attributes of a Good Tester

Here are some of the Attributes of a Good Test Engineer:

1) Good test engineer has an attitude "To achieve the Difficult".

2) Good test engineer functions with strong focus on customer’s point of view.

3) Good test engineer has a unceasing desire to achieve quality.

4) Good test engineer has an attitude to go deeper into the details of everything coming across his way.

5) Good test engineer is tactful and diplomatic in maintaining healthy & cooperative relationship with fellow developers.

6) Good test engineer has good a communication skill, both oral and written and makes good communication with technical as well as other people

7) Good test engineer has some previous experience in software development, which is helpful in providing a better understanding of the process of software development. This enables him to understand & appreciate the point of view of fellow developers which in turn becomes helpful to him in reducing his learning efforts while doing the programming during test automation.

Additional Attributes of a Good QA Engineer:

All the Above-mentioned attributes of a good test engineer are applicable to a QA engineer as well.

1) Good QA engineer is able to understand the entire process of software development as regards its concurrence with the approach & objectives of the organization.

2) Good QA engineer possesses good communication skills along with skills to act after proper understanding of all aspects of the issues coming across his way.

Additional Attributes of a Good QA Test Manager:

1) A Good QA / Test Manager is completely aware of the complexities of the process of software development.

2) A Good QA / Test Manager has an ability to infuse enthusiasm among his team and is able to inculcate a positive & healthy atmosphere.

3) A Good QA / Test Manager has an ability to enhance productivity of his team by promoting a sense of teamwork.

4) A Good QA / Test Manager has an ability to develop an atmosphere of cooperation among his team of Software Test / QA Engineers.

5) A Good QA / Test Manager possesses adequate technical skills of doing improvements in testing & QA processes.

6) A Good QA / Test Manager has the ability to withstand varied type of stresses & strains related to his operations and has courage to say *NO* to fellow colleagues in the event quality is found to be inadequate or there is some sort of failure in maintaining the desired QA processes.

7) A Good QA / Test Manager has good ability to exchange effective communication both with technical as well as commercial personnel.

8) A Good QA / Test Manager has good ability to chair the project meetings and an ability to maintain the focus of such meetings without any digression.