Forum Replies Created

Viewing 15 posts - 1,261 through 1,275 (of 5,109 total)

  • RE: How to unpivot columns dynamically using SQL server 2014

    Does this need to be dynamic? Are you adding new columns to your table each month (so next month you'll have a column 04/01/2019)? If so, I'd suggest that what...

    Thom~

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

  • RE: fetch rows when condition macthes

    drew.allen - Wednesday, February 6, 2019 9:40 AM

    Thom A - Wednesday, February 6, 2019 8:16 AM

    Thom~

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

  • RE: fetch rows when condition macthes

    I admit, mine wouldn't have worked due to a missing comma, but if you fix that they do indeed both work (giving different results, depending on your need). You can...

    Thom~

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

  • RE: ssis Configuration

    There's also an article on SSIS Catalog Environments in the Stairway to Integration Services article series.

    Thom~

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

  • RE: Question about installation

    itmasterw 60042 - Tuesday, February 5, 2019 7:51 AM

    Hi Everyone,
    Thanks for all your help, as you guys pointed out that. I found...

    Thom~

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

  • RE: Which years are similar.

    What do you mean "similar"? Like World events? Is 2020 similar to 2016 because they both hosted Olympics? Is 2014 similar to 1990 because Germany won the FIFA World Cup...

    Thom~

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

  • RE: fetch rows when condition macthes

    So are you ID's letters? What happens when you get to ID z, is the next row aa? That's going to be a problem for ordering in SQL Server; when...

    Thom~

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

  • RE: Question about installation

    John Mitchell-245523 - Monday, February 4, 2019 9:47 AM

    Perhaps it didn't get installed properly.  Can you see SQL Server in the Services...

    Thom~

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

  • RE: LAG Function, to compare two rows

    You can, however, specify a default value for LEAD/LAG if the row reference would be "out of range". LEAD/LAG has 3 parameters, of which only the 1st is mandatory. The...

    Thom~

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

  • RE: Question about installation

    If you open the SQL Server Configuration Manager can you see your instance is running? Is it also a named instance and running on the default port (if...

    Thom~

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

  • RE: SQL Server agent - Job History

    mdube 62615 - Monday, February 4, 2019 8:40 AM

    Yes the other job I have checked runs daily while the biggest job runs...

    Thom~

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

  • RE: SQL Server agent - Job History

    How regularly does your other job run? I suspect that actually what has happened is that the log for your previous (runs) have been deleted due to one of...

    Thom~

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

  • RE: Need Help with Views

    Eirikur Eiriksson - Monday, February 4, 2019 7:41 AM

    The user/group will have a select permission on the source table, does not...

    Thom~

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

  • RE: Need Help with Views

    Eirikur Eiriksson - Sunday, February 3, 2019 10:38 AM

    You got a point there Tom, the problem is much simpler though! 
    😎
    No...

    Thom~

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

  • RE: Need Help with Views

    Eirikur Eiriksson - Sunday, February 3, 2019 6:04 AM

    Create a schema and synonym in the destination database for the target table...

    Thom~

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

Viewing 15 posts - 1,261 through 1,275 (of 5,109 total)