Hi Ten,

Not really sure what you mean, as column 3 in your example I saw is g3.MatchType result3 e.g

DECLARE @TotalStake MONEY,
      ...

LOL Depends how much you invest Jeff...... 🙂

I was just trying find out if Jeff Moden was still on here, as I have not been on this site for a while and I do remember him always...

• This reply was modified 3 years, 7 months ago by  Rob Reid-246754. Reason: Edited some mis-spelt words in the reply

I don't think SQL should be allowed access to the web for security reasons.

I know you used to be able to, for some sort of internal validation process for certificates...

Where are all the SET Based Geniuses, Jeff Moden, I remember was one who said everything could be done in a set based solution.....

I don't know if this really can...

Yes the info for the proc is just background data after I have done hours of work, checking leagues, last game results, sores, prices on Betfair for each outcome and...

You want the schema for the table I printed off, and the stored proc code that tally's up the score, unfortunately it doesn't all fit in here or uploadable as...

• This reply was modified 3 years, 7 months ago by  Rob Reid-246754. Reason: It put the same proc params into the post twice for some reason

Thanks Pam that is the exact code I was looking for.

Great I can get it running to save DMV index recommendations. At the moment most of my tables have no...

Hi Brian,

I don't know if you noticed but I had to move the DB from a server to an SQL Express DB on my laptop.

The laptop wont be running 24/7...

Thanks,

I am pretty sure I got the code off a Microsoft blog years back when DMVS just came out (2005 or was it 2008? Cannot remember)

Whether they...

• This reply was modified 4 years, 5 months ago by  Rob Reid-246754.

As I said in the 1st post I don't automatically implement every recommendation. The DB was designed to just keep DMV data from missing index data over time as when...

Well I don't want to look through months of sql or event logs because I have no idea when the problem started and have no way of narrowing it down,...

Yes, I am always willing to blame a Windows Update for anything. Too many times I have had issues with my laptop and a restore to a point before the...

Hi thanks for your response.

I did not get any problems with the backup / restore, I simply SFTP'd the backup from a dedicated server to my local PC and then...

Thanks Jacob for the explanation.  I have a book I am reading on the history of gambling and how probability is worked out, I just got thrown by the trial...