Forum Replies Created

Viewing 15 posts - 2,446 through 2,460 (of 5,109 total)

  • RE: Are the posted questions getting worse?

    Sean Lange - Wednesday, December 6, 2017 8:18 AM

    jasona.work - Wednesday, December 6, 2017 8:12 AM

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Are the posted questions getting worse?

    Jo Pattyn - Wednesday, December 6, 2017 5:38 AM

    Time for a coffee break.

    Not sure the boss would appreciate me taking a 1...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Remove duplicate values

    saravanatn - Wednesday, December 6, 2017 4:49 AM

    I am just giving(test data just) an example that (ID=4 )records should be returned even if all the...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Are the posted questions getting worse?

    OH GOOD, this again... (installing this time):

    Been at 12 seconds for 15 minutes... /sigh. Think it's time to ask for a new PC.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Next date after a return date.

    So that people don't need to download the file (please post your code into the Topic):
    --table for holding all the scans of a barcode over its lifetime

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Remove duplicate values

    saravanatn - Wednesday, December 6, 2017 3:21 AM

    That's good question I haven't got records like that . But I would like to...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Remove duplicate values

    What would you expect if you have the rows:
    INSERT INTO [details]
    VALUES (6, NULL, 'London','Kensington'),
           (6,'Steve', 'London',NULL);

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: VBscript to run sql file from MS SQL

    GO is an SSMS/SQLCMD batch separator. It has no context for Execute in VBS, and so isn't used. You'll need to pass those scripts separately.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Remove duplicate values

    What you state your requirements are, and your expected output don't match. You state that only those with at least 1 value of NULL should be removed, however, in your...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: VBscript to run sql file from MS SQL

    jaryszek - Wednesday, December 6, 2017 1:30 AM

    I am trying with :
    dbconn.Execute("C:\Users\ljar01\Documents\SQL Server Management Studio\BulkInsert.sql")
    but error is showing up:

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Are the posted questions getting worse?

    Chris Harshman - Tuesday, December 5, 2017 12:28 PM

    Thom A - Tuesday, December 5, 2017 8:26 AM

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Query Help -

    Lynn Pettis - Tuesday, December 5, 2017 9:17 AM

    That would have to be one hell of a long piece of dynamic...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Are the posted questions getting worse?

    Hugo Kornelis - Tuesday, December 5, 2017 8:50 AM

    Ed Wagner - Tuesday, December 5, 2017 8:21 AM

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Query Help -

    On a topic related note, has anyone noticed that the OP hasn't responded to any of our questions? :rolleyes: I feel we'll never really know what the OP was...

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • RE: Are the posted questions getting worse?

    Phil Parkin - Tuesday, December 5, 2017 8:24 AM

    Ed Wagner - Tuesday, December 5, 2017 8:21 AM

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

Viewing 15 posts - 2,446 through 2,460 (of 5,109 total)