I will be leaving work shortly. I have a school event for my youngest followed with my hitting the High School pitch (got a JV game to officiate!).

Next week...

Okay, I used sp_send_dbmail to send an email to one of my coworkers, who replied to it, and it went just where I expected it to go, me. So...

Jack Corbett (3/21/2008)

---

A quick update. I switched to using gmail as the smtp server and still no joy on the Reply To setting.

Lynn,

What mail server are...

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...