kranthi.india123 (8/3/2012)

---

Hey Hi friends,

please Help me on How to design the Sports database for online games or live games????

give me some idea about online sports games.(footbal or cricket ,golf,tennis,basketball..etc).....please...

but it is pretty fast...even with the data set ups

...no doubt there are other ways 🙂

some further code that demos' 312 players over 4 rounds and formats display output..

hope it gives you some ideas...

regards

--=== 312 players over four rounds of 18 holes

--=== as an...

pixelwiz (7/27/2012)

---

Hello J Livingston SQL,

No, I don't play golf, but I know a whole lot about properly scoring golf tournaments, because I'm in charge of building and running the...

pixelwiz (7/27/2012)

---

Ok, I've done running totals before, and I also thought it would be that or Recursive CTE.

But what I can't visualize in my head is how do I make...

Sean Lange (7/27/2012)

---

J Livingston SQL (7/27/2012)

---

Sean Lange (7/27/2012)

---

OK now we all have the same code to work from. Nice job posting readily consumable ddl and sample data. What I don't...

maybe I misunderstand what you are trying to accomplish....but surely all we need to consider is a running total of shots played in comparison against the running total of 'par"...

http://www.sqlskills.com/blogs/stacia/

whats the total number of rows...

its probably only one of many ways.....only you can judge...

one idea...not performance tested

CREATE TABLE [dbo].[StockQuote](

[ID] [int] IDENTITY(1,1) NOT NULL,

[xSymbol] [varchar](10) NOT NULL,

[xDate] [int] NOT NULL,

[xClose] [decimal](18, 4) NOT NULL,

)

-- Put some data into the table

INSERT INTO StockQuote (xSymbol,...

as a start... lets assume you have something like this...at the moment we have nothing to work with.

is this anywhere close to being representative of your data?

pls amend accordingly and...

is this for reporting purposes ...or are you expecting to perform further calculations on the result?

think your post has been mislaid....nothing here

Andy Hyslop (7/9/2012)

---

It's a little extra work, but I always try to add a new column 'in the right place' where applicable. I concede that it doesn't actually make any...