Fantastic. Thats just what I thought.

I was wondering how percentages dealt with.

Percentage of children with registrations by month

Rolls up to

Percentage of children with registrations by year

With this being none...

Whoops sorry about that.

I used an old create table script and didnt finish it properly.

Thanks for the advice. I think I used MIN, MAX and then grabbed the other ID...

Thats right so I eventually get 1 row of data instead of 4

fi Id Alias

118007, 'Sara Jane smith/Sarah Smith/Sara Jayne Smith/Sara Smith'

Im keeping my fingers...

Thanks :ermm:

I think the best thing I can do is try to figure out another simpler way, Im out of my league a bit here.

Im hoping there may be dates...

Ahhhh

Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows NT 5.1 (Build...

Im on SQL Server 2005.

Is there another way around this issue without using Partition?

Debbie

Thanks for that. Ive tried it but Im getting

Msg 195, Level 15, State 10, Line 1

'ROW_NUMBER' is not a recognized function name.

Debbie

Jeffrey Williams (12/9/2008)

---

Grant Fritchey (12/9/2008)

---

Instead of shrinking the database at the beginning of the process, I'd suggest growing the log out to the necessary size and making sure that it's...

Nicholas Cain (12/9/2008)

---

Does the job run all the procedures within a single transaction?

You could run a profile when the job is running, include the errors and warnings as well as...

Thanks for all the advice.

What Im going to do is split up each stored procedure into lots of little seperate procedures. I currently have 2 in the job and it...

Jerry Hung (12/9/2008)

---

How much disk space is there for the log drive?

Also, does the log have restricted max size?

Any other maint. tasks like reindexing etc? that would cause the log...

Hmmmm,

So does that mean you can have NULL Foreign keys?

E.g.

PersonID AttID PupilinSystem PupilswithAttinSystem

1 ...

Ah ha,

All sorted it was because in dbo.ECAFALL there were 10 rows where Person was NULL. This caused the error with that Person ID. I clear the NULLs up first...

excellent,

It worked perfectly apart from one wierd kink. I just ran this script to check the results are OK...

SELECT tblpupil, LEFT(CAF_FIRST_FORM,1)AS CAF_No,COUNT(*)AS NO_OF_EPS

FROM ECAFALL

WHERE tblPUPIL IS NOT NULL

GROUP BY...

12054ECAFSTD 4968152007-08-29 13:37:35.923 2007-08-29 13:38:15.357 1.1

12054ECAFMTG 4968202007-08-29 13:41:17.713 2008-02-12 13:38:11.180 1.2...