are you sure it runs fine manually have you tested with the same data roll the data back and then run tried as a scheduled job?

EEEK a cursor within a cursor, do you have any representative data and tables that we can use to view your code and test any sugestions we have.

Prehaps we can...

HI, so if the cursor fails at some point when run on its own, sounds like this needs addressing first, Next in a stored proc if you set set xact...

HI

you would get week 52 not 0

HI, well im not sure if you can change the system variable to get what you want however if norway are 1 week behind you could use dateadd to take...

Just out of interest how do you work out that today should be week 25?

Alter your clause to look like this and it should work ok, you had your when in the wrong location

case ISNULL(org.is_round,1) when 1 THEN

...

HI,

looking at your tables and the information you requested here is some basic syntax for a simple SP you will might want to pad it out a little

Also, if we...

HI, why would you have a table with colors with the same ID for multiple colours?

this would give you the results for 1 person you just need to follow it...

Hi looking at your query would i be correct in saying that the results that are returned are not what you expected?

its always easier to work out what your query...

Hi

This is not ideal but you could look to do the following

declare @date datetime

set @date='2011-06-21 20:03:01.450'

select cast( @date as varchar),substring(cast( @date as varchar),charindex(':',cast( @date as varchar))+1,2)

i agree with the others left outer joins may be needed, do you have any examples tables and representative data, it would be easier to help you with this information

Hi, IM going to make an aussmption here that each time you run the script for each school you change

WHERE students.schoolid=6049142

Have you tried using the IN clause?

WHERE students.schoolid...

HI, i am not too sure what you mean either however, looking at your set statement it might be worth you looking up CASE statements

for example i have a test...

HI, try looking up variable temp tables, as i understand it these work from memory however, i do think that there is a limit to the amount of data that...