SQL Queen gathered sql information for personal reference

17May/120

ASP.NET 2.0 Applications Might Generate HttpException Errors that Reference eurl.axd

After ASP.NET 4 has been enabled on IIS 6, ASP.NET 2.0 applications that run on IIS 6 (in either Windows Server 2003 or Windows Server 2003 R2) might generate errors such as the following:

System.Web.HttpException: Path '/[yourApplicationRoot]/eurl.axd/[Value]' was not found.

This error occurs because when ASP.NET detects that a Web site is configured to use ASP.NET 4, a native component of ASP.NET 4 passes an extensionless URL to the managed portion of ASP.NET for further processing. However, if virtual directories that are below an ASP.NET 4 Web site are configured to use ASP.NET 2.0, processing the extensionless URL in this way results in a modified URL that contains the string "eurl.axd". This modified URL is then sent to the ASP.NET 2.0 application. ASP.NET 2.0 cannot recognize the "eurl.axd" format. Therefore, ASP.NET 2.0 tries to find a file named eurl.axd and execute it. Because no such file exists, the request fails with an HttpException exception.

You can work around this issue using one of the following options.

Option 1
If ASP.NET 4 is not required in order to run the Web site, remap the site to use ASP.NET 2.0 instead.

Option 2
If ASP.NET 4 is required in order to run the Web site, move any child ASP.NET 2.0 virtual directories to a different Web site that is mapped to ASP.NET 2.0.

Option 3
If it is not practical to remap the Web site to ASP.NET 2.0 or to change the location of a virtual directory, explicitly disable extensionless URL processing in ASP.NET 4. Use the following procedure:

1.In the Windows registry, open the following node:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\ASP.NET\4.0.30319.0

1.Create a new DWORD value named EnableExtensionlessUrls.
2.Set EnableExtensionlessUrls to 0. This disables extensionless URL behavior.
3.Save the registry value and close the registry editor.
4.Run the iisreset command-line tool, which causes IIS to read the new registry value.
Note Setting EnableExtensionlessUrls to 1 enables extensionless URL behavior. This is the default setting if no value is specified.

Filed under: web dev No Comments
10May/120

sql column count

SELECT TABLE_NAME, COUNT(*) AS '# OF COLUMNS'
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'name-of-tables'
GROUP BY TABLE_NAME

Filed under: sql sever syntax No Comments
25Apr/12Off

stored procedure properties

crtl-shift-m

/*
Run this script on:

den-ecm-wb08.hsqe    -  This database will be modified

to synchronize it with:

(local).hsqe

You are recommended to back up your database before running this script

Script created by SQL Compare version 10.0.0 from Red Gate Software Ltd at 4/25/2012 3:09:29 PM

*/
SET NUMERIC_ROUNDABORT OFF
GO
SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
IF EXISTS (SELECT * FROM tempdb..sysobjects WHERE id=OBJECT_ID('tempdb..#tmpErrors')) DROP TABLE #tmpErrors
GO
CREATE TABLE #tmpErrors (Error int)
GO
SET XACT_ABORT ON
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO
BEGIN TRANSACTION
GO
PRINT N'Creating [dbo].[HSQE_sp_ReportingConstructionTotals]'
GO

-- =============================================
-- Author:        Name
-- Create date:
-- Description:
-- =============================================
CREATE PROCEDURE [dbo].[HSQE_sp_ReportingConstructionTotals]
-- Add the parameters for the stored procedure here
@startdate DATE ,
@enddate DATE
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON ;

-- Insert statements for procedure here
SELECT  COUNT(projectname) ,
SUM(RESHours + NonRESHours + RESSubHours) AS 'Total Man Hours' ,
CAST(ROUND(( ( ( SELECT COUNT(classid)
FROM   dbo.Safety s ,
vwProjectDropdown p
WHERE  s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN ( 1, 2, 9 )
AND projectphase = 5
AND classid = 1
) * 64
+ ( SELECT   COUNT(classid)
FROM     dbo.Safety s ,
vwProjectDropdown p
WHERE    s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN ( 1, 2, 9 )
AND projectphase = 5
AND classid = 2
) * 16
+ ( SELECT   COUNT(classid)
FROM     dbo.Safety s ,
vwProjectDropdown p
WHERE    s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN ( 1, 2, 9 )
AND projectphase = 5
AND classid = 3
) * 4
+ ( SELECT   COUNT(classid)
FROM     dbo.Safety s ,
vwProjectDropdown p
WHERE    s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN ( 1, 2, 9 )
AND projectphase = 5
AND classid = 4
) * 1 ) * 1000 / SUM(RESHours + NonRESHours
+ RESSubHours) ), 2) AS DECIMAL(15,
2)) AS 'Monthly RES SSI w/o NM' ,
CAST(ROUND(( ( ( SELECT COUNT(classid)
FROM   dbo.Safety s ,
vwProjectDropdown p
WHERE  s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN ( 1, 2, 9 )
AND projectphase = 5
AND classid = 1
)
+ ( SELECT   COUNT(classid)
FROM     dbo.Safety s ,
vwProjectDropdown p
WHERE    s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN ( 1, 2, 9 )
AND projectphase = 5
AND classid = 2
) ) * 200000 / SUM(RESHours + NonRESHours
+ RESSubHours) ), 2) AS DECIMAL(15,
2)) AS 'Monthly TRIR' ,
( SELECT    COUNT(DISTINCT projectnumber)
FROM      dbo.Safety s ,
vwProjectDropdown p
WHERE     s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN ( 1, 2, 9 )
AND projectphase = 5
) AS projectcount ,
( SELECT    COUNT(classid)
FROM      dbo.Safety s ,
vwProjectDropdown p
WHERE     s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN ( 1, 2, 9 )
AND projectphase = 5
AND classid = 1
) AS 'Lost Time Accident' ,
( SELECT    COUNT(classid)
FROM      dbo.Safety s ,
vwProjectDropdown p
WHERE     s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN ( 1, 2, 9 )
AND projectphase = 5
AND classid = 2
) AS 'Recordable Injury' ,
( SELECT    COUNT(classid)
FROM      dbo.Safety s ,
vwProjectDropdown p
WHERE     s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN ( 1, 2, 9 )
AND projectphase = 5
AND classid = 3
) AS 'Non Recordable Injury' ,
( SELECT    COUNT(classid)
FROM      dbo.Safety s ,
vwProjectDropdown p
WHERE     s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN ( 1, 2, 9 )
AND projectphase = 5
AND classid = 4
) AS 'Property or Equiment Damage' ,
( SELECT    COUNT(classid)
FROM      dbo.Safety s ,
vwProjectDropdown p
WHERE     s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN ( 1, 2, 9 )
AND projectphase = 5
AND classid = 5
) AS 'Near Miss' ,
( SELECT    COUNT(classid)
FROM      dbo.Safety s ,
vwProjectDropdown p
WHERE     s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN ( 1, 2, 9 )
AND projectphase = 5
) AS 'Total'
FROM    dbo.Safety s
INNER JOIN vwProjectDropdown p ON s.ProjectNumber = p.ProjectID
LEFT OUTER JOIN dbo.ManHours m ON s.ProjectNumber = m.ProjectNumber
WHERE   s.isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ( m.WeekEnding >= @startdate
AND WeekEnding <= @enddate
)
END

GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
PRINT N'Creating [dbo].[HSQE_sp_ReportingOperatingTotals]'
GO

-- =============================================
-- Author:        Name
-- Create date:
-- Description:
-- =============================================
CREATE PROCEDURE [dbo].[HSQE_sp_ReportingOperatingTotals]
-- Add the parameters for the stored procedure here
@startdate DATE ,
@enddate DATE
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON ;

