Free PDF Downlad & USA Help website
Posted in Free PDF Download Web Site
Pivot Point
Invention
- Cinema invent by lumir brother (Theater)
- Post and Telephone Service Started at 1854
- Television Invented by J.L.Beard
Posted in Invention
Special Message
Key words
AJAX – Asynchronous Java Script
OCX – Ole Control ExtensionDBCC – Database Console Commands
Normalization is a process of organizing the tables in a database into efficient,
logical structures in order to eliminate redundant data and increase integrity.
NSA – National Security Administration
TCSEC – Trusted Computer System Evaluation Criteria
PHP – (Personal Home Page) which use for developing web page.
RDC – (Report Designer Component)
DTS – Data Transformation Services
RAID – Redundant Array of Independent (or Inexpensive) Disks. A category of disk drives that employ two or more drives in combination for fault tolerance and performance. RAID disk drives are used frequently on servers but aren’t generally necessary for personal computers.
RAID (Redundant Array of Independent Disks) is a way of storing the same data in different places (thus, redundantly) on multiple hard disks.
Posted in Key Words
MS Sql Help
TSQL: Concatenate strings from a column into a single row?
The following article is taken from this link:
http://www.aspfaq.com/show.asp?id=2529
This question is asked quite frequently. People want to take a column like this:
Color
——
red
orange
blue
green
And return a resultset like this:
Colors
————————-
red,orange,blue,green
This isn’t exactly relational, and can certainly be handled by the presentation layer. However, there are kludges in SQL Server that will allow you to derive a solution. We’ll start with the simple case above:
CREATE TABLE Colors
(
Color VARCHAR(32)
)
GO
SET NOCOUNT ON
INSERT Colors SELECT ‘red’
INSERT Colors SELECT ‘orange’
INSERT Colors SELECT ‘blue’
INSERT Colors SELECT ‘green’
GO
DECLARE @colors VARCHAR(1024)
SELECT
@colors = COALESCE(@colors + ‘,’, ”) + Color
FROM
Colors
SELECT Colors = @colors
GO
DROP TABLE Colors
GO
(Note that you can add an ORDER BY clause to the SELECT, but this will not necessarily be obeyed… the resulting list will be displayed in an arbitrary order.)
Now, that’s great if you’re only concerned with getting one list back. But let’s say we have a table of athlete names, events and results. For each athlete, we want a row containing the full name and a comma-separated list of events they medaled in. In this case, we’ll use a user-defined function to handle the concatenation for us, and a subquery to limit the output to one row per name.
CREATE TABLE dbo.Medals
(
FullName VARCHAR(32),
Result VARCHAR(12),
Event VARCHAR(32),
PRIMARY KEY (Fullname, Event)
)
GO
CREATE FUNCTION dbo.GetMedalResult
(
@fullName VARCHAR(32)
)
RETURNS VARCHAR(8000)
AS
BEGIN
DECLARE @r VARCHAR(8000)
SELECT @r = ISNULL(@r+’,', ”)
+ Result + ‘ in ‘ + Event
FROM dbo.Medals
WHERE FullName = @fullName
RETURN @r
END
GO
SET NOCOUNT ON
INSERT Medals SELECT ‘Marie-Helene Premont’, ‘Silver’, ‘Mountain Biking’
INSERT Medals SELECT ‘Adam van Koeverden’, ‘Bronze’, ‘K-1 1,000M Kayak’
INSERT Medals SELECT ‘Kyle Shewfelt’, ‘Gold’, ‘Gymnastics Floor Exercise’
INSERT Medals SELECT ‘Alexandre Despatie’, ‘Silver’, ‘3-Meter Springboard’
INSERT Medals SELECT ‘Michael Phelps’, ‘Gold’, ‘400M Medley’
INSERT Medals SELECT ‘Michael Phelps’, ‘Gold’, ‘200M Medley’
INSERT Medals SELECT ‘Michael Phelps’, ‘Gold’, ‘200M Butterfly’
INSERT Medals SELECT ‘Michael Phelps’, ‘Gold’, ‘100M Butterfly’
INSERT Medals SELECT ‘Michael Phelps’, ‘Gold’, ‘4×200M Freestyle Relay’
INSERT Medals SELECT ‘Michael Phelps’, ‘Bronze’, ‘200M Freestyle’
INSERT Medals SELECT ‘Michael Phelps’, ‘Bronze’, ‘4×100M Freestyle Relay’
GO
SELECT
Fullname,
dbo.getMedalResult(Fullname)
FROM
(
SELECT
Fullname
FROM
Medals
GROUP BY
Fullname
) i
GO
DROP TABLE Medals
DROP FUNCTION dbo.getMedalResult
GO
Again, you will not be able to dictate the ordering of the result in each row; this will be decided by the optimizer at runtime, and will not necessarily stay consistent between executions.
SQL Server 2005 adds some interesting options for this kind of non-relational query. You should be able to have more granular control over concatenation with user-defined aggregates, and you can also take advantage of the new FOR XML PATH (except that for a true comma-delimited list, you have to do a lot of ugly replaces either in the query or in the application/presentation layer):
USE AdventureWorks
GO
SELECT
CustomerID,
SalesOrderIDs = REPLACE
(
REPLACE(
REPLACE(
(
SELECT
SalesOrderID AS [data()]
FROM
Sales.SalesOrderHeader soh
WHERE
soh.CustomerID = c.CustomerID
ORDER BY
SalesOrderID
FOR XML PATH (‘o’)
),
‘</o><o>’,',’),
‘<o>’,SPACE(0)),
‘</o>’,SPACE(0)
)
FROM
Sales.Customer c
ORDER BY
CustomerID
Another way is to use the new CROSS APPLY operator:
USE AdventureWorks
GO
SELECT
CustomerID,
SalesOrderIDs = LEFT(o.list, LEN(o.list)-1)
FROM
Sales.Customer c
CROSS APPLY
(
SELECT
CONVERT(VARCHAR(12), SalesOrderID) + ‘,’ AS [text()]
FROM
Sales.SalesOrderHeader s
WHERE
s.CustomerID = c.CustomerID
ORDER BY
SalesOrderID
FOR XML PATH(”)
) o (list)
ORDER BY
CustomerID
MsSql String Comparision with Case Sensitive
If you want to compare two string in Ms Sql with case sensitivity.
Select Fields Names from Table Name Where cast(Password as varbinary(30)) = cast(@Password AS varbinary(30)) Select Fields Names from Table Name Where cast(Password as varbinary(30))= cast(“Madhav” as varbinary(30))
Remove Duplicate Row From Table
Select distinct * into #holding from Table Name
Truncate Table Table Name
Insert Table Name select * from #holding
Drop table #holding
ORACLE -
delete from table1 t1 where t1.rowid < (select max(t2.rowid) from schema.table1 t2 where t1.fcn = t2.fcn); keep just the latest rows If > then old rows
Finding N no of Row from Table
Select top 1 * from table where [fields] not in (Select top n-1 [fields] from table order by field desc) order by field desc.
Select * from Employee A where 1 = (select count(*) from Employee B where A.EmpId < B.EmpId) Find 5th Highest Salary from Employee
Select salary from Employee where salary not in (select top 4 salary from Employee order by salary desc) order by salary desc.
Normalization is a process that eliminates redundancy, organizes data efficiently, reduces the potential for anomalies during data operations and improves data consistency.
First normal form (1NF): Ensure that each table has a primary key: an attribute or combination of attributes whose values are guaranteed to be different for every record of the table.
Eliminate repeating groups (categories of data which would seem to be required a different number of times on different records) by defining key and non-key attributes appropriately.
Second normal form (2NF) requires that data stored in a table with a composite primary key must not be dependent on only part of the table’s primary key:
The database must meet all the requirements of the first normal form.
Data, which is redundantly duplicated across multiple rows of a table, is moved out to a separate table.
Third normal form (3NF) requires that data stored in a table be dependent only on the primary key, and not on any other field in the table.
The database must meet all the requirements of the second normal form.
Any field, which is dependent not only on the primary key but also on another field, is moved out to a separate table.
Boyce-Codd normal form (or BCNF) requires that there be no non-trivial functional dependencies of attributes on something other than a superset of a candidate key
Fourth normal form (or 4NF) requires that there be no non-trivial multivalued dependencies of attribute sets on something other than a superset of a candidate key. A table is said to be in 4NF if and only if it is in the BCNF and multivalued dependencies are functional dependencies. The 4NF removes unwanted data structures: multivalued dependencies.
Fifth normal form (5NF and also PJ/NF) requires that there are no non-trivial join dependencies that do not follow from the key constraints. A table is said to be in the 5NF if and only if it is in 4NF and every join dependency in it is implied by the candidate keys.
This normal form was, as of 2005, only recently proposed: the sixth normal form (6NF) was only defined when extending the relational model to take into account the temporal dimension. Unfortunately, most current SQL technologies as of 2005 do not take into account this work, and most temporal extensions to SQL are not relational.
Posted in Software Developer
Compound Interest
P is the principal (the initial amount you borrow or deposit)
r is the annual rate of interest (percentage)
n is the number of years the amount is deposited or borrowed for.
A is the amount of money accumulated after n years, including interest.
When the interest is compounded once a year:
A = P(1 + r)n
However, if you borrow for 5 years the formula will look like:
A = P(1 + r)5
This formula applies to both money invested and money borrowed.
Frequent Compounding of Interest:
What if interest is paid more frequently?
Here are a few examples of the formula:
Annually = P × (1 + r) = (annual compounding)
Quarterly = P (1 + r/4)4 = (quarterly compounding)
Monthly = P (1 + r/12)12 = (monthly compounding)
If $4000 is invested at an annual rate of 6.0% compounded monthly, what will be the final value of the investment after 10 years?
Since the interest is compounded monthly, there are 12 periods per year, so, k = 12.
Since the investment is for 10 years, or 120 months, there are 120 investment periods, so, n = 120.
S = P(1 + r/k)n
S = 4000(1 + 0.06/12)120
S = 4000(1.005)120
S = 4000(1.819396734)
S = $7277.59
Posted in Compound Interest
Travels Phoneno
Travle List of Mumbai
Suvidha Travel (Andheri East) – 26830860,26828849,55830860,55832249
Neeta Travel 022-28902666
—————————————————————————
Travel List of Bhavnagar
Rajdhani Tavel 0278-2432535
Maya Tavel 0278-2425217
Sherrnathjee Tavel 0278-2427755
Madhuli Tavel 0278-2200519
Shiv-Eagal Tavel 0278-2424444
Tanna Tavel 0278-2425218
Limda Tavel 0278-2427409
Gujrat 0278-2430786
—————————————————————————
Mumbai(BCT) Vadodara(BRC)
Trai No. Train Name (Night) Dep Time Arrival Time
2927 Vadodara Express 23:55 6:20
9019 Dehradun Express (Bdts) 22:25 6:00
9037 Avadh Express (Bdts) 22:40 5:15
9039 Avadh Express (Bdts) 22:40 5:15
2901 Gujarat Mail 21:50 4:30
1096 Ahinsa Exp (F,S,S) (Kalyan) 22:15 6:30
241B Ahmedabad Passenger 22:40 10:30
9271 Bhavnagar Express 21:20 * 11:40(Bhavnagar)
9017 Sau Janata Express 16:35 8.00 rajkot Day Train
2933 Karnavati Express 13:40 19:34
9011 Gujarat Express 5:45 13:07
9023 Firozpur Janata Express 7:25 16:17
9115 Bandra bhuj Express (Bdts)14:50 21:30
RETURN JOURNEY Vadodara (BRC) Mumbai (BCT)
2928 Vadodara Express 22:45 5:25
2904 Golden Temple 23:38 6:05
2902 Gujarat Mail 0:07 7:00
2962 Avantika Express 0:12 6:50
9006 Saurashtra Mail 0:47 8:10
9144 Lokshakti Express 23:14 6:30
9272 Bhavnagar Express from bhavnagar 18:25 10:07
9038 Avadh Exp (Tu,Th,Sat,Sun) 2:24 7:12 Day Train
2934 Karnavati Express 6:50 12:50
9012 Gujarat Express 9:08 16:40
9116 Bhuj Bandra Express 7:10 13:16 Bandra
9018 Sau Janta Exp from Rajkot 15.25 virar 4.25
—————————————————————————–
Posted in Travel Phoneno
Shayri
Hum vo nahi jo tuje gam me chod dege…
Hum vo nahi jo tujase nata tod dege…
Hum to tere vo dosto hai jo agar teri…
Saas bandh jo ja ye to apani saas jod dege…
2 Love is a duty.
2 b loved is a success.
2 b with someone u love is an achievement.
but 2 b with someone who love u is life.
vaade pe vo mere aitbaar nahi karate.
hum zikare muhobat sare bazar nahi karate.
darata hai dil unki ruswai se.
aur vo sochate hai hum unase pyar nahi karate.
dosti gazal hai gun guna ne ke liye.
dosti nazam hai sunane ke liye.
yah vo zasba hai jo sabako milata hai.
kyu ki hosala chahiye dosti nibhane ke liye.
rang ni pichi vagar tasvir banavi lidhi. —–(Gujarati Gazal)
jigar ma vasavi ne zindagi sajavi lidhi.
tamane puchava no samay pan na rahyo.
muhobat ni ame duniya vasavi lidhi.
tej dhakan ko sunkar bhi
tume pyar ki khabar nahi hoti.
kya mahasus karoge tum dil ka dard
dil ke tutane ki aavaz bhi nahi hoti
unaki yaad me sabkuch bhula baithe hai.
chirag khusiyo ke buza baithe hai.
hum to marege unki baho me.
ye bhi muat se sart laga baithe hai.
pane se kone ka maza kuch aur hai.
bandh aankho se dekh ne ka maza kuch aur hai.
aasu bane lafaz aur lafaz bane gazal.
yaado ke saath zine ka maza kuch aur hai.
Jo hud se na guzar ja ye wo pyar hi kya.
jo pyar karane pe mazboor na karade vo ikrar hi kya.
intazar to sab kiya karate hai saas tutane tak.
Jo saath na de vo yaar hi kya.
Ruthna mat hume manana ni aataa…
Dur mat jana hume bulana nahi aataa…
Aap bhul jao aapki marzii…
Magar hum kya karein?
Hume toh bhulana bhi nahi aata…..
Muskurao aap to kali khil jaye,
baatein karo to dil machal jaye.
Itni dilkash hai aapki dosti,
Dost to kya dushman bhi aap par fida ho jaaye…
Chand agar roshan hai to roshni tum ho,
Phool agar khusbodar hain to kushboo tum ho,
Barf agar thandi hai to thandak tum ho,
Hum agar zinda hain to zindagi tum ho…..
Khuda se mainey aik dua mangi,
Dua main apni maut maingi,
Phir khuda nai mujh se kaha,
Maut to tujhey main dein doo,
Par use kya kaho jis ney teri lambi umar mangi…
Aasman humse naraaz hai
Taaron ka gussa behisaab hai
Woh sab hamse jalte hain, kyon ki
Chand se behtar dost hamare pass hai……
Tanha ho to kabhi mujh ko mat dhundhna
Duniya se nahi apne dil se puchhna
Aaspas hi kahin base rahti hai
Yadon se nahi saath gujare lamho se puchhna
Hasne ke bad kyun rulati hai ye duneya ?
Jane ke bad kyun bulati hai ye duniya ?
Zindgi mein kya kasar baki thi jo
Marne ke baad jalati hai ye duniya.
Chahat ki baahein faila kar to dekho
Mohabbat ki shama jala kar to dekho
Tumhe na hojaye pyar to kehdena
Zara humse nazrein mila kar to dekho
Woh mulakaat kuch adhuri si lagi..
Paas hokar bhi duri si lagi…
Honto pe hansi, aankho mein nami
Pehli baar kisi ki dosti…
Saanso jitni zaruri si lagi..
Jeeti her bazi to masroor hoo gaeay
aap seay mileay to aansooun ham seay doour hoo gaeay
Bas sirf aik ap ki dosti ki badooulat lagta hei
Ke ham KANCH seay KOH-E-NOR hoo gaeay…
Unse hum pyaar is tarah karte hai,
Kuch keh kar bhi kuch keh nahi paate.
Mohhabat ko dosti ka karar dete hai,
Kyu ki unhe hum khone nahi chahte he……
Zindgi ho tum humari to tum ko hum bhula nahi sakte,
Dil tumhara is dil se juda kar nahi sakte,
Duniya main pyaar to sabhi karte hai per,
Nibhane ke liye dil kisi ka tod nahi sakte.
Royegi aakhe muskurane ke baad,
Aayegi raat din dhaljane ke baad,
Ohh janewale zara mud ke dekh,
Shayad yeh ZINDAGI hi na rahe tere jaane ke baad……….
Sawar vagar ni ek raat mangu chu,
Sitara saathe ni varsat mangu chu,
Na hoi ant jeno pralay sudhi……..
Bus evi ek mulakat maangu chu?
Ek jaam ulfat ke naam,
Ek jaam mohabat ke naam,
Ek jaam wafa k naam,
Puri botal bewafa ke naam,
Aur pura theka doston ke naam.
Ab umar ho gayi hai dil ki kitaab mein,
Kuch khusk paton ke siva kuch nahin raha,
Zazbaat tamaam kho gaye lamhon ki dhool mein,
Ab dil mein dhadkano ke siva kuch nahi raha.Log kahtey hain ki ladkiyan zindagi hoti hain maut nahi,
Magar voh kya jane ki dhoka bhi zindagi deti hai maut nahi WAH..WAH.. WAH..WAH….
Sitaron se aage jahan aur bhi hein,
Abhi Mohabbat ke imtihan aur bhi hein,
Tum hi nahi jalatey mere dil ko,
Duniya mein Ladkiyan aur bhi hein.
Ye Barish Jara Sambhalke Baras Mera Yaar Ane Vala Hai,
Itana Bhi Nahi Baras Woh Aana Sake,
Aur Ane Ke Bad Itana Baras Badme Woh Jana Sake.
Dur Humse Jaa Paoge Kaise,
Humko Bhool Paoge Kaise,
Hum Who Khushbu Jo Saanson Mein Utar Jaye,
Khud Apni Saanson Ko Rok Paoge Kaise..
Bekhudi Ki Zindagi Hum Jiya Nahi Karte,
Yun kisi ka Jaam Hum Piya Nahi Karte,
Unse Kehdo Mohabbat Ka Izhaar Aakar Khud Karein,
Yun Kisika Peecha Hum Nahin Karte.
Rone De Tu Aaj Hamako Tu Aankhe Sujane De,
Baho Me Lele Aur Khud Ko Bheeg Jane De,
Hai Jo Seene Me Quaid Dariya Wo Chut Jayega,
Hai Itana Dard Ki Tera Daman Bheeg Jayega..
Aaj hum unhe bewafa batakar aaye hain,
Unke khaton ko pani mein bahakar aaye hai,
Koi nikaal kar padh na le unhe,
Isliye paani mein bhi aag lagakar aaye hain……
Log apna bana kar chod dete hai,
Rishtay gairo ke sath jod lete hain,
Hum to ek phool bhi na tod paye,
Na jane log kaise dilo ko tod dete hai…
Main lafzon se kuch bhi izhaar nahi karta,
Iska matlab ye nahi ki main pyar nahi karta,
Chahta hu main Use aaj bhi per,
Uski soch main waqt bekar nahi karta,
Tamasha na ban jaye yeh mohabbat meri,
Isliye apne dard ka izhaar nahi karta,
Jo kuch mila hai usi me kush hu main,
Uske liye khuda se takrar nahi karta,
Par kuch to baat hai uski fitrat main aye zalim,
Warna use chahne ki khata baar-baar nahi karta.
Ek kami thi taj mahal me
Ham ne teri tasvir laga di
Apne Chehare se jo jahil ho use chupaye kaise,
Tu jis tarah chahe ham najar aaye kaise,
Ghar Sajane ka tasavur bohat baad ka hai,
Phale ye soche ye Ghar bachaye kaise.
Bheeg jati hai palkein Uski yadon me,
Darte hai koi jaan na le,
Pasand karte hai Tez Barsaat me chalna,
kahin rote huye koi hume pehchaan na le.
Gum ki ahat bhi na aye tere dar per,
Pyar ke samandar ka tu bhi kinara ho,
Kabhi bhul se jo tapke teri ankh se Moti,
Thame wahi jo tujhe sabse pyara ho.
Posted in Shayri