1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52
| SELECT
1 AS [C1],
[Extent1].[RES_ID] AS [RES_ID],
[Extent1].[GED_ID] AS [GED_ID],
[Extent1].[BASE_GED] AS [BASE_GED],
[Extent1].[TITLE] AS [TITLE],
[Extent1].[AUTHOR_FULL_NAME] AS [AUTHOR_FULL_NAME],
[Extent1].[CREATION_DATE] AS [CREATION_DATE],
[Extent1].[TYPIST_FULL_NAME] AS [TYPIST_FULL_NAME],
[Extent1].[NATURE_ID] AS [NATURE_ID],
[Extent1].[NATURE_DESC] AS [NATURE_DESC],
[Extent1].[CONSERVATION] AS [CONSERVATION],
[Extent1].[FORMAT] AS [FORMAT],
[Extent1].[IMPUTATION] AS [IMPUTATION],
[Extent1].[DELIVERY_DATE] AS [DELIVERY_DATE],
[Extent1].[F_NUM] AS [F_NUM],
[Extent1].[NB_PAGES] AS [NB_PAGES],
[Extent1].[SUPPORT_SUP] AS [SUPPORT_SUP],
[Extent1].[NB_SUPPORT] AS [NB_SUPPORT],
[Extent1].[COMMENTS] AS [COMMENTS],
[Extent1].[A_IMPUTATION] AS [A_IMPUTATION],
[Extent1].[RECEPTION_DOC] AS [RECEPTION_DOC],
[Extent1].[STOCKAGE] AS [STOCKAGE],
[Extent1].[MCDI] AS [MCDI],
[Extent1].[DS_DESTRUCTION] AS [DS_DESTRUCTION],
[Extent1].[STATUS] AS [STATUS],
[Extent1].[DS_FI] AS [DS_FI],
[Extent1].[DS_WINDOC] AS [DS_WINDOC],
[Extent1].[DS_NUMERISATION] AS [DS_NUMERISATION],
[Extent1].[DS_GED] AS [DS_GED],
[Extent1].[DS_MCDI] AS [DS_MCDI],
[Extent1].[DS_SAS] AS [DS_SAS],
[Extent1].[DS_STOCKAGE] AS [DS_STOCKAGE],
[Extent1].[F_NUM_TIME] AS [F_NUM_TIME],
[Extent1].[Z_PAGE_COUNT] AS [Z_PAGE_COUNT],
[Extent1].[Z_SCAN_USER] AS [Z_SCAN_USER],
[Extent1].[Z_SCAN_WKSTATION] AS [Z_SCAN_WKSTATION],
[Extent1].[Z_SCAN_DATE] AS [Z_SCAN_DATE],
[Extent1].[Z_IS_PAPER] AS [Z_IS_PAPER],
[Extent1].[Z_SCAN_LOCATION] AS [Z_SCAN_LOCATION],
[Extent1].[Z_SCAN_BATCH] AS [Z_SCAN_BATCH],
[Extent1].[Z_BURN_BATCH] AS [Z_BURN_BATCH],
[Extent1].[Z_FINGERPRINT] AS [Z_FINGERPRINT],
[Extent1].[Z_FILE_NAME] AS [Z_FILE_NAME],
[Extent1].[Z_FILE_SIZE] AS [Z_FILE_SIZE],
[Extent1].[ARBOX_ID] AS [ARBOX_ID],
[Extent1].[AUTHOR_ID] AS [AUTHOR_ID],
[Extent1].[CORRESPONDANT_ID] AS [CORRESPONDANT_ID],
[Extent1].[DEMANDEUR] AS [DEMANDEUR],
[Extent1].[TYPIST_ID] AS [TYPIST_ID],
[Extent1].[T_PROCESSUS] AS [T_PROCESSUS]
FROM [dbo].[PROFILE] AS [Extent1] |
Partager