Forum Replies Created

Viewing 15 posts - 61 through 75 (of 111 total)

  • RE: bus. objects! help!

    Any ideas ?

    If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!

  • RE: syntax help!

    Basically, i want to read through the table and everytime the condition is met I want to increment the count..........

    If riding in a plane is flying, then riding in a...

  • RE: FUNCTION

    Thats what I thought.....we just cant seem to get refiner running using xp_cmdshell

    If riding in a plane is flying, then riding in a boat must be swimming. To experience the...

  • RE: comparing specific rows

    could I not implement some kind of loop construct..heres what I have..its quite self explanatory....

    delete t1

    from unique_cust t1 INNER JOIN unique_cust t2

    on...

  • RE: comparing specific rows

    I can particularly relate to the one about c++.........

    If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of...

  • RE: comparing specific rows

    Thanks Frank, appreciated

    If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!

  • RE: comparing specific rows

    Very dry Frank, thanks.

    Next time I want to speak to a comedian Ill go on a joke site...

    If riding in a plane is flying, then riding in a boat must...

  • RE: comparing specific rows

    I presume 8439 is merely a random number youve picked out.........how can i make it so it works for any instance of the primary key....if u see what i mean........

    If...

  • RE: user permissions for tables

    Isn't there a 'security' folder in EM that lists all the access rights for all users?

    If riding in a plane is flying, then riding in a boat must be swimming....

  • RE: comparing specific rows

    Declare @@var varchar(255)

    select @var = t1.datefield from Table1 t1

    Where t1.Primarykey=8439

    I presume 8439 is merely a random number youve picked out.........how can i make it so it works for any instance...

  • RE: comparing specific rows

    I wasnt bein serious actually......all works now..isnt this forum a marvel?

    Hip hip hooray!

    If riding in a plane is flying, then riding in a boat must be swimming. To experience the...

  • RE: comparing specific rows

    Thanks guys, really appreciate your help

    Cheers for the humour Frank! Must be the German hospitality that Im oh so fond of..Regards

    If riding in a plane is flying, then riding in...

  • RE: comparing specific rows

    Where does this line of code come from:?id=

    (SELECT MAX(id) FROM svrmonitor)

    Cheers Frank

    If riding in a plane is flying, then riding in a boat must be swimming. To experience the element,...

  • RE: comparing specific rows

    Is there a way to assign each of the values, i.e. t1.datefield to a variable....

    i beleive the code would be

    DECLARE @var varchar(255)

    set @var = t1.datefield

    Is it possible to do this...

  • RE: comparing specific rows

    DELETE MyTableFROM MyTable t1 INNER JOIN MyTable t2 ON t1.Unique_ID = t2.Unique_ID AND t1.DateField < t2.DateField

    If riding in a plane is flying, then riding in...

Viewing 15 posts - 61 through 75 (of 111 total)