-- Insert statements for procedure here
SELECT  COUNT(projectname) ,
SUM(RESHours + NonRESHours + RESSubHours) AS 'Total Man Hours' ,
CAST(ROUND(( ( ( SELECT COUNT(classid)
FROM   dbo.Safety s ,
vwProjectDropdown p
WHERE  s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN ( 1, 2, 9 )
AND projectphase = 6
AND classid = 1
) * 64
+ ( SELECT   COUNT(classid)
FROM     dbo.Safety s ,
vwProjectDropdown p
WHERE    s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN ( 1, 2, 9 )
AND projectphase = 6
AND classid = 2
) * 16
+ ( SELECT   COUNT(classid)
FROM     dbo.Safety s ,
vwProjectDropdown p
WHERE    s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN ( 1, 2, 9 )
AND projectphase = 6
AND classid = 3
) * 4
+ ( SELECT   COUNT(classid)
FROM     dbo.Safety s ,
vwProjectDropdown p
WHERE    s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN ( 1, 2, 9 )
AND projectphase = 6
AND classid = 4
) * 1 ) * 1000 / SUM(RESHours + NonRESHours
+ RESSubHours) ), 2) AS DECIMAL(15,
2)) AS 'Monthly RES SSI w/o NM' ,
CAST(ROUND(( ( ( SELECT COUNT(classid)
FROM   dbo.Safety s ,
vwProjectDropdown p
WHERE  s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN ( 1, 2, 9 )
AND projectphase = 6
AND classid = 1
)
+ ( SELECT   COUNT(classid)
FROM     dbo.Safety s ,
vwProjectDropdown p
WHERE    s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN ( 1, 2, 9 )
AND projectphase = 6
AND classid = 2
) ) * 200000 / SUM(RESHours + NonRESHours
+ RESSubHours) ), 2) AS DECIMAL(15,
2)) AS 'Monthly TRIR' ,
( SELECT    COUNT(DISTINCT projectnumber)
FROM      dbo.Safety s ,
vwProjectDropdown p
WHERE     s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN ( 1, 2, 9 )
AND projectphase = 6
) AS projectcount ,
( SELECT    COUNT(classid)
FROM      dbo.Safety s ,
vwProjectDropdown p
WHERE     s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN ( 1, 2, 9 )
AND projectphase = 6
AND classid = 1
) AS 'Lost Time Accident' ,
( SELECT    COUNT(classid)
FROM      dbo.Safety s ,
vwProjectDropdown p
WHERE     s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN ( 1, 2, 9 )
AND projectphase = 6
AND classid = 2
) AS 'Recordable Injury' ,
( SELECT    COUNT(classid)
FROM      dbo.Safety s ,
vwProjectDropdown p
WHERE     s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN ( 1, 2, 9 )
AND projectphase = 6
AND classid = 3
) AS 'Non Recordable Injury' ,
( SELECT    COUNT(classid)
FROM      dbo.Safety s ,
vwProjectDropdown p
WHERE     s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN ( 1, 2, 9 )
AND projectphase = 6
AND classid = 4
) AS 'Property or Equiment Damage' ,
( SELECT    COUNT(classid)
FROM      dbo.Safety s ,
vwProjectDropdown p
WHERE     s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN ( 1, 2, 9 )
AND projectphase = 6
AND classid = 5
) AS 'Near Miss' ,
( SELECT    COUNT(classid)
FROM      dbo.Safety s ,
vwProjectDropdown p
WHERE     s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN ( 1, 2, 9 )
AND projectphase = 6
) AS 'Total'
FROM    dbo.Safety s
INNER JOIN vwProjectDropdown p ON s.ProjectNumber = p.ProjectID
LEFT OUTER JOIN dbo.ManHours m ON s.ProjectNumber = m.ProjectNumber
WHERE   s.isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ( m.WeekEnding >= @startdate
AND WeekEnding <= @enddate
)
END

GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
PRINT N'Creating [dbo].[HSQE_sp_ReportingCAWindConstructionTotals]'
GO

-- =============================================
-- Author:        Name
-- Create date:
-- Description:
-- =============================================
CREATE PROCEDURE [dbo].[HSQE_sp_ReportingCAWindConstructionTotals]
-- Add the parameters for the stored procedure here
@startdate DATE ,
@enddate DATE
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON ;

-- Insert statements for procedure here
SELECT DISTINCT ProjectName, SUM(RESHours + NonRESHours + RESSubHours) AS 'Total Man Hours',
CAST(ROUND(( ( ( SELECT COUNT(classid)
FROM   dbo.Safety s ,
vwProjectDropdown p
WHERE  s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN (1,2)
AND projectphase = 5
AND CountryCode = 'CAN'
AND classid = 1
) * 64
+ ( SELECT   COUNT(classid)
FROM     dbo.Safety s ,
vwProjectDropdown p
WHERE    s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN (1,2)
AND projectphase = 5
AND CountryCode = 'CAN'
AND classid = 2
) * 16
+ ( SELECT   COUNT(classid)
FROM     dbo.Safety s ,
vwProjectDropdown p
WHERE    s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN (1,2)
AND projectphase = 5
AND CountryCode = 'CAN'
AND classid = 3
) * 4
+ ( SELECT   COUNT(classid)
FROM     dbo.Safety s ,
vwProjectDropdown p
WHERE    s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN (1,2)
AND projectphase = 5
AND CountryCode = 'CAN'
AND classid = 4
) * 1 ) * 1000 / SUM(RESHours + NonRESHours
+ RESSubHours) ), 2) AS DECIMAL(15,
2)) AS 'Monthly RES SSI w/o NM' ,
CAST(ROUND(( ( ( SELECT COUNT(classid)
FROM   dbo.Safety s ,
vwProjectDropdown p
WHERE  s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN (1,2)
AND projectphase = 5
AND CountryCode = 'CAN'
AND classid = 1
)
+ ( SELECT   COUNT(classid)
FROM     dbo.Safety s ,
vwProjectDropdown p
WHERE    s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN (1,2)
AND projectphase = 5
AND CountryCode = 'CAN'
AND classid = 2
) ) * 200000 / SUM(RESHours + NonRESHours
+ RESSubHours) ), 2) AS DECIMAL(15,
2)) AS 'Monthly TRIR' ,
(SELECT COUNT(classid) FROM dbo.Safety WHERE classid = 1 AND projectnumber = p.projectid) AS 'Lost Time Accident',
(SELECT COUNT(classid) FROM dbo.Safety WHERE classid = 2 AND projectnumber = p.projectid) AS 'Recordable Injury',
(SELECT COUNT(classid) FROM dbo.Safety WHERE classid = 3 AND projectnumber = p.projectid) AS 'Non Recordable Injury',
(SELECT COUNT(classid) FROM dbo.Safety WHERE classid = 4 AND projectnumber = p.projectid) AS 'Property or Equiment Damage',
(SELECT COUNT(classid) FROM dbo.Safety WHERE classid = 5 AND projectnumber = p.projectid) AS 'Near Miss',
(SELECT COUNT(classid) FROM dbo.Safety WHERE projectnumber = p.projectid) AS 'Total'
FROM dbo.Safety s
INNER JOIN dbo.SafetyClass c
ON s.ClassID = c.ClassID
INNER JOIN vwProjectDropdown p
ON s.ProjectNumber = p.ProjectID
LEFT OUTER JOIN dbo.ManHours m
ON m.ProjectNumber = s.ProjectNumber
WHERE projecttypeid IN (1,2)
AND projectphase = 5 AND CountryCode = 'CAN' AND s.isCurrent = 1
AND (s.DateIncident >= @startdate AND s.DateIncident <= @enddate)
GROUP BY projectname, projectid
END

GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
PRINT N'Creating [dbo].[HSQE_sp_ReportingUSSolarConstructionTotals]'
GO

-- =============================================
-- Author:        Name
-- Create date:
-- Description:
-- =============================================
CREATE PROCEDURE [dbo].[HSQE_sp_ReportingUSSolarConstructionTotals]
-- Add the parameters for the stored procedure here
@startdate DATE ,
@enddate DATE
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON ;

-- Insert statements for procedure here
SELECT DISTINCT ProjectName, SUM(RESHours + NonRESHours + RESSubHours) AS 'Total Man Hours',
CAST(ROUND(( ( ( SELECT COUNT(classid)
FROM   dbo.Safety s ,
vwProjectDropdown p
WHERE  s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN (9)
AND projectphase = 5
AND CountryCode = 'USA'
AND classid = 1
) * 64
+ ( SELECT   COUNT(classid)
FROM     dbo.Safety s ,
vwProjectDropdown p
WHERE    s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN (9)
AND projectphase = 5
AND CountryCode = 'USA'
AND classid = 2
) * 16
+ ( SELECT   COUNT(classid)
FROM     dbo.Safety s ,
vwProjectDropdown p
WHERE    s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN (9)
AND projectphase = 5
AND CountryCode = 'USA'
AND classid = 3
) * 4
+ ( SELECT   COUNT(classid)
FROM     dbo.Safety s ,
vwProjectDropdown p
WHERE    s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN (9)
AND projectphase = 5
AND CountryCode = 'USA'
AND classid = 4
) * 1 ) * 1000 / SUM(RESHours + NonRESHours
+ RESSubHours) ), 2) AS DECIMAL(15,
2)) AS 'Monthly RES SSI w/o NM' ,
CAST(ROUND(( ( ( SELECT COUNT(classid)
FROM   dbo.Safety s ,
vwProjectDropdown p
WHERE  s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN (9)
AND projectphase = 5
AND CountryCode = 'USA'
AND classid = 1
)
+ ( SELECT   COUNT(classid)
FROM     dbo.Safety s ,
vwProjectDropdown p
WHERE    s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN (9)
AND projectphase = 5
AND CountryCode = 'USA'
AND classid = 2
) ) * 200000 / SUM(RESHours + NonRESHours
+ RESSubHours) ), 2) AS DECIMAL(15,
2)) AS 'Monthly TRIR' ,
(SELECT COUNT(classid) FROM dbo.Safety WHERE classid = 1 AND projectnumber = p.projectid) AS 'Lost Time Accident',
(SELECT COUNT(classid) FROM dbo.Safety WHERE classid = 2 AND projectnumber = p.projectid) AS 'Recordable Injury',
(SELECT COUNT(classid) FROM dbo.Safety WHERE classid = 3 AND projectnumber = p.projectid) AS 'Non Recordable Injury',
(SELECT COUNT(classid) FROM dbo.Safety WHERE classid = 4 AND projectnumber = p.projectid) AS 'Property or Equiment Damage',
(SELECT COUNT(classid) FROM dbo.Safety WHERE classid = 5 AND projectnumber = p.projectid) AS 'Near Miss',
(SELECT COUNT(classid) FROM dbo.Safety WHERE projectnumber = p.projectid) AS 'Total'
FROM dbo.Safety s
INNER JOIN dbo.SafetyClass c
ON s.ClassID = c.ClassID
INNER JOIN vwProjectDropdown p
ON s.ProjectNumber = p.ProjectID
LEFT OUTER JOIN dbo.ManHours m
ON m.ProjectNumber = s.ProjectNumber
WHERE projecttypeid IN (9)
AND projectphase = 5 AND CountryCode = 'USA' AND s.isCurrent = 1
AND (s.DateIncident >= @startdate AND s.DateIncident <= @enddate)
GROUP BY projectname, projectid
END

GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
PRINT N'Creating [dbo].[HSQE_sp_ReportingCASolarConstructionTotals]'
GO

-- =============================================
-- Author:        Name
-- Create date:
-- Description:
-- =============================================
CREATE PROCEDURE [dbo].[HSQE_sp_ReportingCASolarConstructionTotals]
-- Add the parameters for the stored procedure here
@startdate DATE ,
@enddate DATE
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON ;

-- Insert statements for procedure here
SELECT DISTINCT ProjectName, SUM(RESHours + NonRESHours + RESSubHours) AS 'Total Man Hours',
CAST(ROUND(( ( ( SELECT COUNT(classid)
FROM   dbo.Safety s ,
vwProjectDropdown p
WHERE  s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN (9)
AND projectphase = 5
AND CountryCode = 'CAN'
AND classid = 1
) * 64
+ ( SELECT   COUNT(classid)
FROM     dbo.Safety s ,
vwProjectDropdown p
WHERE    s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN (9)
AND projectphase = 5
AND CountryCode = 'CAN'
AND classid = 2
) * 16
+ ( SELECT   COUNT(classid)
FROM     dbo.Safety s ,
vwProjectDropdown p
WHERE    s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN (9)
AND projectphase = 5
AND CountryCode = 'CAN'
AND classid = 3
) * 4
+ ( SELECT   COUNT(classid)
FROM     dbo.Safety s ,
vwProjectDropdown p
WHERE    s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN (9)
AND projectphase = 5
AND CountryCode = 'CAN'
AND classid = 4
) * 1 ) * 1000 / SUM(RESHours + NonRESHours
+ RESSubHours) ), 2) AS DECIMAL(15,
2)) AS 'Monthly RES SSI w/o NM' ,
CAST(ROUND(( ( ( SELECT COUNT(classid)
FROM   dbo.Safety s ,
vwProjectDropdown p
WHERE  s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN (9)
AND projectphase = 5
AND CountryCode = 'CAN'
AND classid = 1
)
+ ( SELECT   COUNT(classid)
FROM     dbo.Safety s ,
vwProjectDropdown p
WHERE    s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN (9)
AND projectphase = 5
AND CountryCode = 'CAN'
AND classid = 2
) ) * 200000 / SUM(RESHours + NonRESHours
+ RESSubHours) ), 2) AS DECIMAL(15,
2)) AS 'Monthly TRIR' ,
(SELECT COUNT(classid) FROM dbo.Safety WHERE classid = 1 AND projectnumber = p.projectid) AS 'Lost Time Accident',
(SELECT COUNT(classid) FROM dbo.Safety WHERE classid = 2 AND projectnumber = p.projectid) AS 'Recordable Injury',
(SELECT COUNT(classid) FROM dbo.Safety WHERE classid = 3 AND projectnumber = p.projectid) AS 'Non Recordable Injury',
(SELECT COUNT(classid) FROM dbo.Safety WHERE classid = 4 AND projectnumber = p.projectid) AS 'Property or Equiment Damage',
(SELECT COUNT(classid) FROM dbo.Safety WHERE classid = 5 AND projectnumber = p.projectid) AS 'Near Miss',
(SELECT COUNT(classid) FROM dbo.Safety WHERE projectnumber = p.projectid) AS 'Total'
FROM dbo.Safety s
INNER JOIN dbo.SafetyClass c
ON s.ClassID = c.ClassID
INNER JOIN vwProjectDropdown p
ON s.ProjectNumber = p.ProjectID
LEFT OUTER JOIN dbo.ManHours m
ON m.ProjectNumber = s.ProjectNumber
WHERE projecttypeid IN (9)
AND projectphase = 5 AND CountryCode = 'CAN' AND s.isCurrent = 1
AND (s.DateIncident >= @startdate AND s.DateIncident <= @enddate)
GROUP BY projectname, projectid
END

GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
PRINT N'Creating [dbo].[HSQE_sp_ReportingUSWindOperatingTotals]'
GO

-- =============================================
-- Author:        Name
-- Create date:
-- Description:
-- =============================================
CREATE PROCEDURE [dbo].[HSQE_sp_ReportingUSWindOperatingTotals]
-- Add the parameters for the stored procedure here
@startdate DATE ,
@enddate DATE
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON ;

-- Insert statements for procedure here
SELECT DISTINCT ProjectName, SUM(RESHours + NonRESHours + RESSubHours) AS 'Total Man Hours',
CAST(ROUND(( ( ( SELECT COUNT(classid)
FROM   dbo.Safety s ,
vwProjectDropdown p
WHERE  s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN (1,2)
AND projectphase = 6
AND CountryCode = 'USA'
AND classid = 1
) * 64
+ ( SELECT   COUNT(classid)
FROM     dbo.Safety s ,
vwProjectDropdown p
WHERE    s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN (1,2)
AND projectphase = 6
AND CountryCode = 'USA'
AND classid = 2
) * 16
+ ( SELECT   COUNT(classid)
FROM     dbo.Safety s ,
vwProjectDropdown p
WHERE    s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN (1,2)
AND projectphase = 6
AND CountryCode = 'USA'
AND classid = 3
) * 4
+ ( SELECT   COUNT(classid)
FROM     dbo.Safety s ,
vwProjectDropdown p
WHERE    s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN (1,2)
AND projectphase = 6
AND CountryCode = 'USA'
AND classid = 4
) * 1 ) * 1000 / SUM(RESHours + NonRESHours
+ RESSubHours) ), 2) AS DECIMAL(16,
2)) AS 'Monthly RES SSI w/o NM' ,
CAST(ROUND(( ( ( SELECT COUNT(classid)
FROM   dbo.Safety s ,
vwProjectDropdown p
WHERE  s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN (1,2)
AND projectphase = 6
AND CountryCode = 'USA'
AND classid = 1
)
+ ( SELECT   COUNT(classid)
FROM     dbo.Safety s ,
vwProjectDropdown p
WHERE    s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN (1,2)
AND projectphase = 6
AND CountryCode = 'USA'
AND classid = 2
) ) * 200000 / SUM(RESHours + NonRESHours
+ RESSubHours) ), 2) AS DECIMAL(16,
2)) AS 'Monthly TRIR' ,
(SELECT COUNT(classid) FROM dbo.Safety WHERE classid = 1 AND projectnumber = p.projectid) AS 'Lost Time Accident',
(SELECT COUNT(classid) FROM dbo.Safety WHERE classid = 2 AND projectnumber = p.projectid) AS 'Recordable Injury',
(SELECT COUNT(classid) FROM dbo.Safety WHERE classid = 3 AND projectnumber = p.projectid) AS 'Non Recordable Injury',
(SELECT COUNT(classid) FROM dbo.Safety WHERE classid = 4 AND projectnumber = p.projectid) AS 'Property or Equiment Damage',
(SELECT COUNT(classid) FROM dbo.Safety WHERE classid = 5 AND projectnumber = p.projectid) AS 'Near Miss',
(SELECT COUNT(classid) FROM dbo.Safety WHERE projectnumber = p.projectid) AS 'Total'
FROM dbo.Safety s
INNER JOIN dbo.SafetyClass c
ON s.ClassID = c.ClassID
INNER JOIN vwProjectDropdown p
ON s.ProjectNumber = p.ProjectID
LEFT OUTER JOIN dbo.ManHours m
ON m.ProjectNumber = s.ProjectNumber
WHERE projecttypeid IN (1,2)
AND projectphase = 6 AND CountryCode = 'USA' AND s.isCurrent = 1
AND (s.DateIncident >= @startdate AND s.DateIncident <= @enddate)
GROUP BY projectname, projectid
END

GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
PRINT N'Creating [dbo].[HSQE_sp_ReportingCAWindOperatingTotals]'
GO

-- =============================================
-- Author:        Name
-- Create date:
-- Description:
-- =============================================
CREATE PROCEDURE [dbo].[HSQE_sp_ReportingCAWindOperatingTotals]
-- Add the parameters for the stored procedure here
@startdate DATE ,
@enddate DATE
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON ;

