Forum Replies Created

Viewing 15 posts - 1 through 15 (of 102 total)

  • RE: Temporal Tables - "Parameterise" extended SYSTEM_TIME syntax

    Steve Jones - SSC Editor - Monday, June 5, 2017 1:27 PM

    I think you want to do this the other way. From...

  • RE: On formatting SQL code

    Average number of years per opinion is interesting - link

  • RE: On formatting SQL code

    It looks as if I am able to share the report publicly (for free while the feature is in preview), but not the dashboard as I thought I could.

    The report...

  • RE: On formatting SQL code

    TomThomson (3/28/2016)


    Eric M Russell (3/28/2016)


    The stored procedure I'm currently tasked with refactoring reads like a 20 page short story by Clive Barker.

    You have my deepest sympathy.

    I wrote some of that...

  • RE: On formatting SQL code

    Sorry about that guys - I've not shared items outside our organisation and was not sure how Power BI would behave; it is a new feature.

    You should be able to...

  • RE: On formatting SQL code

    diamondgm (3/26/2016)


    The results should be visible here

    If the BI gods do their thing, the report should update hourly

    You should also be able to download the data by clicking on the...

  • RE: On formatting SQL code

    The results should be visible here

    If the BI gods do their thing, the report should update hourly

    You should also be able to download the data by clicking on the ellipsis...

  • RE: On formatting SQL code

    JBrosch (3/26/2016)


    How about a simple SurveyMonkey survey on this? ... I would curious to see the results 5 = heavily structured and enforced to 1 = free form - one...

  • RE: On formatting SQL code

    code formatting and structure is a must it's very difficult getting in to someone's code and having to try see the world as they see it so standardisation is important...

  • RE: Error Configuring Master Data Services SQL Server 2012

    Stefaans (5/30/2012)


    This is the solution.

    If you install IIS after .NET 4, you may encounter this error. To fix this issue, open a command prompt and go to the .NET...

  • RE: Regarding FindString()

    My 2c...

    Was having the same problem and found that:

    FINDSTRING([Input],"\t",1)

    ...worked just fine

  • RE: Display SQL result like Quick Search format

    drew.allen (8/19/2013)


    WITH ROLLUP is being deprecated in favor of the ROLLUP() function. Here is the query rewritten using the ROLLUP() function.

    ;WITH CTE0 AS

    (

    SELECT Section

    ,NAME

    ,RowOrdering = ROW_NUMBER() OVER (ORDER BY...

  • RE: Display SQL result like Quick Search format

    nicholasdoyle (8/8/2013)


    Thanks for showing me a better way diamondgm, I haven't really used WITH ROLLUP before.

    I'm not suggesting it's better, though without indexing, it does seem slightly cheaper 🙂

    Its a...

  • RE: Display SQL result like Quick Search format

    While I couldn't agree more with Phil; this sort of operation doesn't belong in the database, I had to try find a way to do it without the UNION -...

  • RE: Why no Index Scan?

    Will digest.

    Thanks Gail

Viewing 15 posts - 1 through 15 (of 102 total)