Forum Replies Created

Viewing 15 posts - 1,276 through 1,290 (of 5,109 total)

  • RE: Can you add line breaks in stored text?

    All the text types (char, varchar, nchar, varchar, text and ntext (although don't use the last 2)) can store the characters for Line Breaks and Carriage Returns (ASCII Code 10...

    Thom~

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

    February 3, 2019 at 5:27 am

    #2020950

  • RE: Need Help with Views

    Eirikur Eiriksson - Saturday, February 2, 2019 6:57 AM

    Suggest you look into using a synonym for this.
    😎

    How is...

    Thom~

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

    February 2, 2019 at 7:54 am

    #2020928

  • RE: I have a database whose name is Backup.

    forsqlserver - Thursday, January 31, 2019 8:41 PM

    Thanks all but its created by client mistakenly.I want to know how update stats is...

    Thom~

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

    February 1, 2019 at 1:53 am

    #2020821

  • RE: Default data folder on Linux

    Steve Jones - SSC Editor - Thursday, January 31, 2019 9:43 AM

    The incorrect answer is "set defaultdatadir /prod/data".

    The correct answer is "set...

    Thom~

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

    January 31, 2019 at 9:48 am

    #2020729

  • RE: How do I convert a uk date in string format to date?

    If you are still getting errors, then, honestly, I'd be concerned with using CONVERT at all. Clearly you aren't sure what format the dates are being passed or they're being...

    Thom~

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

    January 31, 2019 at 7:12 am

    #2020697

  • RE: How do I convert a uk date in string format to date?

    Neil Burton - Thursday, January 31, 2019 5:31 AM

     Although taking a date input rather than a varchar is probably the way...

    Thom~

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

    January 31, 2019 at 5:53 am

    #2020688

  • RE: Default data folder on Linux

    morlindk - Thursday, January 31, 2019 2:51 AM

    Thom A - Thursday, January 31, 2019 2:18 AM

    Thom~

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

    January 31, 2019 at 2:57 am

    #2020678

  • RE: Pass date input parameter as float data type

    lukaszpiech - Thursday, January 31, 2019 2:26 AM

    Tom, thank you very much for replying. 
    It is my mistake that i haven't mentioned in...

    Thom~

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

    January 31, 2019 at 2:34 am

    #2020675

  • RE: Default data folder on Linux

    Yes, the correct path (for SQL Server 2017 on Linux...

    Thom~

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

    January 31, 2019 at 2:18 am

    #2020673

  • RE: Installation error

    If you have Enterprise edition of SQL Server, you want to install SSRS Enterprise. That's part of the SQL Server installer; when installing the product you choose which services to...

    Thom~

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

    January 31, 2019 at 2:13 am

    #2020672

  • RE: Pass date input parameter as float data type

    Is it common practice to convert a date(time) datatype to a float? No, not really. Does it improve efficiency? That's a carrot on a stick question; if you end up...

    Thom~

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

    January 31, 2019 at 2:11 am

    #2020671

  • RE: Are the posted questions getting worse?

    TomThomson - Saturday, January 26, 2019 6:57 PM

    I would have attended, but looking after my Ann took priority again this year,...

    Thom~

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

    January 31, 2019 at 2:03 am

    #2020669

  • RE: I have a database whose name is Backup.

    What's the statement your using? BACKUP is a reserved word in SQL Server, so it's a poor choice for an object's name, in truth. The errors suggests you...

    Thom~

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

    January 31, 2019 at 1:57 am

    #2020668

  • RE: Question on grouping

    drew.allen - Tuesday, January 29, 2019 8:58 AM

    As opposed to having to use a dummy value just to trigger the sum...

    Thom~

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

    January 29, 2019 at 9:07 am

    #2020430

  • RE: Question on grouping

    ScottPletcher - Monday, January 28, 2019 5:06 PM

    drew.allen - Monday, January 28, 2019 4:14 PM

    Thom~

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

    January 29, 2019 at 6:44 am

    #2020401

Viewing 15 posts - 1,276 through 1,290 (of 5,109 total)