• ps_vbdev (4/3/2013)


    stated in my post "When i bulk insert the csv i was using a case statement to apply a points based on the position field".

    the logic behind how the points are allocated is irrelevant to the problem i posted. which is how to deal with riders with same time during the data load, and even went to lengths

    to provide dummy data in my explanatory post

    I always find forum contributors that reply too posts picking up on spelling mistakes and asking irrelevant questions can never/don't have the ability to answer the problem posted. Now can you answered the question or are you just going to come back with a smart reply?

    🙂

    If you are such a smartass then why don't you solve the problem yourself??....Why do you need help from others?

    We frequent forums to help people who post questions and to learn from the solutions posted. People here take time out of their busy schedules to work out a working solution for posters like you. It is very difficult to just read an explanation about a requirement and work out a solution for it. There may be differences in what we understand and what you had actually meant. That is when we ask questions to know the exact requirement so that both the posters and our time isn't wasted.

    I asked the question of the logic behind your points calculation because in the Case statement where you are calculating the points you can use a variation of the function "RANK" to get things done.....but since you are too smart to post relevant answers and are more interested in whining about other things.......I'd suggest you go figure it out for yourself.

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