Forum Replies Created

Viewing 15 posts - 2,641 through 2,655 (of 5,109 total)

  • RE: Database Corruption

    Do any of these servers have anything in common? Are they all using the same Cluster to store data on or are they all VMs on the same host,...

    Thom~

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

  • RE: Database Corruption

    d_gomes2 - Wednesday, November 8, 2017 3:14 AM

    Hi Thom,
    The issue is solved my problem is I could not Find the rout cause.
    After...

    Thom~

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

  • RE: HOW to configure Report services

    Welcome to SSC.

    There are a lot of guides on the internet on how to configure SSRS. Typing "Configure SSRS on SQL Server 2014" on your preferred Search Engine...

    Thom~

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

  • RE: Database Corruption

    NorthernSoul - Wednesday, November 8, 2017 2:51 AM

    Do you have a recent good full backup and log backups?

    Thanks

    My concern would be that...

    Thom~

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

  • RE: SSRS Date Parameter

    You would be better writing your query in several parts using an IF, depending on what parameters have been supplied. This is only for if the dates have been, but...

    Thom~

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

  • RE: need help

    Welcome to SSC.

    When posting questions for T-SQL, you normally need to supply DDL and Consumable Sample data. This gives you a much better chance of others answering...

    Thom~

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

  • RE: Dynamic variables in SQL server for HTML

    70712 - Tuesday, November 7, 2017 8:16 AM

    Thom, this looks to be working perfectly, Thank you so very much for your...

    Thom~

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

  • RE: Encryption by Pass Phrase

    It's very unlikely that you'll be able to retain the same value in the same column. For example, an 11 character string I just converted into an encrypted varbinary...

    Thom~

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

  • RE: problem with script not getting correct values

    Nomvula - Tuesday, November 7, 2017 7:11 AM

    the duration varies for each tasks hence I can't group it together

    So, if task TBA8-020220...

    Thom~

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

  • RE: Dynamic variables in SQL server for HTML

    jonathan.crawford - Tuesday, November 7, 2017 4:59 AM

    Why do you need to know how many columns though? If you just add the...

    Thom~

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

  • RE: Dynamic variables in SQL server for HTML

    70712 - Tuesday, November 7, 2017 3:41 AM

    Thanks Thom, will give it a go.

    Noticed a slight error (I hadn't closed my...

    Thom~

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

  • RE: Dynamic variables in SQL server for HTML

    Ok, I don't like this solution, in fact, I really dislike it, but here's what I have... it works for the data you supplied, but you're likely going to need...

    Thom~

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

  • RE: problem with script not getting correct values

    Will task code TBA8-020220 always have a task of 5. If fact, is the duration the same across a task? If so, also set your data to group on Duration...

    Thom~

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

  • RE: Dynamic variables in SQL server for HTML

    Ok, I firstly wanted to show you how much EASIER this really is doing the table top down. This took me about 10 minutes this morning for me to do....

    Thom~

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

  • RE: Reporting Services will not start with a .NET 2.0 Runtime Error

    Sue_H - Monday, November 6, 2017 1:53 PM

    SueB - Monday, November 6, 2017 12:39 PM

    Thom~

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

Viewing 15 posts - 2,641 through 2,655 (of 5,109 total)