So are you suggesting I run an MS Agent job to fire that DBCC proc every minute around the time of the backup and store the results into a database...

Sorry just realised this is currently an SQL 2005 DB not SQL 2008 but I am using the 2008 Management Studio to connect to it from my PC.

Also I am...

I don't know if you were just slow posting or didn't read my previous comment but that was exactly what I proposed doing e.g using a lookup table and removing...

I know about the problem with 2.50 being displayed as 6/4 and a myriad of other fractions e.g

6/4 2.50

9/6 ...

Sorry, the question was wrong.

As you can see from the code I posted I already have code to convert a fraction price 6/4 to decimal 2.50

What I need is the...

Thanks G!

I like it.

Don't worry there are lots of tables full of stats including jockey, trainer, course, draw bias and other form stats that are involved in calculating the ranking...

I totally get what you mean but its pretty hard to update say the FormRating for all runners in a race at one time as there are so many different...

I have narrowed down the code and found the culprit which was a UDF which was being used a lot within the various ranking functions and reports.

The functions aim is...

Jeff seeing you are an RBAR expert how would you approach the following;

It's related to the same database and basically for each runner in a race I have a number...

Cheers Jeff

I now get what you mean whereas I must admit before I must have misread your previous comment.

That would be a very good solution to my problem 🙂

Thanks

Hi Jeff

I could do a quirky UPDATE solution in the following way.

I have added an extra column to the @RACES table called usable (BIT) and then just filtered by that...

Thanks for the replies I will try and check the article when I can but I am assuming from your definition of Quirky Update you mean something like

UPDATE ...

Thanks for replying but that second solution still doesn't work.

If you add a few more records into the race table e.g

insert into @races

(racedatetime)

SELECT '2011-02-20 13:50:00'

UNION ALL

SELECT '2011-02-20 13:55:00'

UNION ALL

SELECT '2011-02-20...

Thanks for that. The KB article does explicitly mention the exact problem I was having

50000874 When the stored procedure runs outside an explicit transaction, a temporary...

Cheers for that Florian, I think that is the route to go down to prevent this from happening in future and I have modified my code to use non-named constraints...