Forum Replies Created

Viewing 15 posts - 1,051 through 1,065 (of 5,109 total)

  • Reply To: Updating table based on information in another table

    John Mitchell-245523 wrote:

    Are you using SQL Server?  There's no such thing as "Now()", as far as I know.

    A Google suggests that NOW() is a MySQL function. Hopefully the OP...

    Thom~

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

    April 29, 2019 at 3:48 pm

    #3549830

  • Reply To: Dos and Don'ts of Dynamic SQL

    gary.rumble wrote:

    When I do it in SSMS I use the fact that it allows multiple lines in a single quoted string

    I'm not actually a fan of that method. It's fine...

    • This reply was modified 7 years, 1 months ago by Thom A.

    Thom~

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

    April 29, 2019 at 3:29 pm

    #3549787

  • Reply To: Dos and Don'ts of Dynamic SQL

    Aaron N. Cutshall wrote:

    Great article Thom! I've been working on a SQL Saturday presentation right along these lines. There were a couple of points that I'd like to include in my presentation...

    Thom~

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

    April 29, 2019 at 3:25 pm

    #3549782

  • Reply To: Dos and Don'ts of Dynamic SQL

    WolfgangE wrote:

    Additionally, I use variables for them.

    I really like the idea of putting the line break and carriage return in a variable, that would certainly make the code a...

    Thom~

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

    April 29, 2019 at 9:00 am

    #3549350

  • Reply To: Convert DATETIME to a date in ISO format

    ben.brugman wrote:

    Thom A wrote:

    Even yyyy-MM-dd is not ambiguous, as it is interpreted differently when using the (small)datetime datatype to the other date(time) datatypes.

    I do not understand this. Is it 'not...

    Thom~

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

    April 29, 2019 at 7:56 am

    #3549218

  • Reply To:

    Haven't you already asked this question? 🙂 What was wrong with Grant's answer? (I assume your old account was banned for spam, as you're advertising in that other post.)

    Thom~

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

    April 28, 2019 at 2:47 pm

    #3548310

  • Reply To:

    When you connect to a SQL Server instance you also connect to a database. Also, the user who's credentials you're connected as will have a default schema within that database...

    Thom~

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

    April 28, 2019 at 2:43 pm

    #3548309

  • Reply To: Export results of a Stored Procedure to a PC Folder

    '0x58' and 0x58 aren't the same; one is a string representation of a binary value, and one is a binary value. If you run SELECT CONVERT(varbinary,'0x58'); you don't get 0x58...

    Thom~

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

    April 28, 2019 at 8:03 am

    #3547594

  • Reply To: Getting Close

    Considering that SSMS 2018 only just came out officially, which is the first to support 2019 in full, I do wonder if it's sooner round the corner that we think....

    Thom~

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

    April 27, 2019 at 12:17 pm

    #3544703

  • Reply To: Export results of a Stored Procedure to a PC Folder

    This seems like a task better suited to something like SSIS, rather than a Stored Procedure. C:\ is also the disc on your SQL Server host, not on your PC...

    Thom~

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

    April 27, 2019 at 11:36 am

    #3544593

  • Reply To: ssrs 2012 date formatting

    rVadim wrote:

    There are formatting functions. You should be able to convert to any format you want.

    =Format(Fields!MyDate.Value, "dddd, MMM d yyyy")

    That's effectively identical to what I suggested. The...

    Thom~

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

    April 26, 2019 at 7:34 pm

    #3541993

  • Reply To: Alias server names

    Use Registered Servers.

    In SSMS hit Ctrl+Alt+G (or go to View->Registered Servers) and a new pane will be opened. If you wish you can dock that to a position (I have...

    Thom~

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

    April 26, 2019 at 4:01 pm

    #3541179

  • Reply To: Are the posted questions getting worse?

    Sounds good. Horizontal scroll bars will definitely be a welcome addition.

    Thom~

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

    April 26, 2019 at 3:21 pm

    #3541011

  • Reply To: Are the posted questions getting worse?

    Steve Jones - SSC Editor wrote:

    Thought there was an issue for this, Luis, but don't see one in the various code style items. Added this.

    You mean probably mean this one (Wide code doesn't...

    Thom~

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

    April 26, 2019 at 2:27 pm

    #3540838

  • Reply To: How do i get around this "parameter has already been defined" error?

    Judging by your other question I suspect this is SQL in an SSRS dataset? SSRS, when using the syntax {Expression} IN (@Parameter) with a multi-value parameter injects the values...

    Thom~

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

    April 26, 2019 at 2:04 pm

    #3540775

Viewing 15 posts - 1,051 through 1,065 (of 5,109 total)