Hi

As it turns out two of the datefields returns NULL values. They are not supposed to do so, but they do.

So I have added an isnull function and now it...

Hi.

I missed those two fields in my code yes

But even when I add them it does not appear to give the result I need.

select-- count([LOAD_ID])

[LOAD_ID]

...

Hi

Sorry for late reply. 🙂 Days just fly by.

I have created a key for each record by simply concatenating each field.

I have then made an archive table and now I...

Hi.

Thanks that works.

BR

Dan

My bad 🙂 I ment Order by, not group by.

Here is the complete code

SELECT

x.[Route],

T1."To license number. (/TO_LIC)" as TO_LIC,

T1."From license number." AS FROM_LIC,

...

ChrisM@Work: I have never used cross apply before. Will have to study that one.

I see you placed an group by...

Is this needed or optional.

I am trying your version now, withoute...

Unfortunately the log file is full again.

Stopping all jobs again. 🙁

Dan

Thanks for your reply.

I have now read the article and see that I have used part of this.

I did use the DBCC OPENTRAN to find the correct spid.

But I used...

Hi all. Thanks for your reply.

We now have the entire system up running. More or less.

And I did it without downtime at all.

With regards to the log drive setup, I...

Hi

Well I am still working on this.

I have managed to attach my catalog database. I kept all three datafiles. Two are stored on one drive and the third pluss...

Hi.

I found the solution to this problem.

I had to change some properties on my databases.

Found my solution here:

http://social.msdn.microsoft.com/Forums/en/sqlnetfx/thread/2465ac11-735c-4362-8da4-1ed672b0e261

I had to set all my databases trustworthy with this code...

of course...

Sorry..

--drop view dbo.jobber_siste_dag

create view dbo.jobber_siste_dag -- view that aggregates jobs and set min/max timestamp

as

select

distinct

job_id as jobb, -- job

[run_date] as dato, -- date

run_status as status,

min(convert(datetime,rtrim(run_date))+ (run_time*9+run_time%10000*6+run_time%100*10+25*run_duration)/216e4) as min_tid,

max(convert(datetime,rtrim(run_date))+...

Hi.

Yes I found some scripts here that I could use, but none that seem to solve this problem.

Dan

Hi again

Trying to use a function to solve this.

USE MASTER

CREATE FUNCTION Getweek (@DATE datetime)

RETURNS int

WITH EXECUTE AS CALLER

AS

BEGIN

DECLARE @weeknumber int;

SET...

Brandie.

I had to ad the file name at the end.

Dan