LalPac News

DCMS - Licensing Statistical Bulletin 2008

Posted: 14:43, 20th July, 2007

    
We
are aware that there have been requests for information from the DCMS,
Audit Commission and Freedom of Information Request from the
Conservative Party for different pieces of information held in your
databases.  Luckily, as always, LalPac are on hand to help you get that
information out of your databases in a quick and efficient manner.  You
will be pleased to hear there is a script to extract the relevant
pieces of information required to complete the Licensing Statistical
Bulletin as requested by DCMS.  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/DCMS_Stats_Aug_2008.zip                           
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.