Forum Replies Created

Viewing 14 posts - 1 through 14 (of 14 total)

  • RE: Help - New to T-SQL

    hmm trouble is each horse is different and needs a different form change. I can't see how to make it set based

    January 12, 2005 at 7:46 am

    #537040

  • RE: Help - New to T-SQL

    yeh sorry changed it to I so it does it for HorseID=@I
     
    thanks for the help, finally got it lol, and yeh does it row by row.

    January 11, 2005 at 11:40 am

    #536884

  • RE: Help - New to T-SQL

    Ok am back LOL, Here is my latest attempt:
     
    Declare @i as int

    Declare @LstHrse as int

    set @i = 0

    set @LstHrse = 'Select Top 1 HorseID From TblHorses Order by HorseID Desc'

    while...

    January 11, 2005 at 10:47 am

    #536874

  • RE: Help - New to T-SQL

    hmmm no replies?

    December 20, 2004 at 12:25 pm

    #534519

  • RE: Help - New to T-SQL

    Thank you for the great explanation. am going to think on it today how to work into what i use. Here is a rough outline of what I wanted the...

    December 16, 2004 at 1:23 am

    #534095

  • RE: Help - New to T-SQL

    the other alternative version i have once again still not random for each updates record:
     
    DECLARE @RandomisedNumber decimal

    DECLARE @sql NVARCHAR(500)

    SET @sql = N'SET @RandomisedNumber = (rand() *...

    December 15, 2004 at 12:41 pm

    #534028

  • RE: Help - New to T-SQL

    hmm ok and to the other method, not sure quite wat it does, as far i can tell creates a table with 8000 records with values 1-8000
     
    then the second part...

    December 15, 2004 at 12:20 pm

    #534017

  • RE: Help - New to T-SQL

    ok tried the above and got errors:
     
    Server: Msg 156, Level 15, State 1, Line 3

    Incorrect syntax near the keyword 'Declare'.

    Server: Msg 170, Level 15, State 1, Line 6

    Line 6: Incorrect...

    December 15, 2004 at 12:11 pm

    #534013

  • RE: Help - New to T-SQL

    cool and that means a different random number for each record?
     
    Thanks again all of you, is so nice to be on a forum where ppl help.
     
    Dagaz

    December 15, 2004 at 3:51 am

    #533915

  • RE: Help - New to T-SQL

    Hmm any chance showing inside my example? as i have tried the below but still using same rand
     
    DECLARE @RandomisedNumber decimal

    DECLARE @sql NVARCHAR(500)

    SET @sql = N'SET @RandomisedNumber...

    December 14, 2004 at 12:59 pm

    #533834

  • RE: Help - New to T-SQL

    ooooo have modified a bit: seems to work minus every record ending up with same result lol:
     
     
    Update ViewWeeklyFormUpdate
     
     Set Form =
     
      Case round( cast( StableHands as...

    December 13, 2004 at 1:07 pm

    #533632

  • RE: Help - New to T-SQL

    lol ok got home and definate improvement. my only question is that rand seems to be the same rand for all records? am i wrong in this or is there...

    December 13, 2004 at 12:28 pm

    #533626

  • RE: Help - New to T-SQL

    Thank you, once i see something layed out like that it makes so much sense and a lot easier to understand.
     
    When I get home tonight will give it a go.
     
    Dagaz

    December 13, 2004 at 1:38 am

    #533472

  • RE: Help - New to T-SQL

    thank u, u are a god send.
     
    Silly q now. Don't suppose you could do a simple example? if too much to ask dont worry.
     
    But thanks anyways at least i have...

    December 13, 2004 at 1:23 am

    #533468

Viewing 14 posts - 1 through 14 (of 14 total)