I think I have solved it what do you all think?

SELECT D.DPSITE, SUM(A.DPCRFF), SUM(A.DPMJFF),        

SUM(A.DPMNFF), SUM(A.DPTTGA), SUM(A.DPTTFP),          

SUM(A.DPTTGI) FROM WSTSTDATA/DPSITE D LEFT OUTER JOIN 

WSTSTDATA/DPHEADER A ON D.DPSITE = A.DPSITE...

sorry pressed enter half wat through writting this post. cont.... This command is saying cannot back up the log. But i do not want to back it up just truncate...

what I have done is this

exec xp_cmdshell 'net use x: \\servername\share password /user:domain\administrator', NO_OUTPUT

exec xp_cmdshell 'copy /Y X:\file.xls d:\directoryname', NO_OUTPUT

exec xp_cmdshell 'net use x: /del', NO_OUTPUT

it seems to work...

SO WE ARE SAYING THAT IS NOT THE WAY TO GO?

Do you think this is a good idea?

create procedure MySP

@var varchar(20) = '%_%'

as

Select * from news_items

where division = @var

What do you think?

Sam, see if this works

select t_Retail.Pcde6P from t_Retail

where exists

(SELECT

t_Retail.Pcde6P,

Count(*) AS Total

FROM t_Retail

WHERE

LEN (TRIM(t_Retail.Pcde6P)) = 6

GROUP BY

t_Retail.Pcde6P

HAVING

Count(t_Retail.Pcde6P) > 2)

Is this what you are looking for. This will give...

I have tried this but it needs to be on the whole record. Each column may have numberous records that are the same but the whole record should be unique...

I have created this script that seems to have solved the problem. It takes about 5 mins to run at the end of my daily processes on a 12GB database

SET...

Thanks Rajesh

This has worked and has got the report back to 2 mins. I have not set the DB to auto update I have scripted it into the extraction, so...

Thanks Scorpion_66

I am looking into unique identifier's but it has deleted 1500 records but comes back with that error when I try to delete 17000 records

aLSO i HAVE ONLY SETUP LINKED SERVERS IN ENTERPRISE MANAGER NOTHING ELSE

I CAN PERFORM THE SELECT AND IT COMES BACK WITH 17000 RECORDS. i HAVE RETRIED JUST DELETING ONE RECORD AND IT HAS WORKED i MUST OF DONE SOMTHING WRONG. IT...

Thanks for your help Jeremy

However I have spoken to our AS400 DBA and he said that the table has no foreign keys and I have tried deleting only one...

Thanks for your response. I am quite new to T-SQL so if the is a better way to do what I am doing please advise. How do I put this...