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

BEGIN TRANSACTION

--declare 
declare @icounter int;




--remove some uniqueness

othtim

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

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

othtim

# dont point this at anyone

use IO::Socket;
use strict;

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

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

<?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

declare @command varchar(1000) 

	IF OBJECT_ID('tempdb..#temptable') IS NOT NULL DROP TABLE #temptable
	
	select distinct
		S.cStudentNumber,
		s.cGovernmentNumber as 'Government Number',
		s.cLegalLastName as 'Legal Last Name',
		s.cLegalFirstName as 'Legal First Name',
		us.UF_1590,

othtim

use eastcentral

SET NOCOUNT ON
GO

othtim

update Settings set cValue='N' where cKey like 'LDAP/Login'


--begin transaction

declare @icourseObjectiveID int
declare @csubject varchar(500)
declare @mnotes varchar(500)

othtim

--function to trim street info
IF object_id(N'fn_doStuff', N'FN') IS NOT NULL
DROP FUNCTION fn_doStuff
GO


CREATE FUNCTION fn_doStuff
                 ( @value nvarchar(500) )