Forum Replies Created

Viewing 15 posts - 1,876 through 1,890 (of 5,109 total)

  • RE: Gap data for attendance

    saravanatn - Wednesday, June 27, 2018 7:32 AM

    Why it is posted multiple times and I am not able to delete it

    You can't...

    Thom~

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

  • RE: Gap data for attendance

    You've included DDL and INSERT statement, which is great(!), however, you haven't included any details of what your expected output is here. Could you show us what data you would...

    Thom~

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

  • RE: Sql server express 2017 sa default password

    binutb - Wednesday, June 27, 2018 2:39 AM

    Hi,

    What is the sa default password in sql server express 2017?

    Regards
    Binu

    There is no default. It's...

    Thom~

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

  • RE: Lock on SQL data rows

    KGNH - Wednesday, June 20, 2018 11:49 PM

    Thanks every one for your suggestions

    How did you implement your solution in the end, out...

    Thom~

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

  • RE: Help in writing query for update

    drew.allen - Tuesday, June 26, 2018 8:09 AM

    Yes, but why did you give a RBAR solution in the first place?

    Is a...

    Thom~

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

  • RE: Help in writing query for update

    drew.allen - Tuesday, June 26, 2018 7:14 AM

    @thom-2, you've been around long enough to know that you want to use a...

    Thom~

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

  • RE: How to determine if there are two midnights between two dates

    What have you tried so far? Have you looked at DATEDIFF?

    Thom~

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

  • RE: Help in writing query for update

    koti.raavi - Tuesday, June 26, 2018 6:13 AM

    koti.raavi - Tuesday, June 26, 2018 6:06 AM

    Thom~

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

  • RE: Help in writing query for update

    george_at_sql - Tuesday, June 26, 2018 6:00 AM

    Thom A - Tuesday, June 26, 2018 5:48 AM

    Thom~

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

  • RE: Help in writing query for update

    This is one solution, however, I'm not a fan of it. A calendar table would be far better. Formatting courtesy of SSC's annoying text editor:

    USE Sandbox;

    Thom~

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

  • RE: Help in writing query for update

    KGNH - Tuesday, June 26, 2018 5:31 AM

    Thom A - Tuesday, June 26, 2018 5:26 AM

    Thom~

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

  • RE: Help in writing query for update

    KGNH - Tuesday, June 26, 2018 5:24 AM

    Thom A - Tuesday, June 26, 2018 4:47 AM

    Thom~

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

  • RE: Help in writing query for update

    Misunderstood last post.

    Thom~

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

  • RE: Help in writing query for update

    Do you have a calendar table already?

    Thom~

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

  • RE: Take Backup from SS 2017 to Older Version

    George Hepworth - Monday, June 25, 2018 8:19 AM

    Okay, thanks. I am both lazy and a firm believer in miracles. That often...

    Thom~

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

Viewing 15 posts - 1,876 through 1,890 (of 5,109 total)