Try:
CREATE PROCEDURE DoSomething
AS
BEGIN
CREATE TABLE Transactions
(
TransID varchar(50),
TransAccount varchar(50),
TransMachine varchar(255),
TransUser varchar (255),
Amount money,
Status varchar(255),
Timestamp DateTime
)
INSERT INTO Transactions (TransID, TransAccount, TransMachine, TransUser, Amount, Status, [Timestamp])
VALUES ('00001', '00002', '00003', '00004', 666.66, 'ok', GETDATE());
END
GO