just show me the result fetched by thy sql
Hi Diwakar,
The query returns about 1480 rows of 20 columns each, and it takes 51 seconds to give the results, I'm pasting only the first 50 rows here as there is a restriction of max. 10000 characters.
40 AAAN0001L Charles Dawson Graham Beck Authorised 24/08/2005 NULL 1_1/1 1 1 1 1 1 1 1 Authorised on 24/08/2005 1 NULL NULL 1
40 AARE0002L Ruediger Zastrow Werner Zoeller Not yet issued NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Not yet issued 0 NULL NULL 1
50 AARE0003L Ruediger Zastrow Ruediger Zastrow Not applicable NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Not applicable 0 NULL NULL 8
80 AARE0004L Ruediger Zastrow Ulfert Gartz Not applicable NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Not applicable 1 NULL NULL 7
80 AARE0005L Ruediger Zastrow Ulfert Gartz Not applicable NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Not applicable 1 NULL NULL 7
80 AARE0006L Ruediger Zastrow Ulfert Gartz Not applicable NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Not applicable 1 NULL NULL 7
80 AARE0007L Ruediger Zastrow Ulfert Gartz Not applicable NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Not applicable 1 NULL NULL 7
40 AARE0008L Ruediger Zastrow Ulfert Gartz Issued, with Ulfert Gartz for completion 05/07/2005 NULL NULL NULL NULL NULL NULL NULL NULL NULL Issued on 05/07/2005, with Ulfert Gartz for completion 1 NULL NULL 1
80 ABB-0184L Bernie Robertson Bernie Robertson RAF archived / Authorised NULL NULL 1_1/1 1 1 1 1 1 1 NULL RAF archived / Authorised On 23/03/2004 0 NULL NULL 7
50 ABB-0196L Alan Davies David Vasak Not applicable NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Not applicable 1 NULL NULL 8
40 ABNB0122L Mike Hunter Richard Harrison Not yet issued NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Not yet issued 1 NULL NULL 1
80 ABNB0126L Mike Hunter Richard Harrison Not applicable NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Not applicable 1 NULL NULL 7
40 ABNB0130L Mike Hunter Richard Harrison NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 1 NULL NULL 1
40 ABNB0132L Mike Hunter Richard Harrison Not yet issued NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Not yet issued 1 NULL NULL 1
80 ABNB0141L Fons Kuijpers Richard Harrison Not applicable NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Not applicable 1 NULL NULL 7
40 ABNB0142L Fons Kuijpers Richard Harrison Not yet issued NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Not yet issued 0 NULL NULL 1
80 ABNB0144L Fons Kuijpers Richard Harrison Not applicable NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Not applicable 1 NULL NULL 7
40 ABNB0148L Fons Kuijpers Richard Harrison Authorised 27/11/2003 NULL 1_2/1 2 1 1 1 1 1 NULL Authorised on 27/11/2003 0 NULL NULL 1
40 ABNB0149L Fons Kuijpers Richard Harrison Authorised 27/11/2003 NULL 1_1/1 1 1 1 1 1 1 NULL Authorised on 27/11/2003 0 NULL NULL 1
40 ABNB0151L Fons Kuijpers Richard Harrison Authorised 30/09/2003 NULL 1_1/1 1 1 1 1 1 1 NULL Authorised on 30/09/2003 0 NULL NULL 1
40 ABNB0152L Fons Kuijpers Richard Harrison Authorised 30/09/2003 NULL 1_1/1 1 1 1 1 1 1 NULL Authorised on 30/09/2003 1 NULL NULL 1
40 ABNB0157L Fons Kuijpers Richard Harrison Authorised 16/02/2004 NULL 1_1/1 1 1 1 1 1 1 NULL Authorised on 16/02/2004 0 NULL NULL 1
40 ABNB0158L Fons Kuijpers Richard Harrison Authorised 16/02/2004 NULL 1_1/1 1 1 1 1 1 1 NULL Authorised on 16/02/2004 0 NULL NULL 1
40 ABNB0159L Fons Kuijpers Richard Harrison Authorised 16/02/2004 NULL 1_1/1 1 1 1 1 1 1 NULL Authorised on 16/02/2004 0 NULL NULL 1
80 ABNB0161L Fons Kuijpers Richard Harrison RAF archived NULL NULL 1_1/1 1 1 1 1 1 1 NULL RAF archived On 25/05/2004 0 NULL NULL 7
40 ABNB0163L Fons Kuijpers Richard Harrison Authorised 26/03/2004 NULL 1_1/1 1 1 1 1 1 1 NULL Authorised on 26/03/2004 0 NULL NULL 1
40 ABNB0165L Fons Kuijpers Richard Harrison Authorised 26/04/2004 NULL 1_1/1 1 1 1 1 1 1 NULL Authorised on 26/04/2004 0 NULL NULL 1
40 ABNB0166L Fons Kuijpers Richard Harrison Authorised 26/04/2004 NULL 1_1/1 1 1 1 1 1 1 NULL Authorised on 26/04/2004 0 NULL NULL 1
40 ABNB0167L Fons Kuijpers Richard Harrison Authorised 23/04/2004 NULL 1_1/1 1 1 1 1 1 1 NULL Authorised on 23/04/2004 0 NULL NULL 1
40 ABNB0169L Fons Kuijpers Richard Harrison Authorised 02/08/2004 NULL 1_1/1 1 1 1 1 1 1 1 Authorised on 02/08/2004 0 NULL NULL 1
80 ABNB0171L Fons Kuijpers Richard Harrison Not applicable NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Not applicable 0 NULL NULL 7
40 ABNB0172L Fons Kuijpers Richard Harrison Authorised 26/11/2004 NULL 1_1/1 1 1 1 1 1 1 1 Authorised on 26/11/2004 0 NULL NULL 1
40 ABNB0173L Fons Kuijpers Richard Harrison Authorised 01/11/2004 NULL 1_1/1 1 1 1 1 1 1 1 Authorised on 01/11/2004 0 NULL NULL 1
40 ABNB0175L Fons Kuijpers Richard Harrison Authorised 26/11/2004 NULL 1_1/1 1 1 1 1 1 1 1 Authorised on 26/11/2004 0 NULL NULL 1
40 ABNB0179L Richard Harrison Willem van Asperen Authorised 17/11/2005 NULL 2_1/3 1 3 1 3 1 1 1 Authorised on 17/11/2005 0 NULL NULL 1
80 ABNB0184L Richard Harrison Richard Inman Not applicable NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Not applicable 0 NULL NULL 7
80 ABSA0005L Scott Hamilton Jim Deal Not applicable NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Not applicable 0 NULL NULL 7
80 ABYN0026L Paul Dyson Greg Jones Not applicable NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Not applicable 0 NULL NULL 7
80 ABYN0027L Paul Dyson Greg Jones Not applicable NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Not applicable 1 NULL NULL 7
80 ABYN0043L Paul Dyson NULL Not applicable NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Not applicable 0 NULL NULL 7
80 ABYN0046L Paul Dyson Paul Dyson Not applicable NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Not applicable 0 NULL NULL 7
10 ABYN0052L Scott Hamilton Richard Inman Not yet issued NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Not yet issued 0 NULL NULL 4
80 ABZ-0001L Fons Kuijpers Michael Stockkamp Not applicable NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Not applicable 1 NULL NULL 7
40 ACCE0001L Scott Hamilton NULL Authorised 14/10/2005 NULL 1_1/1 1 1 1 1 1 1 1 Authorised on 14/10/2005 0 NULL NULL 1
30 ADGH0002L Claus Nehmzow Bjoern Beermann Authorised 13/02/2007 NULL 1_1/1 1 1 1 1 1 1 1 Authorised on 13/02/2007 1 NULL NULL 2
80 ADGH0003L Claus Nehmzow Bjoern Beermann Not applicable NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Not applicable 1 NULL NULL 7
80 ADIN0019L Paul Dyson Richard Inman Not applicable NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Not applicable 1 NULL NULL 7
80 ADPS0001L Claus Nehmzow Michael Stockkamp Not applicable NULL 11/10/2005 2_3/1 3 1 1 1 1 1 1 Not applicable 1 NULL NULL 7
60 ADPS0005L Claus Nehmzow Bjoern Beermann Not applicable NULL 22/12/2005 1_1/1 1 1 1 1 1 1 1 Not applicable 1 NULL NULL 6
40 ADPS0009L Claus Nehmzow Bjoern Beermann Authorised 14/03/2006 NULL 1_1/1 1 1 1 1 1 1 1 Authorised on 14/03/2006 1 NULL NULL 1
Let me know what else I need to mention.....
Thanks,
sush