Thanks for the info, but it didn't help in my case. Maybe a different version?

On my system SELECT @@VERSION returns:

Microsoft SQL Server 2005 - 9.00.3073.00 (X64)

Aug 5 2008...

Hello,

what exactly is your problem?

You know where data about the jobs is stored so you should be able to calculate the average.

SELECT job.[name] as Job, his.step_id, his.step_name,

MAX(his.run_duration) as Max_duration,...

To do this should be fairly easy... just write the query with corresponding GROUP BY and WHERE clause, join it back to the table and run the update (I'll help...

Hello Joseph,

I'm not saying this often, but IMHO your requirement should be solved in the front-end, not with SQL server. SQL server will prepare you the data, and some other...

BOL says:

"When a row is modified through a view, the WITH CHECK OPTION makes sure the data remains visible through the view after the modification is committed."

and

"CHECK constraints reject values...

I agree that there are some inconsistencies about NULL values, but maybe you will understand it better if you look at it from another side. Two NULL values are not...

Hi,

that's simple, just add these columns:

SELECT Number, Name, Jan+Feb+March+April as Total

FROM yourtable

If this is not the correct solution, please explain what is the problem with it.

If you want to know when the log file will become smaller, the answer is never, unless you explicitly shrink it. This can be done using the tools of Management...

Use CONVERT with the correct style (probably 121 would do) and length, and then REPLACE delimiters if you don't want them in the result.

As I understood it, @startposition tells you where to start -...

I see that Christopher already posted the solution with Tally table, so just try to tweak the parameters there to suit your needs...

BTW, there seems to be some problem with...

As a quick solution, I would use this:

/*Create environment*/

create table #test(did int, id int, myval int)

/*create test data*/

insert into #test(did, id, myval)

SELECT 1, 1, 2

UNION SELECT 1,2,12

UNION SELECT 1,3,45

UNION SELECT...

Hmm... And what if @startposition is 2 and @endposition 3?

Does that mean you skip rows with 1 altogether and only need sums of rows with ID 2+3, 3+4, 4+5, 5+6,...

Linson.Daniel (2/11/2009)

---

Now at one glance I feel that if all you require is the output based on your two paramenters then there is a function which you could make use...

OK, I will describe the solution, because the code loses great part when I try to post it, probably everything between "less than" and "greater than". Strange, never happened to...