With reference to gljjr reply:

Will it make much of a difference if "REP.BS_BSREF = 318515 AND MT_DATE >= '2003-11-29 00:00:00.000'" is moved into the...

Have a look at http://www.w3schools.com/ado/ado_datatypes.asp

What is the timeout setting for ODBC connection?

In principle I'll rather stick to Allen_Cui solution.

Row 1 ColA='A' and ColB='A'

Row 2 ColA='AA' and ColB=''

set nocount on

if exists (select * from dbo.sysobjects where id =...

Which question

Have a look at http://www.sqlservercentral.com/scripts/contributions/445.asp.

Need to add the fact that your are interested in ProductID only, not all foreign keys.

Excellent idea!

Used to do a lot of Joe Celko puzzles for training purposes(1997).

Could not wait to get to work to compare their solution with mine!

Any comments on the actual formal evaluation process of the applicants? Specially the first three seconds with the face to face interview!

May help a bit.

http://dbforums.com/arch/176/2002/6/407350

Can you post the actual output

BOL 2000:

WITH TIES

Specifies that additional rows be returned from the base result set with the same value in the ORDER BY columns appearing as the last of the TOP n...

Not the best/efficient solution but how about adding another column to the top/outer select ,(Select top 1 Sectioname from Table t1 where t1.duration=Min(Duration) and t1.col1=event.id) as MinDuration

Not the complete statement...

BOL 2000: Error 1204

http://dbforums.com/arch/30/2003/7/855149

You are more than welcome.

Any change of populating the table

Have a look at the following url and select a country/zone.

http://www.poremsky.com/timezones.htm