LalPac News

Freedom of Information Request - The Conservative

Posted: 14:46, 15th June, 2007

The Conservative Party sent out a freedom of
information request. This request asked for information on the number of Licensing Act licences in existence in 2006,
2007 and 2008 both on sales and off sales. In
addition to this, information has also been requested on the number of
new applications for Premises Licences in 2006, 2007 and 2008.  We have
put the script and details on how to run it into a WinZip file on the
LalPac website at the following address: 
www.lalpac.eclipse.co.uk/downloads/FOIR_July_2008.zip please note that
the report also includes information for Club Premises and also joint
On and Off Sales.  This allows you to make the choice as to whether to
include this detail in the overall information you send back. Due
to the complexity of the script and the manner in which it has to query
your database, it cannot be run through LalPac itself.  It must instead
be run through a tool called SQL Server Query Analyser which your IT
Department will have access to and will be able to forward the results
back over to you.  Please note this script is not compatible with
Paradox databases.