Umbuchung.sql - Aufgaben - Redmine

Dies ist eine Aufgabe #6 » Umbuchung.sql

Redmine Admin, 29.04.2026 10:26

    
    -- *** SqlDbx Personal Edition ***

    -- !!! Not licensed for commercial use beyound 90 days evaluation period !!!

    -- For version limitations please check http://www.sqldbx.com/personal_edition.htm

    -- Number of queries executed: 1613, number of rows retrieved: 138312287

    --SELECT * FROM Reservations WHERE ID = 805246

    	-- PositionText

    	-- Pl?tze

    --SELECT * FROM ReservationsPositionsAppointments WHERE Reservations_ID = 805246

    	-- Appointment_ID

    	-- EventsReductions_ID

    	-- Categories_ID

    --SELECT * FROM ReservationsPositionsAppointmentsPositions WHERE ReservationsPositions_ID = 645096

    	-- Appointment_ID

    	-- EventsReductions_ID

    	-- Categories_ID

    --SELECT * FROM ReservationsPositionsAppointmentsPositionsSeats WHERE ReservationsPositionsAppointmentsPositions_ID = 645085

    	-- Appointment_ID

    --SELECT * FROM PaymentVoucher WHERE Reservation_ID = 805246

    	-- PositionTextSum

    --SELECT * FROM PaymentVoucherPositions WHERE PaymentVoucher_ID = 788443

    	-- Text

    	-- AppointmentID

    	-- Name

    	-- Subname

    	-- EventKind

    	-- CategoryID

    	-- EventReductionID

    	-- Organisation

    /*

    ALT

    Appointment: 47670

    Name: 'I.O. & Golden Records'

    Subname: 'Familiennacht: Puppenphilarmonie | empfohlen von 4-12 J.'

    CategoryID: 1354

    EventReductionID: 237

    organisation: 'ALB'

    Kat: FEZ - Preiskategorie 2.6

    NEU-Appointment: 

    ALT-EventKind: 'Vorstellung (Theatersaal)'

    NEU-EventKind: 

    */

« Zurück
1
2
Weiter »

(2-2/2)

Projekt

Allgemein

Profil

Aufgaben

Dies ist eine Aufgabe #6 » Umbuchung.sql