Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Extract names against service
Message
De
19/09/2008 08:41:17
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Extract names against service
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Divers
Thread ID:
01348870
Message ID:
01348870
Vues:
50
Dear Experts
CREATE cursor Years (cname c(15),arrival D(8), Depart d(8))

INSERT INTO Years VALUES ('A',{^1945-07-01},{^1965-07-01}) 	&& 20 year
INSERT INTO Years VALUES ('B',{^1975-07-01},{^1977-07-01})	&& 2 year
INSERT INTO Years VALUES ('C',{^1975-07-01},{^1977-07-01})	&& 2 year
INSERT INTO Years VALUES ('D',{^1970-07-01},{^1991-07-01})	&& 21 year
INSERT INTO Years VALUES ('E',{^1981-07-01},{^1986-07-01})	&& 5 year
INSERT INTO Years VALUES ('F',{^1981-07-01},{^1986-07-01})	&& 5 year
INSERT INTO Years VALUES ('G',{^1987-07-01},{^1997-07-01})	&& 10 year
INSERT INTO Years VALUES ('H',{^1998-07-01},{^2009-07-01})	&& 11 year
INSERT INTO Years VALUES ('I',{^1940-07-01},{^1975-07-01})	&& 35 year
INSERT INTO Years VALUES ('J',{^1940-07-01},{^1980-07-01})	&& 40 year
INSERT INTO Years VALUES ('K',{^1940-07-01},{^1980-07-01})	&& 40 year
INSERT INTO Years VALUES ('L',{},{^1980-07-01})	&& 0 year
INSERT INTO Years VALUES ('M',{},{^1980-07-01})	&& 0 year
I want to extract employees whose service duration is 20 to 35 years

I need following result

cname--Years
'A'-----20
'D'-----21
'I'-----35

Please help
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform