Forum Replies Created

Viewing 8 posts - 256 through 264 (of 264 total)

  • RE: messages and results... where to dump them...

    Hi Mike,

    in this context 'Fail' can mean many things - either the sproc did not complete or if it is say a procedure that searches our database for known issues...

    Ben

    ^ Thats me!

    ----------------------------------------
    01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
    ----------------------------------------

    September 15, 2010 at 7:02 am

    #1221294

  • RE: Collation problem! dont know what to do :(

    Thanks all.

    I'll give this a go, if I get any more problems I'll be sure to post again!

    Thanks

    Ben

    ^ Thats me!

    ----------------------------------------
    01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
    ----------------------------------------

    January 28, 2010 at 2:07 am

    #1109803

  • RE: Collation problem! dont know what to do :(

    Cheers buddy

    I'm changing the date to chars to avoid the problem of 1/jan/2010 at 1pm being different from 1/jan/2010 at 3pm etc.

    My brain is too muddled by now to analyse...

    Ben

    ^ Thats me!

    ----------------------------------------
    01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
    ----------------------------------------

    January 27, 2010 at 10:07 am

    #1109407

  • RE: Help with a join

    Ok....

    Perhaps your database actually does have garbage in the contact_info column? Lots of people type junk into an email address column because they dont want to receive marketting info.

    Ben

    ^ Thats me!

    ----------------------------------------
    01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
    ----------------------------------------

    January 27, 2010 at 9:57 am

    #1109399

  • RE: Creating tables within a schema

    Hi Flo,

    results:

    -------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------

    PCS08404\SQLEXPRESS ...

    Ben

    ^ Thats me!

    ----------------------------------------
    01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
    ----------------------------------------

    November 18, 2009 at 2:52 am

    #1080749

  • RE: Creating tables within a schema

    Unfortunately not... I just created them using the graphical tools in management studio.

    Interestingly I have just succesfully created the table using the graphical tools. I hit F4 to get the...

    Ben

    ^ Thats me!

    ----------------------------------------
    01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
    ----------------------------------------

    November 17, 2009 at 10:57 am

    #1080403

  • RE: In, Not In. Why does one work but not the other?

    Ah that makes sense then 🙂

    Thanks!

    Ben

    ^ Thats me!

    ----------------------------------------
    01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
    ----------------------------------------

    October 19, 2009 at 2:59 am

    #1067552

  • RE: In, Not In. Why does one work but not the other?

    Thanks very much!

    I'm amazed that a single null in a recordset will make the whole query fail but nevermind eh 🙂

    Happy programming.

    Ben

    Ben

    ^ Thats me!

    ----------------------------------------
    01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
    ----------------------------------------

    October 19, 2009 at 2:42 am

    #1067543

Viewing 8 posts - 256 through 264 (of 264 total)