another trick is that if you can get the data into excel, then you can add a additional calculated column for generating an insert statement

for example

= "insert into xxxx (col1,...

I had a similar problem once and I had to change a setting (I think it was the instance name) in the following config file

C:\Program Files\Microsoft SQL Server\90\DTS\Binn\MsDtsSrvr.ini.xml

David

If the stored procedure doesn't already exist then you will need to change the alter to a create at the top of the script.

Also, the select statement at the end...

It looks like the global variable link just uses a custom table anyway.

David

My attempt at using the pivot command is as follows...

select ufi_id,class,type, [CONSTCONTR], [CONSTDATE]

from

(select * from wastewater) w

PIVOT

( max(attribute_value)

FOR attribute_desc IN

([CONSTCONTR],[CONSTDATE])

) as PVT

ORDER BY ufi_id

I think personally I would convert the sql in the jobs into stored procedures.

Another option is to hold an override date in the registry and then use the...

can you provide an example?

If your jobs just call a stored procedure to do it's work then you could add a parameter to the procedure which is the "rundate". If the parameter isn't...

Thanks for the reply.

Out of interest, what is a good indicator that the statistics are out of date? Is it just that the estimated row counts are very wrong...

On the primary server we have the following set up

A folder called c:\sql\shipping_out which is then shared as shipping_out.

Does SQLServer have access to your c:\Backup folder?

David

I had a quick attempt by creating two additional tables, one holding a set of weeks, and another a set of numbers.

create table #weeks

( startdatedatetimenot null

)

insert into #weeks

select...

Fixed my own problem. It turns out to be nothing to do with sql.

Compiled regular expressions are very slow on 64bit.

http://www.bokebb.com/dev/english/1939/posts/193912680.shtml

the solution is to remove the...

Does this help?

WHERE

vs.CityTypeCode <> 'p'

AND

vs.ZipCode = 01062

David

Does using table aliases make any difference? (I know it shouldn't...)

select count(*) from import_cc_requests r where r.reference not in (select reference r2 from import_cc_payments r2 )

Could you add a space and ( to the where clause.

Something like

not like 'C# (%' and not like '%,C# (%'