UFN_DOWNLOAD_RESERVATIONCONTRACTATTACHMENT_FILE

                            CREATE function dbo.UFN_DOWNLOAD_RESERVATIONCONTRACTATTACHMENT_FILE
                            (
                                @ID uniqueidentifier
                            ) returns table
                            as return
                                select
                                    RESERVATIONATTACHMENT.[FILE]
                                from
                                    dbo.RESERVATION
                                inner join
                                    dbo.RESERVATIONATTACHMENT on RESERVATION.ID = RESERVATIONATTACHMENT.RESERVATIONID and RESERVATIONATTACHMENT.ISCONTRACT = 1
                                where
                                    RESERVATION.ID = @ID;