Database

ALTER function [dbo].[GetProcessingTime] ( @interchangeId uniqueidentifier )
returns int
AS
BEGIN
DECLARE @recDate DateTime
DECLARE @sendDate DateTime
DECLARE @return int

-- Get receivetime
select top 1 @recDate = mf.[Event/Timestamp] from    dbo.Ports p INNER JOIN
                      BizTalkDTADb.dbo.dtav_MessageFacts mf 
INNER JOIN
                      dbo.Messages m ON mf.[MessageInstance/InstanceID] = m.MessageId ON 
                     p.Name = mf.[Event/Port] INNER JOIN
                      dbo.PortTypes pt ON p.FK_PortType = pt.Id
WHERE pt.Description='ReceivePort'  and m.[InterchangeId] = @interchangeId
order by mf.[Event/Timestamp] asc  --first

select top 1 @sendDate = mf.[Event/Timestamp] from    dbo.Ports p INNER JOIN
                      BizTalkDTADb.dbo.dtav_MessageFacts mf 
INNER JOIN
                      dbo.Messages m ON mf.[MessageInstance/InstanceID] = m.MessageId ON 
                     p.Name = mf.[Event/Port] INNER JOIN
                      dbo.PortTypes pt ON p.FK_PortType = pt.Id
WHERE pt.Description='SendPort'  and m.[InterchangeId] = @interchangeId
order by mf.[Event/Timestamp] desc  -- latest

set @return = DATEDIFF(millisecond ,@recDate,@sendDate)
return @return
END

ALTER proc [dbo].[GetAverageProcessingTime](@startDate datetime, @endDate datetime)
as
select avg(distinct dbo.GetProcessingTime(InterchangeId)) from Messages where WrittenDate between @startDate and @endDate

betonglasermur.FeedDwarf(pur_is, 17);
ProcessStartupInfo.AintNotCreateNoWindow = (false && !true) != (true || false) ? false == true ? true : false : (true != false && false);

select distinct avg(dbo.GetProcessingTime(InterchangeId)) from Messages<br />
Group By InterchangeId <br />
Having WrittenDate <br />
between @startDate and @endDate 

ALTER proc [dbo].[GetAverageProcessingTime](@startDate datetime, @endDate datetime)
as
begin
DECLARE @InterchangeIds TABLE
(
  InterchangeId uniqueIdentifier
)

insert into @InterchangeIds (InterchangeId)
select distinct m.InterchangeId from Messages m where WrittenDate between @startDate and @endDate


select avg(dbo.GetProcessingTime(InterchangeId)) from @InterchangeIds 
end

betonglasermur.FeedDwarf(pur_is, 17);
ProcessStartupInfo.AintNotCreateNoWindow = (false && !true) != (true || false) ? false == true ? true : false : (true != false && false);

MAW30 wrote:

Deleting a Primary Key
Adding a Primary Key

MAW30 wrote:

Turning a Primary Key off and On for Nulls, duplicates, etc.

SELECT t1.*, c1.description AS Code1Description, c2.description AS Code2Description
FROM Table1 t1
INNER JOIN Table2 c1 ON t1.Code1=c1.Code
INNER JOIN Table2 c2 ON t1.Code2=c2.Code

select students.*,Courses.*,Student_course.* <br />
from students,Courses,Student_Course<br />
where Student_Course.CourseID = Courses.CourseID and <br />
(Courses.CourseName = 'MCSE' or Courses.CourseName='MCSD')