Do you have a single index which covers both Tracking NO and Branch NO?

yes, thank you so much.

Do you know the password?

Search this site for "excel password protected". You'll find plenty of forum posts.

In SQL Server 2005 a datetime field contains both date and time.

So this will extract the hour out of a datetime field-DATEPART(hour,Timestart)

Are you trying to control the flow of code...

Sorry sent the last reply off too soon.

You'll probably need the CASE expression.

http://msdn.microsoft.com/en-us/library/ms181765.aspx

CREATE TABLE #TEST

(TimeStart datetime)

INSERT INTO #TEST VALUES ('2010-05-10 00:30:00')

INSERT INTO #TEST VALUES ('2010-05-10 14:30:00')

SELECT

'ActDate'...

You'll prbably need the CASE expression.

http://msdn.microsoft.com/en-us/library/ms181765.aspx

SELECT

'ActDate' =

>>Most of the actual SQL code is generated & issued by a 3rd party application

So does this 3rd party support 2008?

Yes looks good. Thanks!!

Hello Cold Coffee and thanks.

No its not getting my desired results. The SELECT statement for the INSERT should return these records:

A,5

C,1

These are the records in #ListUpdate that are not in...

ColdCoffee (5/3/2010)

---

I dint exactly understand what you wnat to do, but as far i could comprehend from your post, here is a set of code that might interest you.

quote]

So I...

I would perform a search on "SQL server float vs decimal" to see if float will work for you. I am not an expert by any means on this subject...

If you don't have access to the mail administrator...

Hi,

A few thoughts. Your mail server/gateway may have limitations on the number of recipients as an anti-spam measure. If your mail admin is available I would ask. Can you send...

I think you can use OPENROWSET for this.

You should be able...