Forum Replies Created

Viewing 15 posts - 3,001 through 3,015 (of 5,109 total)

  • RE: Strange COALESCE issue

    At the OP: Feel free to ignore Joe's ramblings, although, his comment of no Sample Data is still just as important as when I stated it. 🙂 We need that...

    Thom~

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

  • RE: Current month to yesterday's date

    Ok, the first important part is to create your Calendar table. How to do that is explained in the link I provided earlier, so I'm going to skip over that...

    Thom~

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

  • RE: Current month to yesterday's date

    craig.jenkins - Monday, October 2, 2017 8:25 AM

    ok thanks a lot.  I'll have a blast and see how i get on.  New...

    Thom~

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

  • RE: Current month to yesterday's date

    craig.jenkins - Monday, October 2, 2017 8:04 AM

    Hi Thom A,

    Thanks for coming back to me.  You are correctly yesterday would have provided...

    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?

    Anyone got any idea what time 2017 goes up, or is it just (at some point) "today"?

    Thom~

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

  • RE: Current month to yesterday's date

    Based on your description, should today not display results for just yesterday? The current month is October and yesterday's date is 01 October 2017. Other wise, what results are you...

    Thom~

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

  • RE: Insert records into newly added column

    I might be missing something, but my copy of Adventure works doesn't have a table Person.Contact, thus I can't run your scripts.

    If, however, the relationship is...

    Thom~

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

  • RE: Restore MySQL dump? help

    markheine68 - Monday, October 2, 2017 6:10 AM

    good day to you, you can try to use the method restore using a backup...

    Thom~

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

  • RE: Compare 2 rows using tsql code

    aaron.reese - Monday, October 2, 2017 6:33 AM

    so if you wanted to pass a table name and two record IDs to a...

    Thom~

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

  • RE: select from flat file

    MinhL7 - Sunday, October 1, 2017 8:32 PM

    It's not a good file and I need to filter the insert. Can you select...

    Thom~

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

  • RE: insert from flat file

    Duplicate of https://www.sqlservercentral.com/Forums/1900183/select-from-flat-file

    Thom~

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

  • RE: Compare 2 rows using tsql code

    aaron.reese - Monday, October 2, 2017 5:13 AM

    If you want a generic solution then you are going to need to use a...

    Thom~

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

  • RE: logins disappearing

    muzikfreakster - Monday, October 2, 2017 3:34 AM

    yes this is not a case of orphan users and I do see logins for...

    Thom~

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

  • RE: Strange COALESCE issue

    You've provided DDL, which is great, however, no DLM, so all these queries return NULL. We can't access your data so we can't replicate your problem. Can you please provide...

    Thom~

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

  • RE: Display Percentage for Top Value

    You could use a expression on the format of the textbox. YOu'll need to likely tweak this a bit, maybe use a Row Number function instead of the ID's value,...

    Thom~

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

Viewing 15 posts - 3,001 through 3,015 (of 5,109 total)