Forum Replies Created

Viewing 15 posts - 601 through 615 (of 5,109 total)

  • Reply To: handling Nulls in case series

    You can't use IS NULL in a CASE expression using the CASE {value} WHEN {expression} format; you must use the CASE WHEN {value} = {expression} style syntax:

    USE...

    Thom~

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

    January 6, 2020 at 4:31 pm

    #3712715

  • Reply To: CHOOSing a value

    Thomas Franz wrote:

    For the sake of completeness, CHOOSE() ignores errors too, until you access this value

    I suspect that because it uses the same logic as a CASE expression, which does the...

    Thom~

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

    January 6, 2020 at 4:29 pm

    #3712714

  • Reply To: CHOOSing a value

    Think it would be worth mentioning in the Explanation that the return type is determined by data type precedence; in case someone wonders why it isn't 3, due to the...

    Thom~

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

    January 6, 2020 at 1:00 pm

    #3712618

  • Reply To: difference between numeric and decimal

    Lowell wrote:

    so less than 100K. you have to take into consideration what the max value for a column might be when you create the field, as well as when you...

    Thom~

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

    January 6, 2020 at 12:50 pm

    #3712617

  • Reply To: Validating meta data of xls file

    This sounds more like a user problem than anything. Perhaps you would be better putting in some validation in the Excel Document as well; for example not letting people type...

    Thom~

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

    January 6, 2020 at 12:42 pm

    #3712615

  • Reply To: difference between numeric and decimal

    Also, it's not decimal (10.5) it's decimal(10,5), you need a comma(,) between the precision and scale.

    The document that John linked to should tell you all you need, but if there...

    Thom~

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

    January 6, 2020 at 12:37 pm

    #3712613

  • Reply To: Delaying the code

    Stewart "Arturius" Campbell wrote:

    Back in the land of the connected (spent the last 2 weeks in the bush, in the middle of nowhere (no mobile connectivity)).

    Nice reminder of the intricacies of the...

    Thom~

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

    January 6, 2020 at 9:50 am

    #3712582

  • Reply To: BCP export/Import >> More Columns in Table than in Data File

    Is this a cross post of your question here? https://www.sqlservercentral.com/forums/topic/bcp-33

    Thom~

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

    January 5, 2020 at 11:33 am

    #3712439

  • Reply To: BCP

    What does this have to do with BCP? BCP means Bulk Copy Program; it doesn't perform DDL changes likes these, it's for data migration from one location to another.

    If you...

    Thom~

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

    January 5, 2020 at 11:23 am

    #3712436

  • Reply To: SSIS package don't running with bat file

    Why not use agent to run your SSIS package?

    Thom~

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

    January 4, 2020 at 7:23 pm

    #3712398

  • Reply To: Help required creating an SQL PIVOT

    This, therefore, appears to be what you're after (guessing):

    WITH YourTable AS(
        SELECT V.TraceableItemID,
               RTRIM(V.Title)...

    Thom~

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

    January 3, 2020 at 2:30 pm

    #3712140

  • Reply To: Help required creating an SQL PIVOT

    Make sure you put the data in a code block, otherwise yes the formatting will be lost.

    And I recommend a Cross Tab regardless. The type of data (or the data...

    Thom~

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

    January 3, 2020 at 1:22 pm

    #3712099

  • Reply To: Help required creating an SQL PIVOT

    Images of the data really don't help us, I'm afraid. We can't consume the information and you shouldn't expect us to transcribe it.

    Personally, if you do need to Pivot your...

    Thom~

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

    January 3, 2020 at 12:57 pm

    #3712092

  • Reply To: error while install sql server 2019

    Do you need R and Python? If not, don't install them. If you do, what is the error?

    Thom~

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

    January 3, 2020 at 11:46 am

    #3712072

  • Reply To: Are the posted questions getting worse?

    Happy New Year all, hope you enjoyed the festivities, and the break (if you got one). I was working most of the days, or otherwise with family, so I can't...

    Thom~

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

    January 2, 2020 at 12:17 pm

    #3711741

Viewing 15 posts - 601 through 615 (of 5,109 total)