[Busmanagers] Exporting Data using Work Sheets

[Payne, Debbie R]

Hello

Here is some SQL for eldest in family.

 

Eldest in family

 

SELECT ST.SURNAME,ST.FIRST_NAME,ST.STATUS,ST.FAM_ORDER,DF.NO_STUDENTS

FROM (ST INNER JOIN DF ON ST.FAMILY = DF.DFKEY) INNER JOIN UM ON
UM.UMKEY = DF.MAILKEY

WHERE (STATUS  = 'ACTV') AND  (FAM_ORDER  =1)

ORDER BY ST.SURNAME ASC,ST.FIRST_NAME ASC

 

 

Eldest in family with homegroup

 

SELECT
ST.SURNAME,ST.FIRST_NAME,ST.STATUS,ST.FAM_ORDER,DF.NO_STUDENTS,ST.HOME_G
ROUP

FROM (ST INNER JOIN DF ON ST.FAMILY = DF.DFKEY) INNER JOIN UM ON
UM.UMKEY = DF.MAILKEY

WHERE (STATUS  = 'ACTV') AND  (FAM_ORDER  = 1)

ORDER BY ST.SURNAME ASC,ST.FIRST_NAME ASC

 

 

Debbie Payne

Business Manager

Dorset Primary School

 

________________________________

From: busmanagers-bounces at edulists.com.au
[mailto:busmanagers-bounces at edulists.com.au] On Behalf Of Tewkesbury,
Beverley D
Sent: Tuesday, 17 July 2007 1:38 PM
To: Business Managers' Mailing List
Subject: [Busmanagers] Exporting Data using Work Sheets

 

 

 

Good Afternoon EMR Business Managers,

 

I have been asked to send this on behalf of my colleague in the Office:-

 

On behalf of myself Gill Lee, and Lilydale Heights College I have a
question re exporting data using Work Sheets.

 

I wish to export:

 

STKEY

SURNAME

PREF_NAME

HOME_GROUP

 

for the YOUNGEST/OLDEST STUDENTS IN A FAMILY ONLY????????????

 

Can anyone help please? 

I have exported using the DFKEY and deleted the data I did not need
however a little time consuming overall.

Which Table has this data reference? 

What is it called? 

Can anyone copy and send me their Work Sheet Stored SQL Statement that
works?

 

THANK YOU ALL VERY MUCH

 

Regards
Gill Lee
SSO Admin
Lilydale Heights College M T T 

e: lee.gillian.l at edumail.vic.gov.au

 

 

This is to enable us to send Newsletters to the youngest member of
families only.

 

If anyone has any suggestions they would be appreciated.

 

 

Bev Tewkesbury

Business Manager

Lilydale Heights College

email: tewkesbury.beverley.d at edumail.vic.gov.au
<mailto:tewkesbury.beverley.d at edumail.vic.gov.au> 

Phone:  9735 7004

Fax:      9739 5463

 

 

Important - This email and any attachments may be confidential. If
received in error, please contact us and delete all copies. Before
opening or using attachments check them for viruses and defects.
Regardless of any loss, damage or consequence, whether caused by the
negligence of the sender or not, resulting directly or indirectly from
the use of any attached files our liability is limited to resupplying
any affected attachments. Any representations or opinions expressed are
those of the individual sender, and not necessarily those of the
Department of Education.


Important - This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/busmanagers/attachments/20070717/0274c622/attachment-0001.html