Thank you everyone. I am still working on this.

The code

SELECT s.ROW_ID, DATEADD(MINUTE,ISNULL(x.UTC_OFFSET,0),s.Created)

FROM S_SRV_REQ S

LEFT JOIN (SELECT TOP 1 tt.UTC_OFFSET, TT.START_DT

FROM S_TIMEZONE T

JOIN S_TIMEZONE_TEMP TT

ON T.ROW_ID =...

The error message returned from executing the SELECT above with the DATEADD function is:

Msg 174, Level 15, State 1, Line 1

The dateadd function requires 3 argument(s).

Msg 156, Level 15, State...

This query was a simple example of how we would use the function.

We are aquiring companies around teh world and for UTC we need to have one time zone. ...

Yes I do have an execution plan. Please see attached zipped file that includes the execution plan

Thank you everyone. I appreciate this

This query:

SELECT ROW_ID, CREATED, dbo.ConvertGMTToEST(CREATED)

FROM S_SRV_REQ S

returns 959,970 rows in 48 seconds

This query:

SELECT ROW_ID, CREATED

FROM S_SRV_REQ S

returns 959,970 rows in 4 seconds

Want to know how to speed up the function....

THE ABSOLUTE 100% CORRECT ANSWER TO THIS PROBLE IS:

TURN OFF WINDOWS FIIREWALL.

THANK YOU ALL FOR RESPONDING, BUT I GOT THE ANSWER

Gila,

I have no idea what this query is suppose to do. It is generated by Siebel for a report that is used by the marketing team based on Campaign History...

Simple, straight forward, and to the point.

But in my opinion it should not be called reserved space. It should be called "Total Space Used Up by table and related objects...

YOU HIT THE NAIL MRIGHT ON THE HEAD, Thank you so much.

I removed the "UN-NEEDED" UPPER clauses and BINGO, query runs in 3 seconds. Returns the ssame...

Don't think teh UPPER has anything to do with it.

If I comment out the joing:

LEFT OUTER JOIN SW_ORD_LIST_EXT OLE ON (UPPER(BH.ORDER_NO) = UPPER(OLE.ORDER_NO) AND BDTL.LINE_NO = OLE.LINE_NO)

The entire query runs...

Yes I did that and it does work, but it does not save any time off the execution. I do thank everyone for their assistance. I hope I can get...

I do that but the save part is grayed out. I am using 2005 Management Studio with SQL Server 2000.

And I am doing that because I installed teh development tools...

How do you save the execution plan in SQL server 2000 using Management Studio?

Sort order is the same in both Latin1 General CIAS

Your modification changed my 41 seconds to 1 minute and 5 seconds. The table SW_Booking_Setup always has ONE row...

Just ran that same query in our old environemnt (SQL SERVER 2000) and it ran in 41 seconds returning 40,000+ rows. Same query plan, same data.

No need to include...