Try something like this:
SELECT
X.Ticket.value('@FID', 'int') As FID,
X.Ticket.value('@TC', 'int') As TC,
X.Ticket.value('@JobName', 'varchar(50)') As JobName,
X.Ticket.value('@PriceRef', 'int') As PriceRef,
X.Ticket.value('@OurRef', 'int') As OurRef,
X.Ticket.value('@Qty', 'float') As Qty,
X.Ticket.value('@Price', 'money') As Price,
X.Ticket.value('@SubTotal', 'money') As SubTotal,
X.Ticket.value('@Discount', 'numeric') As Discount
FROM
YourTable As T
CROSS APPLY T.YourXmlColumn.nodes('//FieldTicket') As X (Ticket)
;