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)