Could you be more specific?  Please show us how this calculation should be done using the data you provided in your original post.

😎

Is the servername correct in your example using an UNC?  I just tried it on one of my servers and it works fine going down several directories.

Without seeing the code for the stored procedure, it is a guess.  It could be parameter sniffing at work.  Are you using the variables declared in the header of the...

Is the schedule still enabled?  it almost sounds like the schedule had an end date set so that it would not run after a specified date.

😎

Try this:

SELECT

    t.schoolc as School_Code,

    RTRIM(k.schname) as School,

    s.ident as Ident,

    RTRIM(s.lastname) + ', ' + RTRIM(s.firstname) AS Student,

    ss.graden as [Current Grade],

    left(sb.descript,20) as Subject,

    max(sc.testscore) as Score

FROM...

I use a Script Task to format the date for creating an archive subdirectory using a datestamp.  You can use the same mechanism to format the datetime stamp for...

Perhaps you'd like to explain the lack of large pices in the crash of flight 585 (hope I have the right flight number) that crashed in park less than 2...

As I said, go on believing what you want, based on everything I have seen and read, I don't believe anything that you have espoused is true.

Johan,

Go on believing what you want.  I have seen and read enough to know what you are espousing is untrue.

How many recrods are in #report when you run this update?  Also, how many records in TableA and TableB?  How are TableA and TableB indexed?

Based on what I have read, I think the answer to your question about there being a function that will return the datatype of an input; a table column in...

Don't confuse writing editorials with reporting of news events.  Editorials are a journalists opinion based on what ever facts they may (or may not) have found while researching a topic. ...

declare @startdate int,

           @enddate  int

set @startdate = datediff(dd, 0, '19980309') + 36161

set @enddate = datediff(dd, 0, '20000912') + 36161

select * from dbo.yourTable where date between @startdate and @enddate

First thing we need to know is how the integer date value is computed.  Looking at your data, I have no way of knowing what date 75505 (or any of...

>> IF Object_ID('tempdb..#fred') IS NOT NULL

This is where I will agree with you Sergiy.  Using the OBJECT_ID system function is better than using the system table directly.  I will...