Forum Replies Created

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

  • RE: Database Corruption

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

    Hi Tom,
    The server are exact the same as Hardware, OS and SW.
    Thank you

    And none of...

    November 8, 2017 at 3:51 am

    #1967119

  • 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,...

    November 8, 2017 at 3:38 am

    #1967116

  • 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...

    November 8, 2017 at 3:25 am

    #1967112

  • 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...

    November 8, 2017 at 3:20 am

    #1967109

  • 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...

    November 8, 2017 at 3:05 am

    #1967102

  • 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...

    November 8, 2017 at 2:04 am

    #1967093

  • 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...

    November 8, 2017 at 1:56 am

    #1967091

  • 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...

    November 7, 2017 at 8:22 am

    #1967003

  • 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...

    November 7, 2017 at 7:49 am

    #1966997

  • 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...

    November 7, 2017 at 7:38 am

    #1966993

  • 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...

    November 7, 2017 at 5:03 am

    #1966965

  • 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...

    November 7, 2017 at 3:44 am

    #1966952

  • 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...

    November 7, 2017 at 3:35 am

    #1966949

  • 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...

    November 7, 2017 at 2:26 am

    #1966937

  • 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....

    November 7, 2017 at 2:05 am

    #1966932

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