A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.
USE [KingsBayY] GO /****** Object: UserDefinedFunction [dbo].[test_fn_transaction_search] Script Date: 01/30/2015 11:57:44 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO alter PROCEDURE test_fn_transaction_insert_log @receipt varchar(25), @amount varchar(25), @stdt varchar(25), @enddt varchar(25) AS SET NOCOUNT ON INSERT INTO [TransactionLog] ( TimeStamp, CashierID, Total,RecurringStartDate, RecurringStopDate, CustomerID, ReceiptNumber, Voided, Attendee, ItemLookupCode) SELECT CURRENT_TIMESTAMP AS [TimeStamp], tr.CashierID, @amount, @stdt,@enddt,c.ID,tr.ReceiptNumber, tr.Voided,it.ItemLookupCode, tr.Comment from [Transaction] tr, TransactionEntry trent, Item it, Customer c where trent.TransactionID = tr.ID and trent.ItemID = it.ID and c.ID=tr.CustomerID and tr.ReceiptNumber=@receipt --condition to ensure no duplicates are entered and [TransactionLog].ID not in (select ID from [TransactionLog] where [TransactionLog].ID=tr.ID) GO