Interesting. I have a reply-to address setup for my Database Mail profiles and it seems to work just fine. I'd be interested in hear what you find in...

Just curious, but what is wrong with the following code:

update dbo.TeamBalance set

Balance = Balance - @Purchase

where

TeamId = @TeamId

and...

Yea, not being very consistant on that am I. But I had some time...

It would help if you could provide the DDL for the tables, sample data in the form of an insert with unioned select statements.

Please, only provide enough detail to assist...

I'm not sure what problem you are having. Please review what I have done and tell me what I may have missed.

create table dbo.incspc_test (

incspc_type...

This is the original query, reformatted for easier reading with the

dirived table.

SELECT

RowID

FROM

dbo.del_duplicates Tbl1

Left Join (SELECT

...

Marvin,

The only reason I found that what I wrote was cleaner was I started to turn your derived table into a CTE and discovered the duplication in the query. ...

MD (3/20/2008)

---

Try this. It uses a derived tables which are one of the powers of 2005.

UPDATE CLIENT

SET PRODUCT_CODE = b.NEW_CODE

FROM CLIENT, (SELECT OLD_CODE, NEW_CODE FROM PRODUCTS_CODE, CLIENT WHERE OLD_CODE...

You mean something like this:

select

StartDate1,

StartDate2,

case when datediff(dd,StartDate1, StartDate2) <= 30

...

Okay, having several SQL Server 2000 systems here, I looked at the properties of a database on one of the SQL Server 2000 servers, and the only compatibilty modes availabe...

Run the following query on the server and post back the results:

select @@version

In SSMS, right click on the database, select properties. Select Options under Select a page. On the right side you should see a drop down box with the...

Are you running on SQL Server 2005 or SQL Server 2000?

Looks like you are missing something, not sure what. I haven't created any tables to allow me to test, so here is something for you to test:

ALTER PROCEDURE ...

Can't do a thing without seeing your code.

😎