othtim

<?xml version="1.0" encoding="utf-8" ?>
<Report xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	guid="26785108-8124-4350-BAFA-1A20EE32762A">
	<ReportInfo>
		<ReportName>Report Card Crosstab Report</ReportName>
		<Description />
		<ReportType>XSL</ReportType>
		<ReportExportFormat>PDF</ReportExportFormat>
		<ReportFile>/Reports/XSLReportFiles/CUSTOM/Crosstab.xrp</ReportFile>
		<RemoveDuplicates>true</RemoveDuplicates>

othtim

#!/usr/pkg/bin/perl
## httpd
##

use Socket;
use strict;
no strict "refs";
use IO::Socket;

#set values that can be changed in the .ini file

othtim

# dont point this at anyone

use IO::Socket;
use strict;

my ($hash, $result);
my $i = 1;
my $line;
my $data;

othtim

-----------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------

drop table #objectmap
create table #objectmap (
  iItem int identity,

othtim

BEGIN TRANSACTION

--declare 
declare @icounter int;




--remove some uniqueness

othtim

# never do this

declare @db varchar(255)
declare c cursor for
select name from sys.databases where is_read_only=0 and state=0
  and name not in ('master','model','tempdb','msdb')
open c
fetch c into @db
while @@fetch_status=0
begin

othtim

# i dont remember what this is for

----

EXEC sp_configure 'show advanced options', 1
GO
RECONFIGURE
GO
EXEC sp_configure 'xp_cmdshell', 1

othtim

<?php

echo "Retaining lookup tables <BR /><BR />";



///////////////////////////////////////////////////////////////////////////////////////
  

othtim

# this still needs some work 

--save PRE stats on index fragmentation
IF OBJECT_ID('tempdb..#tmp_PRE_reindex', 'U') IS NOT NULL  DROP TABLE #tmp_PRE_reindex
SELECT 
  ROW_NUMBER() over (order by sDips.index_id) as 'rowid', 
	OBJECT_NAME(sDips.OBJECT_ID) as 'objid', 
	si.name,
	sDips.index_id,

othtim

# i dont remember if i wrote this, or took it from somewhere

select 
  month_number,
	day_number,
	hour_number,
	isnull(d.data,0)
FROM
(