-- Insert statements for procedure here
SELECT DISTINCT ProjectName, SUM(RESHours + NonRESHours + RESSubHours) AS 'Total Man Hours',
CAST(ROUND(( ( ( SELECT COUNT(classid)
FROM   dbo.Safety s ,
vwProjectDropdown p
WHERE  s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN (1,2)
AND projectphase = 6
AND CountryCode = 'CAN'
AND classid = 1
) * 64
+ ( SELECT   COUNT(classid)
FROM     dbo.Safety s ,
vwProjectDropdown p
WHERE    s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN (1,2)
AND projectphase = 6
AND CountryCode = 'CAN'
AND classid = 2
) * 16
+ ( SELECT   COUNT(classid)
FROM     dbo.Safety s ,
vwProjectDropdown p
WHERE    s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN (1,2)
AND projectphase = 6
AND CountryCode = 'CAN'
AND classid = 3
) * 4
+ ( SELECT   COUNT(classid)
FROM     dbo.Safety s ,
vwProjectDropdown p
WHERE    s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN (1,2)
AND projectphase = 6
AND CountryCode = 'CAN'
AND classid = 4
) * 1 ) * 1000 / SUM(RESHours + NonRESHours
+ RESSubHours) ), 2) AS DECIMAL(16,
2)) AS 'Monthly RES SSI w/o NM' ,
CAST(ROUND(( ( ( SELECT COUNT(classid)
FROM   dbo.Safety s ,
vwProjectDropdown p
WHERE  s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN (1,2)
AND projectphase = 6
AND CountryCode = 'CAN'
AND classid = 1
)
+ ( SELECT   COUNT(classid)
FROM     dbo.Safety s ,
vwProjectDropdown p
WHERE    s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN (1,2)
AND projectphase = 6
AND CountryCode = 'CAN'
AND classid = 2
) ) * 200000 / SUM(RESHours + NonRESHours
+ RESSubHours) ), 2) AS DECIMAL(16,
2)) AS 'Monthly TRIR' ,
(SELECT COUNT(classid) FROM dbo.Safety WHERE classid = 1 AND projectnumber = p.projectid) AS 'Lost Time Accident',
(SELECT COUNT(classid) FROM dbo.Safety WHERE classid = 2 AND projectnumber = p.projectid) AS 'Recordable Injury',
(SELECT COUNT(classid) FROM dbo.Safety WHERE classid = 3 AND projectnumber = p.projectid) AS 'Non Recordable Injury',
(SELECT COUNT(classid) FROM dbo.Safety WHERE classid = 4 AND projectnumber = p.projectid) AS 'Property or Equiment Damage',
(SELECT COUNT(classid) FROM dbo.Safety WHERE classid = 5 AND projectnumber = p.projectid) AS 'Near Miss',
(SELECT COUNT(classid) FROM dbo.Safety WHERE projectnumber = p.projectid) AS 'Total'
FROM dbo.Safety s
INNER JOIN dbo.SafetyClass c
ON s.ClassID = c.ClassID
INNER JOIN vwProjectDropdown p
ON s.ProjectNumber = p.ProjectID
LEFT OUTER JOIN dbo.ManHours m
ON m.ProjectNumber = s.ProjectNumber
WHERE projecttypeid IN (1,2)
AND projectphase = 6 AND CountryCode = 'CAN' AND s.isCurrent = 1
AND (s.DateIncident >= @startdate AND s.DateIncident <= @enddate)
GROUP BY projectname, projectid
END

GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
PRINT N'Creating [dbo].[HSQE_sp_ReportingCASolarOperatingTotals]'
GO

-- =============================================
-- Author:        Name
-- Create date:
-- Description:
-- =============================================
CREATE PROCEDURE [dbo].[HSQE_sp_ReportingCASolarOperatingTotals]
-- Add the parameters for the stored procedure here
@startdate DATE ,
@enddate DATE
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON ;

-- Insert statements for procedure here
SELECT DISTINCT ProjectName, SUM(RESHours + NonRESHours + RESSubHours) AS 'Total Man Hours',
CAST(ROUND(( ( ( SELECT COUNT(classid)
FROM   dbo.Safety s ,
vwProjectDropdown p
WHERE  s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN (9)
AND projectphase = 6
AND CountryCode = 'CAN'
AND classid = 1
) * 64
+ ( SELECT   COUNT(classid)
FROM     dbo.Safety s ,
vwProjectDropdown p
WHERE    s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN (9)
AND projectphase = 6
AND CountryCode = 'CAN'
AND classid = 2
) * 16
+ ( SELECT   COUNT(classid)
FROM     dbo.Safety s ,
vwProjectDropdown p
WHERE    s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN (9)
AND projectphase = 6
AND CountryCode = 'CAN'
AND classid = 3
) * 4
+ ( SELECT   COUNT(classid)
FROM     dbo.Safety s ,
vwProjectDropdown p
WHERE    s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN (9)
AND projectphase = 6
AND CountryCode = 'CAN'
AND classid = 4
) * 1 ) * 1000 / SUM(RESHours + NonRESHours
+ RESSubHours) ), 2) AS DECIMAL(16,
2)) AS 'Monthly RES SSI w/o NM' ,
CAST(ROUND(( ( ( SELECT COUNT(classid)
FROM   dbo.Safety s ,
vwProjectDropdown p
WHERE  s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN (9)
AND projectphase = 6
AND CountryCode = 'CAN'
AND classid = 1
)
+ ( SELECT   COUNT(classid)
FROM     dbo.Safety s ,
vwProjectDropdown p
WHERE    s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN (9)
AND projectphase = 6
AND CountryCode = 'CAN'
AND classid = 2
) ) * 200000 / SUM(RESHours + NonRESHours
+ RESSubHours) ), 2) AS DECIMAL(16,
2)) AS 'Monthly TRIR' ,
(SELECT COUNT(classid) FROM dbo.Safety WHERE classid = 1 AND projectnumber = p.projectid) AS 'Lost Time Accident',
(SELECT COUNT(classid) FROM dbo.Safety WHERE classid = 2 AND projectnumber = p.projectid) AS 'Recordable Injury',
(SELECT COUNT(classid) FROM dbo.Safety WHERE classid = 3 AND projectnumber = p.projectid) AS 'Non Recordable Injury',
(SELECT COUNT(classid) FROM dbo.Safety WHERE classid = 4 AND projectnumber = p.projectid) AS 'Property or Equiment Damage',
(SELECT COUNT(classid) FROM dbo.Safety WHERE classid = 5 AND projectnumber = p.projectid) AS 'Near Miss',
(SELECT COUNT(classid) FROM dbo.Safety WHERE projectnumber = p.projectid) AS 'Total'
FROM dbo.Safety s
INNER JOIN dbo.SafetyClass c
ON s.ClassID = c.ClassID
INNER JOIN vwProjectDropdown p
ON s.ProjectNumber = p.ProjectID
LEFT OUTER JOIN dbo.ManHours m
ON m.ProjectNumber = s.ProjectNumber
WHERE projecttypeid IN (9)
AND projectphase = 6 AND CountryCode = 'CAN' AND s.isCurrent = 1
AND (s.DateIncident >= @startdate AND s.DateIncident <= @enddate)
GROUP BY projectname, projectid
END

GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
PRINT N'Creating [dbo].[HSQE_sp_ReportingUSSolarOperatingTotals]'
GO

-- =============================================
-- Author:        Name
-- Create date:
-- Description:
-- =============================================
CREATE PROCEDURE [dbo].[HSQE_sp_ReportingUSSolarOperatingTotals]
-- Add the parameters for the stored procedure here
@startdate DATE ,
@enddate DATE
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON ;

-- Insert statements for procedure here
SELECT DISTINCT ProjectName, SUM(RESHours + NonRESHours + RESSubHours) AS 'Total Man Hours',
CAST(ROUND(( ( ( SELECT COUNT(classid)
FROM   dbo.Safety s ,
vwProjectDropdown p
WHERE  s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN (9)
AND projectphase = 6
AND CountryCode = 'USA'
AND classid = 1
) * 64
+ ( SELECT   COUNT(classid)
FROM     dbo.Safety s ,
vwProjectDropdown p
WHERE    s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN (9)
AND projectphase = 6
AND CountryCode = 'USA'
AND classid = 2
) * 16
+ ( SELECT   COUNT(classid)
FROM     dbo.Safety s ,
vwProjectDropdown p
WHERE    s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN (9)
AND projectphase = 6
AND CountryCode = 'USA'
AND classid = 3
) * 4
+ ( SELECT   COUNT(classid)
FROM     dbo.Safety s ,
vwProjectDropdown p
WHERE    s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN (9)
AND projectphase = 6
AND CountryCode = 'USA'
AND classid = 4
) * 1 ) * 1000 / SUM(RESHours + NonRESHours
+ RESSubHours) ), 2) AS DECIMAL(16,
2)) AS 'Monthly RES SSI w/o NM' ,
CAST(ROUND(( ( ( SELECT COUNT(classid)
FROM   dbo.Safety s ,
vwProjectDropdown p
WHERE  s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN (9)
AND projectphase = 6
AND CountryCode = 'USA'
AND classid = 1
)
+ ( SELECT   COUNT(classid)
FROM     dbo.Safety s ,
vwProjectDropdown p
WHERE    s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN (9)
AND projectphase = 6
AND CountryCode = 'USA'
AND classid = 2
) ) * 200000 / SUM(RESHours + NonRESHours
+ RESSubHours) ), 2) AS DECIMAL(16,
2)) AS 'Monthly TRIR' ,
(SELECT COUNT(classid) FROM dbo.Safety WHERE classid = 1 AND projectnumber = p.projectid) AS 'Lost Time Accident',
(SELECT COUNT(classid) FROM dbo.Safety WHERE classid = 2 AND projectnumber = p.projectid) AS 'Recordable Injury',
(SELECT COUNT(classid) FROM dbo.Safety WHERE classid = 3 AND projectnumber = p.projectid) AS 'Non Recordable Injury',
(SELECT COUNT(classid) FROM dbo.Safety WHERE classid = 4 AND projectnumber = p.projectid) AS 'Property or Equiment Damage',
(SELECT COUNT(classid) FROM dbo.Safety WHERE classid = 5 AND projectnumber = p.projectid) AS 'Near Miss',
(SELECT COUNT(classid) FROM dbo.Safety WHERE projectnumber = p.projectid) AS 'Total'
FROM dbo.Safety s
INNER JOIN dbo.SafetyClass c
ON s.ClassID = c.ClassID
INNER JOIN vwProjectDropdown p
ON s.ProjectNumber = p.ProjectID
LEFT OUTER JOIN dbo.ManHours m
ON m.ProjectNumber = s.ProjectNumber
WHERE projecttypeid IN (9)
AND projectphase = 6 AND CountryCode = 'USA' AND s.isCurrent = 1
AND (s.DateIncident >= @startdate AND s.DateIncident <= @enddate)
GROUP BY projectname, projectid
END

GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
PRINT N'Creating [dbo].[HSQE_sp_ReportingEnvironmentalTotals]'
GO

-- =============================================
-- Author:        Name
-- Create date:
-- Description:
-- =============================================
CREATE PROCEDURE [dbo].[HSQE_sp_ReportingEnvironmentalTotals]
-- Add the parameters for the stored procedure here
@startdate DATE ,
@enddate DATE
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON ;

-- Insert statements for procedure here
SELECT
SUM(RESHours + NonRESHours + RESSubHours) AS 'Total Man Hours' ,
CAST(ROUND(( ( ( SELECT COUNT(classid)
FROM   dbo.Environmental s ,
vwProjectDropdown p
WHERE  s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
--AND ProjectTypeID IN ( 1, 2, 9 )
--AND projectphase IN ( 5, 6 )
AND classid = 1
) * 64
+ ( SELECT   COUNT(classid)
FROM     dbo.Environmental s ,
vwProjectDropdown p
WHERE    s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
--AND ProjectTypeID IN ( 1, 2, 9 )
--AND projectphase IN ( 5, 6 )
AND classid = 2
) * 16
+ ( SELECT   COUNT(classid)
FROM     dbo.Environmental s ,
vwProjectDropdown p
WHERE    s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
--AND ProjectTypeID IN ( 1, 2, 9 )
--AND projectphase IN ( 5, 6 )
AND classid = 3
) * 4
+ ( SELECT   COUNT(classid)
FROM     dbo.Environmental s ,
vwProjectDropdown p
WHERE    s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
--AND ProjectTypeID IN ( 1, 2, 9 )
--AND projectphase IN ( 5, 6 )
AND classid = 4
) * 1 ) * 1000 / SUM(RESHours + NonRESHours
+ RESSubHours) ), 2) AS DECIMAL(15,
2)) AS 'Monthly RES SSI w/o NM' ,
CAST(ROUND(( ( ( SELECT COUNT(classid)
FROM   dbo.Environmental s ,
vwProjectDropdown p
WHERE  s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
--AND ProjectTypeID IN ( 1, 2, 9 )
--AND projectphase IN ( 5, 6 )
AND classid = 1
)
+ ( SELECT   COUNT(classid)
FROM     dbo.Environmental s ,
vwProjectDropdown p
WHERE    s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
--AND ProjectTypeID IN ( 1, 2, 9 )
--AND projectphase IN ( 5, 6 )
AND classid = 2
) ) * 200000 / SUM(RESHours + NonRESHours
+ RESSubHours) ), 2) AS DECIMAL(15,
2)) AS 'Monthly TRIR' ,
( SELECT    COUNT(DISTINCT projectnumber)
FROM      dbo.Environmental s ,
vwProjectDropdown p
WHERE     s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
--AND ProjectTypeID IN ( 1, 2, 9 )
--AND projectphase IN ( 5, 6 )
) AS projectcount ,
( SELECT    COUNT(classid)
FROM      dbo.Environmental s ,
vwProjectDropdown p
WHERE     s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
--AND ProjectTypeID IN ( 1, 2, 9 )
--AND projectphase IN ( 5, 6 )
AND classid = 1
) AS 'Major Incident' ,
( SELECT    COUNT(classid)
FROM      dbo.Environmental s ,
vwProjectDropdown p
WHERE     s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
--AND ProjectTypeID IN ( 1, 2, 9 )
--AND projectphase IN ( 5, 6 )
AND classid = 2
) AS 'Minor Incident' ,

( SELECT    COUNT(classid)
FROM      dbo.Environmental s ,
vwProjectDropdown p
WHERE     s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
--AND ProjectTypeID IN ( 1, 2, 9 )
--AND projectphase IN ( 5, 6 )
AND classid = 3
) AS 'Near Miss' ,
( SELECT    COUNT(classid)
FROM      dbo.Environmental s ,
vwProjectDropdown p
WHERE     s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
--AND ProjectTypeID IN ( 1, 2, 9 )
--AND projectphase IN ( 5, 6 )
) AS 'Total'
FROM    dbo.Environmental s
INNER JOIN vwProjectDropdown p ON s.ProjectNumber = p.ProjectID
LEFT OUTER JOIN dbo.ManHours m ON s.ProjectNumber = m.ProjectNumber
WHERE   s.isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ( m.WeekEnding >= @startdate
AND WeekEnding <= @enddate
)
END

GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
PRINT N'Creating [dbo].[HSQE_sp_ReportingOfficesEnvSubTotals]'
GO

-- =============================================
-- Author:        Name
-- Create date:
-- Description:
-- =============================================
CREATE PROCEDURE [dbo].[HSQE_sp_ReportingOfficesEnvSubTotals]
-- Add the parameters for the stored procedure here
@startdate DATE ,
@enddate DATE
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON ;

-- Insert statements for procedure here
SELECT DISTINCT OfficeName,
(SELECT COUNT(classid) FROM dbo.Environmental WHERE classid = 1 AND o.OfficeLocationID = s.OfficeLocationID) AS 'Lost Time Accident',
(SELECT COUNT(classid) FROM dbo.Environmental WHERE classid = 2 AND o.OfficeLocationID = s.OfficeLocationID) AS 'Recordable Injury',
(SELECT COUNT(classid) FROM dbo.Environmental WHERE classid = 3 AND o.OfficeLocationID = s.OfficeLocationID) AS 'Non Recordable Injury',
(SELECT COUNT(classid) FROM dbo.Environmental WHERE classid = 4 AND OfficeLocationID = o.OfficeLocationID) AS 'Property or Equiment Damage',
(SELECT COUNT(classid) FROM dbo.Environmental WHERE classid = 5 AND OfficeLocationID = o.OfficeLocationID) AS 'Near Miss',
(SELECT COUNT(classid) FROM dbo.Environmental WHERE OfficeLocationID = o.OfficeLocationID) AS 'Total'
FROM dbo.Environmental s, dbo.SafetyClass c, dbo.OfficeLocations o
WHERE s.ClassID = c.ClassID
AND o.OfficeLocationID = s.OfficeLocationID
AND s.isCurrent = 1
AND (s.DateIncident >= @startdate AND s.DateIncident <= @enddate)
END

GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
PRINT N'Creating [dbo].[HSQE_sp_ReportingOfficesEnvTotals]'
GO

-- =============================================
-- Author:        Name
-- Create date:
-- Description:
-- =============================================
CREATE PROCEDURE [dbo].[HSQE_sp_ReportingOfficesEnvTotals]
-- Add the parameters for the stored procedure here
@startdate DATE ,
@enddate DATE
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON ;

-- Insert statements for procedure here
SELECT COUNT(officename),
(SELECT COUNT(classid) FROM dbo.Environmental WHERE classid = 1) AS 'Lost Time Accident',
(SELECT COUNT(classid) FROM dbo.Environmental WHERE classid = 2) AS 'Recordable Injury',
(SELECT COUNT(classid) FROM dbo.Environmental WHERE classid = 3) AS 'Non Recordable Injury',
(SELECT COUNT(classid) FROM dbo.Environmental WHERE classid = 4) AS 'Property or Equiment Damage',
(SELECT COUNT(classid) FROM dbo.Environmental WHERE classid = 5) AS 'Near Miss',
(SELECT COUNT(classid) FROM dbo.Environmental) AS 'Total'
FROM dbo.Environmental s, dbo.SafetyClass c, dbo.OfficeLocations o
WHERE s.ClassID = c.ClassID
AND o.OfficeLocationID = s.OfficeLocationID
AND s.isCurrent = 1
AND (s.DateIncident >= @startdate AND s.DateIncident <= @enddate)
END

GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
PRINT N'Creating [dbo].[HSQE_sp_ReportingOfficesSafetyTotals]'
GO

-- =============================================
-- Author:        Name
-- Create date:
-- Description:
-- =============================================
CREATE PROCEDURE [dbo].[HSQE_sp_ReportingOfficesSafetyTotals]
-- Add the parameters for the stored procedure here
@startdate DATE ,
@enddate DATE
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON ;

