Forum Replies Created

Viewing 15 posts - 1,846 through 1,860 (of 2,452 total)

  • RE: database base design for sports database

    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...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: Recursive Golf to-par calculation

    pixelwiz (8/3/2012)


    WOW. I guess there is no simple way to do this...

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

    ...no doubt there are other ways 🙂

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: Recursive Golf to-par calculation

    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...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: Recursive Golf to-par calculation

    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...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: Recursive Golf to-par calculation

    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...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: Recursive Golf to-par calculation

    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...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: Recursive Golf to-par calculation

    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"...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: Stacia

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

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: I want to delete those data from tables Orders and customers which is not selecting in below join

    forsqlserver (7/23/2012)


    I have lakh of rows to be deleted in this table it will full my log file...

    I want to use top in delete statement..

    whats the total number of rows...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: Remove records with NULL returned from Dynamic Pivot query

    tobinare (7/22/2012)


    J Livingston SQL (7/22/2012)


    one idea...not performance tested

    Thank's, I like your solution and I never would have thought of it.

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

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: Remove records with NULL returned from Dynamic Pivot query

    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,...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: Combine two similar rows into one row with an extra field

    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...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: Stripping off the time

    krypto69 (7/9/2012)


    when what I want is:

    1984-08-13

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

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: Update records

    Krasavita (7/9/2012)


    Here is my steps in detail.

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

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: Can i INSERT a Column at the beginning?

    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...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

Viewing 15 posts - 1,846 through 1,860 (of 2,452 total)