Forum Replies Created

Viewing 15 posts - 2,971 through 2,985 (of 5,109 total)

  • RE: ssrs 2008 report parameters

    This sounds like what your trying to do is make some parameters display only if required, but if they are making them compulsory. SSRS does not support "optional required" parameters,...

    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

    ThomasRushton - Thursday, October 5, 2017 2:57 AM

    Does USA not have 1st January as a holiday?  Or the following Monday if...

    Thom~

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

  • RE: tsql help

    vsamantha35 - Thursday, October 5, 2017 1:54 AM

    Hi All,

    Thanks for the suggestions. Thanks a lot.
    One thing, came into my mind,...

    Thom~

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

  • RE: blank value behaviour ???

    The reason for this is that due to data type precedents. In your UNION statement all the values are in the same column and you are providing integers...

    Thom~

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

  • RE: Count of Cells based on columns in SSRS

    wweraw25 - Wednesday, October 4, 2017 3:06 PM

    Thom~

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

  • RE: tsql help

    Avi1 - Wednesday, October 4, 2017 1:09 PM

    We implemented it few years back in 2008 R2, We had one stage table which...

    Thom~

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

  • RE: No Management Studio After Installation

    yrstruly - Wednesday, October 4, 2017 11:26 AM

    It is SQL SERVER 2014!

    SSMS 2017 is compatible with all currently supported versions of SQL...

    Thom~

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

  • RE: No Management Studio After Installation

    Most likely you didn't select it as part of the Installation items. SSMS was removed from the Install process from SQL server 2016 and and SSMS 2017 is free to...

    Thom~

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

  • RE: JSON: why not a JSON data type (like XML has)?

    Although I'll admit, maybe it is a bit odd, but it is easy to add a constraint on a JSON column:
    --Create sample table
    CREATE TABLE SampleJson (JsonString...

    Thom~

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

  • RE: tsql help

    One method, using Jeff's DelimitedSplit8K function:
    WITH PT AS (
        SELECT *
        FROM t3
             CROSS APPLY dbo.DelimitedSplit8K (t3.c1,'|') DS)
    SELECT...

    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?

    Thom A - Thursday, September 28, 2017 9:56 AM

    Eirikur Eiriksson - Thursday, September 28, 2017 9:36 AM

    Thom~

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

  • RE: SSIS: Not able to rename package

    river1 - Wednesday, October 4, 2017 3:34 AM

    Dear all,

    I have a problem when trying to rename a package name. I get this...

    Thom~

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

  • RE: Why SQL Server is Better Than Oracle

    kannan_egd - Wednesday, October 4, 2017 3:41 AM

    jfogel - Tuesday, October 3, 2017 6:04 PM

    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?

    Eirikur Eiriksson - Wednesday, October 4, 2017 12:04 AM

    Thom A - Monday, October 2, 2017 4:17 PM

    Thom~

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

  • RE: SSIS : Convert MM/DD/YYYY into DD/MM/YYYY

    What is the data type of the column set to? Is it text, or date with the format MM/dd/yyyy? If the latter, then the date is simply stored as a...

    Thom~

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

Viewing 15 posts - 2,971 through 2,985 (of 5,109 total)