Буду очень благодарна если ктото может помоч перевести дата из таблицы в ехсел формат.
Для начала имею пустую форму...
SELECT

flight_Data.aircraft_Oid,
'ac_id'= dbo.Udf_Get_aircraft_id_by_Oid(flight_data.aircraft_oid),

day_name_1' = upper(left(datename(weekday, dateadd(day, 1 - 1, :start_Date)), 3)),
'day_no_1' = datepart(day, dateadd(day, 1 - 1, :start_Date)),
'day_name_2' = upper(left(datename(weekday, dateadd(day, 2 - 1, :start_Date)), 3)),
'day_no_2' = datepart(day, dateadd(day, 2 - 1, :start_Date)),
'day_name_3' = upper(left(datename(weekday, dateadd(day, 3 - 1, :start_Date)), 3)),
'day_no_3' = datepart(day, dateadd(day, 3 - 1, :start_Date)),
'day_name_4' = upper(left(datename(weekday, dateadd(day, 4 - 1, :start_Date)), 3)),
'day_no_4' = datepart(day, dateadd(day, 4 - 1, :start_Date)),
'day_name_5' = upper(left(datename(weekday, dateadd(day, 5 - 1, :start_Date)), 3)),
'day_no_5' = datepart(day, dateadd(day, 5 - 1, :start_Date)),
'day_name_6' = upper(left(datename(weekday, dateadd(day, 6 - 1, :start_Date)), 3)),
'day_no_6' = datepart(day, dateadd(day, 6 - 1, :start_Date)),
'day_name_7' = upper(left(datename(weekday, dateadd(day, 7 - 1, :start_Date)), 3)),
'day_no_7' = datepart(day, dateadd(day, 7 - 1, :start_Date)),
'origin_1' = ' ',
'origin_2' = ' ',
'origin_3' = ' ',
'origin_4' = ' ',
'origin_5' = ' ',

'origin_6' = ' ',
'origin_7' = ' ',
'origin_8' = ' ',
'origin_9' = ' ',
'origin_10' = ' ',

'origin_11' = ' ',
'origin_12' = ' ',
'origin_13' = ' ',
'origin_14' = ' ',
'origin_15' = ' ',

'origin_16' = ' ',
'origin_17' = ' ',
'origin_18' = ' ',
'origin_19' = ' ',
'origin_20' = ' ',

'origin_21' = ' ',
'origin_22' = ' ',
'origin_23' = ' ',
'origin_24' = ' ',
'origin_25' = ' ',

'origin_26' = ' ',
'origin_27' = ' ',
'origin_28' = ' ',
'origin_29' = ' ',
'origin_30' = ' ',

'origin_31' = ' ',
'origin_32' = ' ',
'origin_33' = ' ',
'origin_34' = ' ',
'origin_35' = ' '
from flight_Data where
actual_time_out between :start_Date and dateadd(day, 7 - 1, :start_Date)


7 днеи, 5 полетов в день..
Я могу наверно создать датастор....но не уверена как сделат луп..
Спасибо болшое всем за помощ и с Наступающим Новым Годом

Imitazia Formata Excel..
Ia seichas poprobuiu prilojit' .srd datawindow file esli poluchitsia..
Rezultat kotori' nujen:
Agrument nachalnaia data, zagolovki - 7 dnei s toi dati ( den' nedeli i data)
Kajdi' row... dlia odnogo samoleta..
Kajdi den' vozmojno 5 poletov v datovom poriadke. Grafik ne nujen , prosto otkuda i kuda i vremia, no eto ia uje potom soobraju kak, esli u menia budet osnovnoi format.
V database, kajdi' polet eto 1 record.
Drugimi slovami nado perevernut' neskolko records v odnu liniu.
Dumala napisat' UDAFF, s peredachei dat, no ne uverena kak eto sdelat'.
Spasibo ..

No, Saveas ne srabotaet for this case..
Data v tablize otdelni' record dlia kajdogo poleta.. a mne nujno sdelat' mnojestvennie poleti v kajdoi stroke.