At this time, just "Insert".

INSERT INTO OrderReceived

(OrderNumber,

 DateReceived)

 SELECT OrderNumber, min(DateReceived) FROM OrderDetail

 GROUP BY OrderNumber

This works fine!!! thanks.

But if you can provide sql for doing 'both, inserting where not already...

Yes, I want to update the OrderReceived table from the OrderDetail table.

I need one record each for the Order Nmber with the earliest Received Date.

Your insert code only returns "One"...

I think I found my anwser:

INSERT INTO tblCatalog ( Product_ID, img )

SELECT Product_Id, rtrim(Pattern) + '-' + rtrim(Color) + '.jpg' as img

FROM dbo.Product_Dimension

great, that works just fine...thanks..

now the img has the following data:

"FSP   -01    .jpg"

I need the data to be "FSP-01.jpg"

Thanks for the feedback...being a newbie, can you provide the steps to check for runaway statements.  I use task managar to view processes but how to check runaway statements....also how...

I can ping using the name; the server is not in a DMZ....When I use the cmd 'telnet servername 1433', could not open connection to host using port

Thanks for everyone's feedback...hopefully the new yukon DTS will be able to replace my current ETL software....

Thanks to everyone help.  Have a nice holiday!

Thanks again for that script information about the datetime stamp!!

By the way, how often should master and msdb be backed up; I currently back up our User Databases once a...

THANK YOU!!

Thanks for all the information!

I was trying to use a statement that I can use on an AS400:

select * from cptipdta/seams where date(ctime)='2004-05-17' 

but that does not work on a SQL...

When running the wizard to create the target table, the primary key contraint goes away.

In the prompt "Specify Table Copy or Query", three options are available:

1. Copy Tables and views...

Yes, I am using the wizard.  Initially, the target table does not exits.

Once the target table is created, I delete the records and add the keys.

Then I use the wizard...

Hi, Chris...

You had already provided the sql statement:

Use master

go

exec sp_kill @dbname='dbname'

Use master

go

alter database dbname

set SINGLE_USER

But when I run it, I get:

Could not find stored procedure 'sp_kill'.

What is the...

Hi Chris,

Please help me one more time, can you please provide the script for "sp_kill" as I think it is a User Procedure?

Thanks,  Richard