Forum Replies Created

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

  • RE: Multiple Selects

    P.S

    Steven Cameron rocks...

    thanks Steven.

    Oren Levy

    June 24, 2008 at 4:26 pm

    #833635

  • RE: Multiple Selects

    Actually I found the way.

    SELECT TableNew.itemnumber,TableNew.PL,TableNew.Description,TableNew.Price FROM TableNew

    WHERE TableNew.ItemNumber IN

    (SELECT t1.ItemNumber

    FROM testtable t1

    INNER JOIN testtable...

    June 24, 2008 at 4:25 pm

    #833634

  • RE: Multiple Selects

    Now that I think about it I have one more question.

    can I join the results to an additional table to bring some more fields from there.

    Additional table structure

    TableNew

    ItemNumber ...

    June 24, 2008 at 4:09 pm

    #833628

  • RE: Multiple Selects

    This is awesome, Thank you very very much.

    I would probably add a group by at the end so I won't get duplicates:

    SELECT t1.ItemNumber

    FROM testtable t1

    ...

    June 24, 2008 at 3:56 pm

    #833627

  • RE: inserting multiple records from 1 record

    How do I write 5 insert statements against 1 select?

    September 5, 2007 at 7:11 pm

    #731667

  • RE: Group Data

    Actually I got it.
     
    Thank you anyway.
     
    Oren

    December 15, 2006 at 7:03 pm

    #678501

  • RE: Group Data

     
    is there a way to modify it so the sorting will be done by PLDescription instead of by PL and then all the...

    December 15, 2006 at 3:38 pm

    #678479

  • RE: Group Data

    Silly me, I guess my excitement with Sergiy Excellence took over.

    Thanks Vladan.

     

    Thank you

    December 15, 2006 at 11:09 am

    #678410

  • RE: Group Data

    Ten Centuries you Rock moch more then 100 decades.
     
    Thank you very much.
     
    Happy Holidays.
     
    Oren
     

    December 14, 2006 at 10:48 am

    #678152

  • RE: Group Data

    Did that but still no luck, I'm getting the following error:  

    Server: Msg 156, Level 15, State 1, Line 26

    Incorrect syntax near the keyword 'GROUP'.

    Server: Msg 170, Level 15, State...

    December 13, 2006 at 9:21 pm

    #677983

  • RE: Group Data

    Hi Ten Centuries
     
    Thanks for the prompt response.
     
    However I could not make it work, I'm getting an Syntax Error or Access violation.
     
    Here is what what I changed it to:
     
    Probably I'm doing...

    December 13, 2006 at 7:31 pm

    #677977

  • RE: Group Data

    I can live with one column back and disregard the PLnumber (PL001)
    Basically
     
    PLDescription1
    ItemNumber1

    ItemNumber2

    ItemNumber3

    ItemNumber4

    PLDescription2

    ItemNumber5

    ItemNumber6

     
    Thanks
     
    Oren

    December 13, 2006 at 6:15 pm

    #677969

  • RE: SQL full text web search

    Thanks a million Ronald.
     
    Works like a charm
     
    Oren

    December 13, 2006 at 2:20 pm

    #677915

  • RE: union with rank duplicated records

    you are unbelievable

    Thank you so much, you have no idea how great this is.

    You rock.....

    Oren Levy

    December 7, 2006 at 6:33 pm

    #676795

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