-- Insert statements for procedure here
SELECT COUNT(officename),
(SELECT COUNT(classid) FROM dbo.Safety WHERE classid = 1) AS 'Lost Time Accident',
(SELECT COUNT(classid) FROM dbo.Safety WHERE classid = 2) AS 'Recordable Injury',
(SELECT COUNT(classid) FROM dbo.Safety WHERE classid = 3) AS 'Non Recordable Injury',
(SELECT COUNT(classid) FROM dbo.Safety WHERE classid = 4) AS 'Property or Equiment Damage',
(SELECT COUNT(classid) FROM dbo.Safety WHERE classid = 5) AS 'Near Miss',
(SELECT COUNT(classid) FROM dbo.Safety) AS 'Total'
FROM dbo.Safety s, dbo.SafetyClass c, dbo.OfficeLocations o
WHERE s.ClassID = c.ClassID
AND o.OfficeLocationID = s.OfficeLocationID
AND s.isCurrent = 1
AND (s.DateIncident >= @startdate AND s.DateIncident <= @enddate)
END

GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
PRINT N'Creating [dbo].[HSQE_sp_ReportingSignificantSafety]'
GO

-- =============================================
-- Author:        Name
-- Create date:
-- Description:
-- =============================================
CREATE PROCEDURE [dbo].[HSQE_sp_ReportingSignificantSafety]
-- Add the parameters for the stored procedure here
@startdate DATE ,
@enddate DATE
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON ;

-- Insert statements for procedure here
SELECT ProjectName,OfficeName, NarrativeIncident, ActionToCorrect, ActionToPrevent
FROM dbo.Safety s
LEFT OUTER JOIN dbo.vwProjectDropdown p
ON s.ProjectNumber = p.ProjectID
LEFT OUTER JOIN dbo.OfficeLocations o
ON s.OfficeLocationID = o.OfficeLocationID
WHERE SignificantNearMiss = 1
AND (s.DateIncident >= @startdate AND s.DateIncident <= @enddate)
ORDER BY ProjectName, OfficeName
END

GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
PRINT N'Creating [dbo].[HSQE_sp_ReportingSignificantEnv]'
GO

-- =============================================
-- Author:        Name
-- Create date:
-- Description:
-- =============================================
CREATE PROCEDURE [dbo].[HSQE_sp_ReportingSignificantEnv]
-- Add the parameters for the stored procedure here
@startdate DATE ,
@enddate DATE
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON ;

-- Insert statements for procedure here
SELECT projectname, OfficeName, NarrativeIncident, ActionCorrect, ActionPrevent
FROM dbo.Environmental s
LEFT OUTER JOIN dbo.vwProjectDropdown p
ON s.ProjectNumber = p.ProjectID
LEFT OUTER JOIN dbo.OfficeLocations o
ON s.OfficeLocationID = o.OfficeLocationID
WHERE SignificantNearMiss = 1
AND (s.DateIncident >= @startdate AND s.DateIncident <= @enddate)
ORDER BY ProjectName, OfficeName
END

GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
PRINT N'Creating [dbo].[HSQE_sp_ReportingSafetyIncidentDetails]'
GO

-- =============================================
-- Author:        Name
-- Create date:
-- Description:
-- =============================================
CREATE PROCEDURE [dbo].[HSQE_sp_ReportingSafetyIncidentDetails]
-- Add the parameters for the stored procedure here
@startdate DATE ,
@enddate DATE
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON ;

-- Insert statements for procedure here
SELECT ProjectName,OfficeName, NarrativeIncident, ActionToCorrect, ActionToPrevent, c.Description AS classification
FROM dbo.Safety s
INNER JOIN dbo.SafetyClass c
ON s.ClassID = c.ClassID
LEFT OUTER JOIN dbo.vwProjectDropdown p
ON s.ProjectNumber = p.ProjectID
LEFT OUTER JOIN dbo.OfficeLocations o
ON s.OfficeLocationID = o.OfficeLocationID
WHERE (s.DateIncident >= @startdate AND s.DateIncident <= @enddate)
AND s.ClassID <> 5
ORDER BY ProjectName, OfficeName
END

GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
PRINT N'Creating [dbo].[HSQE_sp_ReportingEnvIncidentDetails]'
GO

-- =============================================
-- Author:        Name
-- Create date:
-- Description:
-- =============================================
CREATE PROCEDURE [dbo].[HSQE_sp_ReportingEnvIncidentDetails]
-- Add the parameters for the stored procedure here
@startdate DATE ,
@enddate DATE
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON ;

-- Insert statements for procedure here
SELECT ProjectName,OfficeName, NarrativeIncident, ActionCorrect, ActionPrevent, c.Description AS classification
FROM dbo.Environmental s
INNER JOIN dbo.SafetyClass c
ON s.ClassID = c.ClassID
LEFT OUTER JOIN dbo.vwProjectDropdown p
ON s.ProjectNumber = p.ProjectID
LEFT OUTER JOIN dbo.OfficeLocations o
ON s.OfficeLocationID = o.OfficeLocationID
WHERE (s.DateIncident >= @startdate AND s.DateIncident <= @enddate)
AND s.ClassID <> 3
ORDER BY ProjectName, OfficeName
END

GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
PRINT N'Creating [dbo].[HSQE_sp_ReportingFarmTotals]'
GO

-- =============================================
-- Author:        Name
-- Create date:
-- Description:
-- =============================================
CREATE PROCEDURE [dbo].[HSQE_sp_ReportingFarmTotals]
-- Add the parameters for the stored procedure here
@startdate DATE ,
@enddate DATE
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON ;

-- Insert statements for procedure here
SELECT  COUNT(projectname) ,
SUM(RESHours + NonRESHours + RESSubHours) AS 'Total Man Hours' ,
CAST(ROUND(( ( ( SELECT COUNT(classid)
FROM   dbo.Safety s ,
vwProjectDropdown p
WHERE  s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN ( 1, 2, 9 )
AND projectphase IN ( 5, 6 )
AND classid = 1
) * 64
+ ( SELECT   COUNT(classid)
FROM     dbo.Safety s ,
vwProjectDropdown p
WHERE    s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN ( 1, 2, 9 )
AND projectphase IN ( 5, 6 )
AND classid = 2
) * 16
+ ( SELECT   COUNT(classid)
FROM     dbo.Safety s ,
vwProjectDropdown p
WHERE    s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN ( 1, 2, 9 )
AND projectphase IN ( 5, 6 )
AND classid = 3
) * 4
+ ( SELECT   COUNT(classid)
FROM     dbo.Safety s ,
vwProjectDropdown p
WHERE    s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN ( 1, 2, 9 )
AND projectphase IN ( 5, 6 )
AND classid = 4
) * 1 ) * 1000 / SUM(RESHours + NonRESHours
+ RESSubHours) ), 2) AS DECIMAL(15,
2)) AS 'Monthly RES SSI w/o NM' ,
CAST(ROUND(( ( ( SELECT COUNT(classid)
FROM   dbo.Safety s ,
vwProjectDropdown p
WHERE  s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN ( 1, 2, 9 )
AND projectphase IN ( 5, 6 )
AND classid = 1
)
+ ( SELECT   COUNT(classid)
FROM     dbo.Safety s ,
vwProjectDropdown p
WHERE    s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN ( 1, 2, 9 )
AND projectphase IN ( 5, 6 )
AND classid = 2
) ) * 200000 / SUM(RESHours + NonRESHours
+ RESSubHours) ), 2) AS DECIMAL(15,
2)) AS 'Monthly TRIR' ,
( SELECT    COUNT(DISTINCT projectnumber)
FROM      dbo.Safety s ,
vwProjectDropdown p
WHERE     s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN ( 1, 2, 9 )
AND projectphase IN ( 5, 6 )
) AS projectcount ,
( SELECT    COUNT(classid)
FROM      dbo.Safety s ,
vwProjectDropdown p
WHERE     s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN ( 1, 2, 9 )
AND projectphase IN ( 5, 6 )
AND classid = 1
) AS 'Lost Time Accident' ,
( SELECT    COUNT(classid)
FROM      dbo.Safety s ,
vwProjectDropdown p
WHERE     s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN ( 1, 2, 9 )
AND projectphase IN ( 5, 6 )
AND classid = 2
) AS 'Recordable Injury' ,
( SELECT    COUNT(classid)
FROM      dbo.Safety s ,
vwProjectDropdown p
WHERE     s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN ( 1, 2, 9 )
AND projectphase IN ( 5, 6 )
AND classid = 3
) AS 'Non Recordable Injury' ,
( SELECT    COUNT(classid)
FROM      dbo.Safety s ,
vwProjectDropdown p
WHERE     s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN ( 1, 2, 9 )
AND projectphase IN ( 5, 6 )
AND classid = 4
) AS 'Property or Equiment Damage' ,
( SELECT    COUNT(classid)
FROM      dbo.Safety s ,
vwProjectDropdown p
WHERE     s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN ( 1, 2, 9 )
AND projectphase IN ( 5, 6 )
AND classid = 5
) AS 'Near Miss' ,
( SELECT    COUNT(classid)
FROM      dbo.Safety s ,
vwProjectDropdown p
WHERE     s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN ( 1, 2, 9 )
AND projectphase IN ( 5, 6 )
) AS 'Total'
FROM    dbo.Safety s
INNER JOIN vwProjectDropdown p ON s.ProjectNumber = p.ProjectID
LEFT OUTER JOIN dbo.ManHours m ON s.ProjectNumber = m.ProjectNumber
WHERE   s.isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ( m.WeekEnding >= @startdate
AND WeekEnding <= @enddate
)
END

GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
PRINT N'Creating [dbo].[HSQE_sp_ReportingUSWindConstructionTotals]'
GO

-- =============================================
-- Author:        Name
-- Create date:
-- Description:
-- =============================================
CREATE PROCEDURE [dbo].[HSQE_sp_ReportingUSWindConstructionTotals]
-- Add the parameters for the stored procedure here
@startdate DATE ,
@enddate DATE
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON ;

-- Insert statements for procedure here
SELECT DISTINCT ProjectName, SUM(RESHours + NonRESHours + RESSubHours) AS 'Total Man Hours',
CAST(ROUND(( ( ( SELECT COUNT(classid)
FROM   dbo.Safety s ,
vwProjectDropdown p
WHERE  s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN (1,2)
AND projectphase = 5
AND CountryCode = 'USA'
AND classid = 1
) * 64
+ ( SELECT   COUNT(classid)
FROM     dbo.Safety s ,
vwProjectDropdown p
WHERE    s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN (1,2)
AND projectphase = 5
AND CountryCode = 'USA'
AND classid = 2
) * 16
+ ( SELECT   COUNT(classid)
FROM     dbo.Safety s ,
vwProjectDropdown p
WHERE    s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN (1,2)
AND projectphase = 5
AND CountryCode = 'USA'
AND classid = 3
) * 4
+ ( SELECT   COUNT(classid)
FROM     dbo.Safety s ,
vwProjectDropdown p
WHERE    s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN (1,2)
AND projectphase = 5
AND CountryCode = 'USA'
AND classid = 4
) * 1 ) * 1000 / SUM(RESHours + NonRESHours
+ RESSubHours) ), 2) AS DECIMAL(15,
2)) AS 'Monthly RES SSI w/o NM' ,
CAST(ROUND(( ( ( SELECT COUNT(classid)
FROM   dbo.Safety s ,
vwProjectDropdown p
WHERE  s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN (1,2)
AND projectphase = 5
AND CountryCode = 'USA'
AND classid = 1
)
+ ( SELECT   COUNT(classid)
FROM     dbo.Safety s ,
vwProjectDropdown p
WHERE    s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
AND ProjectTypeID IN (1,2)
AND projectphase = 5
AND CountryCode = 'USA'
AND classid = 2
) ) * 200000 / SUM(RESHours + NonRESHours
+ RESSubHours) ), 2) AS DECIMAL(15,
2)) AS 'Monthly TRIR' ,
(SELECT COUNT(classid) FROM dbo.Safety WHERE classid = 1 AND projectnumber = p.projectid) AS 'Lost Time Accident',
(SELECT COUNT(classid) FROM dbo.Safety WHERE classid = 2 AND projectnumber = p.projectid) AS 'Recordable Injury',
(SELECT COUNT(classid) FROM dbo.Safety WHERE classid = 3 AND projectnumber = p.projectid) AS 'Non Recordable Injury',
(SELECT COUNT(classid) FROM dbo.Safety WHERE classid = 4 AND projectnumber = p.projectid) AS 'Property or Equiment Damage',
(SELECT COUNT(classid) FROM dbo.Safety WHERE classid = 5 AND projectnumber = p.projectid) AS 'Near Miss',
(SELECT COUNT(classid) FROM dbo.Safety WHERE projectnumber = p.projectid) AS 'Total'
FROM dbo.Safety s
INNER JOIN dbo.SafetyClass c
ON s.ClassID = c.ClassID
INNER JOIN vwProjectDropdown p
ON s.ProjectNumber = p.ProjectID
LEFT OUTER JOIN dbo.ManHours m
ON m.ProjectNumber = s.ProjectNumber
WHERE projecttypeid IN (1,2)
AND projectphase = 5 AND CountryCode = 'USA' AND s.isCurrent = 1
AND (s.DateIncident >= @startdate AND s.DateIncident <= @enddate)
GROUP BY projectname, projectid
END

GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
PRINT N'Creating [dbo].[HSQE_sp_ReportingEnvironmentalSubTotals]'
GO

-- =============================================
-- Author:        Name
-- Create date:
-- Description:
-- =============================================
CREATE PROCEDURE [dbo].[HSQE_sp_ReportingEnvironmentalSubTotals]
-- Add the parameters for the stored procedure here
@startdate DATE ,
@enddate DATE
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON ;

-- Insert statements for procedure here
SELECT DISTINCT ProjectName, SUM(RESHours + NonRESHours + RESSubHours) AS 'Total Man Hours',
CAST(ROUND(( ( ( SELECT COUNT(classid)
FROM   dbo.Environmental s ,
vwProjectDropdown p
WHERE  s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
--AND ProjectTypeID IN (9)
--AND projectphase = 6
--AND CountryCode = 'USA'
AND classid = 1
) * 64
+ ( SELECT   COUNT(classid)
FROM     dbo.Environmental s ,
vwProjectDropdown p
WHERE    s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
--AND ProjectTypeID IN (9)
--AND projectphase = 6
--AND CountryCode = 'USA'
AND classid = 2
) * 16
+ ( SELECT   COUNT(classid)
FROM     dbo.Environmental s ,
vwProjectDropdown p
WHERE    s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
--AND ProjectTypeID IN (9)
--AND projectphase = 6
--AND CountryCode = 'USA'
AND classid = 3
) * 4
+ ( SELECT   COUNT(classid)
FROM     dbo.Environmental s ,
vwProjectDropdown p
WHERE    s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
--AND ProjectTypeID IN (9)
--AND projectphase = 6
--AND CountryCode = 'USA'
AND classid = 4
) * 1 ) * 1000 / SUM(RESHours + NonRESHours
+ RESSubHours) ), 2) AS DECIMAL(16,
2)) AS 'Monthly RES SSI w/o NM' ,
CAST(ROUND(( ( ( SELECT COUNT(classid)
FROM   dbo.Environmental s ,
vwProjectDropdown p
WHERE  s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
--AND ProjectTypeID IN (9)
--AND projectphase = 6
--AND CountryCode = 'USA'
AND classid = 1
)
+ ( SELECT   COUNT(classid)
FROM     dbo.Environmental s ,
vwProjectDropdown p
WHERE    s.ProjectNumber = p.ProjectID
AND isCurrent = 1
AND ( s.DateIncident >= @startdate
AND s.DateIncident <= @enddate
)
--AND ProjectTypeID IN (9)
--AND projectphase = 6
--AND CountryCode = 'USA'
AND classid = 2
) ) * 200000 / SUM(RESHours + NonRESHours
+ RESSubHours) ), 2) AS DECIMAL(16,
2)) AS 'Monthly TRIR' ,
(SELECT COUNT(classid) FROM dbo.Environmental WHERE classid = 1 AND projectnumber = p.projectid) AS 'Major Incident',
(SELECT COUNT(classid) FROM dbo.Environmental WHERE classid = 2 AND projectnumber = p.projectid) AS 'Minor Incident',
(SELECT COUNT(classid) FROM dbo.Environmental WHERE classid = 3 AND projectnumber = p.projectid) AS 'Near Miss',
(SELECT COUNT(classid) FROM dbo.Safety WHERE projectnumber = p.projectid) AS 'Total'
FROM dbo.Environmental s
INNER JOIN dbo.EnvironmentalClass c
ON s.ClassID = c.ClassID
INNER JOIN vwProjectDropdown p
ON s.ProjectNumber = p.ProjectID
LEFT OUTER JOIN dbo.ManHours m
ON m.ProjectNumber = s.ProjectNumber
WHERE s.isCurrent = 1
--projecttypeid IN (9)
--AND projectphase = 6 AND CountryCode = 'USA' AND
AND (s.DateIncident >= @startdate AND s.DateIncident <= @enddate)
GROUP BY projectname, projectid
END

GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
PRINT N'Creating [dbo].[HSQE_sp_ReportingOfficesSafetySubTotals]'
GO

-- =============================================
-- Author:        Name
-- Create date:
-- Description:
-- =============================================
CREATE PROCEDURE [dbo].[HSQE_sp_ReportingOfficesSafetySubTotals]
-- Add the parameters for the stored procedure here
@startdate DATE ,
@enddate DATE
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON ;

-- Insert statements for procedure here
SELECT DISTINCT OfficeName,
(SELECT COUNT(classid) FROM dbo.Safety WHERE classid = 1 AND o.OfficeLocationID = s.OfficeLocationID) AS 'Lost Time Accident',
(SELECT COUNT(classid) FROM dbo.Safety WHERE classid = 2 AND o.OfficeLocationID = s.OfficeLocationID) AS 'Recordable Injury',
(SELECT COUNT(classid) FROM dbo.Safety WHERE classid = 3 AND o.OfficeLocationID = s.OfficeLocationID) AS 'Non Recordable Injury',
(SELECT COUNT(classid) FROM dbo.Safety WHERE classid = 4 AND OfficeLocationID = o.OfficeLocationID) AS 'Property or Equiment Damage',
(SELECT COUNT(classid) FROM dbo.Safety WHERE classid = 5 AND OfficeLocationID = o.OfficeLocationID) AS 'Near Miss',
(SELECT COUNT(classid) FROM dbo.Safety WHERE OfficeLocationID = o.OfficeLocationID) AS 'Total'
FROM dbo.Safety s, dbo.SafetyClass c, dbo.OfficeLocations o
WHERE s.ClassID = c.ClassID
AND o.OfficeLocationID = s.OfficeLocationID
AND s.isCurrent = 1
AND (s.DateIncident >= @startdate AND s.DateIncident <= @enddate)
END

GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
PRINT N'Altering permissions on [dbo].[HSQE_sp_ReportingFarmTotals]'
GO
GRANT EXECUTE ON  [dbo].[HSQE_sp_ReportingFarmTotals] TO [resgroup\softwareusers]
GO
PRINT N'Altering permissions on [dbo].[HSQE_sp_ReportingConstructionTotals]'
GO
GRANT EXECUTE ON  [dbo].[HSQE_sp_ReportingConstructionTotals] TO [resgroup\softwareusers]
GO
PRINT N'Altering permissions on [dbo].[HSQE_sp_ReportingOperatingTotals]'
GO
GRANT EXECUTE ON  [dbo].[HSQE_sp_ReportingOperatingTotals] TO [resgroup\softwareusers]
GO
PRINT N'Altering permissions on [dbo].[HSQE_sp_ReportingUSWindConstructionTotals]'
GO
GRANT EXECUTE ON  [dbo].[HSQE_sp_ReportingUSWindConstructionTotals] TO [resgroup\softwareusers]
GO
PRINT N'Altering permissions on [dbo].[HSQE_sp_ReportingCAWindConstructionTotals]'
GO
GRANT EXECUTE ON  [dbo].[HSQE_sp_ReportingCAWindConstructionTotals] TO [resgroup\softwareusers]
GO
PRINT N'Altering permissions on [dbo].[HSQE_sp_ReportingUSSolarConstructionTotals]'
GO
GRANT EXECUTE ON  [dbo].[HSQE_sp_ReportingUSSolarConstructionTotals] TO [resgroup\softwareusers]
GO
PRINT N'Altering permissions on [dbo].[HSQE_sp_ReportingCASolarConstructionTotals]'
GO
GRANT EXECUTE ON  [dbo].[HSQE_sp_ReportingCASolarConstructionTotals] TO [resgroup\softwareusers]
GO
PRINT N'Altering permissions on [dbo].[HSQE_sp_ReportingUSWindOperatingTotals]'
GO
GRANT EXECUTE ON  [dbo].[HSQE_sp_ReportingUSWindOperatingTotals] TO [resgroup\softwareusers]
GO
PRINT N'Altering permissions on [dbo].[HSQE_sp_ReportingCAWindOperatingTotals]'
GO
GRANT EXECUTE ON  [dbo].[HSQE_sp_ReportingCAWindOperatingTotals] TO [resgroup\softwareusers]
GO
PRINT N'Altering permissions on [dbo].[HSQE_sp_ReportingCASolarOperatingTotals]'
GO
GRANT EXECUTE ON  [dbo].[HSQE_sp_ReportingCASolarOperatingTotals] TO [resgroup\softwareusers]
GO
PRINT N'Altering permissions on [dbo].[HSQE_sp_ReportingUSSolarOperatingTotals]'
GO
GRANT EXECUTE ON  [dbo].[HSQE_sp_ReportingUSSolarOperatingTotals] TO [resgroup\softwareusers]
GO
PRINT N'Altering permissions on [dbo].[HSQE_sp_ReportingEnvironmentalSubTotals]'
GO
GRANT EXECUTE ON  [dbo].[HSQE_sp_ReportingEnvironmentalSubTotals] TO [resgroup\softwareusers]
GO
PRINT N'Altering permissions on [dbo].[HSQE_sp_ReportingEnvironmentalTotals]'
GO
GRANT EXECUTE ON  [dbo].[HSQE_sp_ReportingEnvironmentalTotals] TO [resgroup\softwareusers]
GO
PRINT N'Altering permissions on [dbo].[HSQE_sp_ReportingOfficesSafetySubTotals]'
GO
GRANT EXECUTE ON  [dbo].[HSQE_sp_ReportingOfficesSafetySubTotals] TO [resgroup\softwareusers]
GO
PRINT N'Altering permissions on [dbo].[HSQE_sp_ReportingOfficesEnvSubTotals]'
GO
GRANT EXECUTE ON  [dbo].[HSQE_sp_ReportingOfficesEnvSubTotals] TO [resgroup\softwareusers]
GO
PRINT N'Altering permissions on [dbo].[HSQE_sp_ReportingOfficesEnvTotals]'
GO
GRANT EXECUTE ON  [dbo].[HSQE_sp_ReportingOfficesEnvTotals] TO [resgroup\softwareusers]
GO
PRINT N'Altering permissions on [dbo].[HSQE_sp_ReportingOfficesSafetyTotals]'
GO
GRANT EXECUTE ON  [dbo].[HSQE_sp_ReportingOfficesSafetyTotals] TO [resgroup\softwareusers]
GO
PRINT N'Altering permissions on [dbo].[HSQE_sp_ReportingSignificantSafety]'
GO
GRANT EXECUTE ON  [dbo].[HSQE_sp_ReportingSignificantSafety] TO [resgroup\softwareusers]
GO
PRINT N'Altering permissions on [dbo].[HSQE_sp_ReportingSignificantEnv]'
GO
GRANT EXECUTE ON  [dbo].[HSQE_sp_ReportingSignificantEnv] TO [resgroup\softwareusers]
GO
PRINT N'Altering permissions on [dbo].[HSQE_sp_ReportingSafetyIncidentDetails]'
GO
GRANT EXECUTE ON  [dbo].[HSQE_sp_ReportingSafetyIncidentDetails] TO [resgroup\softwareusers]
GO
PRINT N'Altering permissions on [dbo].[HSQE_sp_ReportingEnvIncidentDetails]'
GO
GRANT EXECUTE ON  [dbo].[HSQE_sp_ReportingEnvIncidentDetails] TO [resgroup\softwareusers]
GO
IF EXISTS (SELECT * FROM #tmpErrors) ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT>0 BEGIN
PRINT 'The database update succeeded'
COMMIT TRANSACTION
END
ELSE PRINT 'The database update failed'
GO
DROP TABLE #tmpErrors
GO

Filed under: sql server administration No Comments
25Apr/12Off

grant execute on stored procedure

GRANT EXECUTE ON OBJECT::dbo.spname
TO "domain\user";
GO

Filed under: sql server administration, sql sever syntax No Comments
25Jan/12Off

location of svcutil.exe

C:\Program Files\Microsoft SDKs\Windows\v7.0A\bin

Filed under: web dev No Comments
24Jan/12Off

visual studio clean solution

to clean out dll associated with project (this helps to keep things running smoothly and cleanly) --

on visual studio web developer express --
make sure that Tools --> Settings --> Expert Settings is chosen

then choose Build --> Clean

Filed under: web dev No Comments
24Jan/12Off

visual studio caching

to clear the cache --  this helps if the cs file can't find the asp controls
C:\Documents and Settings\Administrator\Local Settings\Temp\VWDWebCache

and possibly here

C:\Documents and Settings\Administrator\Local Settings\Application Data\Microsoft\WebsiteCache

Filed under: web dev No Comments
13Jan/12Off

lmhosts file

The Lmhosts file is located in the %SystemRoot%\System32\Drivers\Etc folder on a Windows computer. There is also a sample Lmhosts file (Lmhosts.sam) in this folder.

Sample Lmhosts File
142.25.125.15 Joe #PRE
129.102.12.10 Paul #PRE
148.107.16.45 James
135.25.25.14 Eric #PRE
133.120.26.225 John
192.36.14.250 Ed #PRE
221.250.05.126 Mackey

Filed under: network administration No Comments
5Jan/12Off

Visual Studio copying and compiling lesson learned

If you want to copy code, this is fine, but don't compile before modifying to your purposes first. Otherwise you will get a "Object reference not set to an instance of an object." error.

Filed under: web dev No Comments
3Jan/12Off

.net compiling errors

Tip: Solving error “Could not load type” in Visual Studio
If you copy or import code from one Visual Studio 2008 project to another, for instance the aspx, ascx or master files, then you may receive the above error and it may take ages before you find out that the solution is extraordinarily simple:

change CodeBehind in CodeFile

The following example shows that for a Web UserControl, but it works the same for a Page, a Master Page and a WebPart:


<%@ Control Language="C#" AutoEventWireup="true"
CodeFile="WebUserControl.ascx.cs"
Inherits="Controls_WebUserControl" %>


<%@ Control Language="C#" AutoEventWireup="true"
CodeBehind="WebUserControl.ascx.cs"
Inherits="Controls_WebUserControl" %>That’s all you need to do to get rid of that annoying error!

The reason? If you have an “ASP.NET Web Application”, Microsoft needs CodeBehind in the Page, Control or Master directive, if you have an “ASP.NET Web Site”, the compiler expects CodeFile instead. I have no idea why this difference exists, it is very annoying and you can stare forever at your code before you find it, but this is the solution for this scenario.

Filed under: web dev No Comments
   Older Entries »

Recent Posts

Categories

Archives

Calendar

May 2012
M T W T F S S
« Apr    
 123456
78910111213
14151617181920
21222324252627
28293031  

Meta

Blogroll