Sorry, thought I got all of them.

Here is the be_xref_oa

USE [NMS_CFG]

GO

/****** Object: Table [dbo].[be_xref_oa] Script Date: 04/22/2010 14:51:34 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[be_xref_oa](

[base_equip_address] [float]...

Here is the ATCS_Group

USE [NMS_CFG]

GO

/****** Object: Table [dbo].[ATCS_Group] Script Date: 04/22/2010 14:15:36 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[ATCS_Group](

[Group_Address] [float] NOT NULL,

[Subregion] [int] NULL,

[Line_Address]...

Looks like I still have a problem with the Parameter type.

I am passing the parameter from asp.net to the SP. When I run in the debugger I get an error...

That is what I was looking for. I appologize for not asking it well.

Thank you very much!

Duh! It has been one of those weeks. Thank you very much. That made it work exactly as I wanted it.

Brian

Your right. I grabbed the wrong copy.

And here is the revised code. It completes however it still sends the email out;

USE NMS_RT

IF EXISTS(SELECT 1

FROM RT_MCP_Historic_Alarms

WHERE [RT_MCP_Date_Time] >= Convert(char(10), DateADD(DAY, -1,...

Yes, it was the correct database. I can take the original code, open a new query and past the original code into it and it completes fine.

When I execute the query, it returns this;

Msg 207, Level 16, State 1, Line 14

Invalid column name 'RT_MCP_Name'.

Msg 207, Level 16, State 1, Line 15

Invalid column name 'RT_MCP_State'.

Msg 207, Level...

Lowell are you saying it should look like this then;

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

USE NMS_RT

IF EXISTS(SELECT 1

FROM RT_MCP_Historic_Alarms

WHERE [RT_MCP_Date_Time] >= Convert(char(10), DateADD(DAY, -1, GETDATE()), 101) AND [RT_MCP_Date_Time] 0

GROUP BY RT_MCP_Name, RT_MCP_State, RT_MCP_Alarm_Text, RT_MCP_Bit_State,...