Or this SQL Server 2005 way

SELECT

ID,

Sequence

,

Name

FROM

(

SELECT ID,

Sequence

TRIGGER?

Also try this if you don't want duplicates in the CODES

SELECT

DISTINCT s1.ID,

STUFF((SELECT

-- Prepare sample data

DECLARE

@Sample TABLE (ID INT, Code VARCHAR(

SELECT employeevoip ,

SUM(CASE WHEN Direction = 'INBOUND' THEN hours ELSE 0 END) AS...

An equivalent to GETDATE() is

CURRENT_TIMESTAMP

CREATE FUNCTION dbo.fnFriendsBetween

(

 @From VARCHAR(2),

 @To VARCHAR(2)

)

RETURNS INT

AS

BEGIN

 IF @From IS NULL OR @To IS NULL

  RETURN -1

 DECLARE @Friends TABLE (Generation INT, p VARCHAR(2))

 DECLARE @Generation INT

 SELECT @Generation = 0

You should use dbo.fnFriendsStep function found here

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=73079

It works quit fast and performs well.

//Peter Larsson

Or these two of mine

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=72097

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=73079

Have a look at my implementation of Dijkstra's algorithm posted here

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=77262

In this topic you tell use there is a present index for the 100,000 records returned?

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=338&messageid=352569

How do you store an email "not there"?

Empty string? NULL?

You already have an index on email column...

100,000 records for same email and password?

Something else is wrong besides long run-time! You should revise your business rules first.

-- Prepare sample data

DECLARE @Sample TABLE (Number INT)

INSERT @Sample

SELECT 1 UNION ALL

SELECT 10 UNION ALL

SELECT 12 UNION ALL

SELECT 17

-- Try 1

SELECT  LowLimit.Number + 1 AS FromNumber,

  (

   SELECT TOP 1 Number

   FROM  @Sample AS HighLimit

   WHERE  NOT EXISTS (

        SELECT B.Number

        FROM @Sample AS b

        WHERE HighLimit.Number - 1 = B.Number

      &nbsp