Forum Replies Created

Viewing 15 posts - 661 through 675 (of 9,715 total)

  • RE: Dynamically pivot a table

    alexander.lummer - Tuesday, September 4, 2018 1:36 PM

    Brandie Tarvin - Tuesday, September 4, 2018 12:29 PM

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    September 5, 2018 at 5:44 am

    #2004482

  • RE: Dynamically pivot a table

    alexander.lummer - Tuesday, September 4, 2018 12:24 PM

    fair point.. unfortunately, I am not as advanced.  Not sure where to start.  I built...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    September 4, 2018 at 12:29 pm

    #2004417

  • RE: When to mask or encrypt the data?

    86deep - Tuesday, September 4, 2018 8:23 AM

    I will start with some background info.

    We are using SQL 2012 and wont be...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    September 4, 2018 at 12:20 pm

    #2004411

  • RE: how can I have a failed job notification be emailed to more than one person

    Sreekanth B - Tuesday, September 4, 2018 11:23 AM

    Create an operator with multiple email addresses and use that in the job notification.

    Be...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    September 4, 2018 at 12:15 pm

    #2004409

  • RE: Dynamically pivot a table

    https://www.mssqltips.com/sqlservertip/2783/script-to-create-dynamic-pivot-queries-in-sql-server/

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    September 4, 2018 at 12:09 pm

    #2004407

  • RE: Separating SSIS Datetime

    TOKEN?

    I had not heard of that one. I shall have to try it.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    September 4, 2018 at 12:03 pm

    #2004405

  • RE: Are the posted questions getting worse?

    ZZartin - Tuesday, September 4, 2018 9:10 AM

    Thom A - Tuesday, September 4, 2018 8:50 AM

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    September 4, 2018 at 9:18 am

    #2004375

  • RE: Are the posted questions getting worse?

    Thom A - Tuesday, September 4, 2018 9:10 AM

    I've nothing wrong with Dynamic SQL either, i use it a lot in...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    September 4, 2018 at 9:16 am

    #2004373

  • RE: Are the posted questions getting worse?

    Thom A - Tuesday, September 4, 2018 8:50 AM

    It frustrates me so much that it seems people are STILL being taught...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    September 4, 2018 at 9:03 am

    #2004368

  • RE: Separating SSIS Datetime

    tmmutsetse - Tuesday, September 4, 2018 8:26 AM

    Thank you so much.
    @Brandie Tarvin i am grateful for your explaination however i am not...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    September 4, 2018 at 8:44 am

    #2004366

  • RE: Are the posted questions getting worse?

    Whee HAW!

    We survived! The big migration from system A to system B is completed and we ran a month end on the new system with few issues. Everything mostly...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    September 4, 2018 at 8:32 am

    #2004360

  • RE: Separating SSIS Datetime

    Jeff Moden - Tuesday, September 4, 2018 5:46 AM

    tmmutsetse - Tuesday, September 4, 2018 1:44 AM

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    September 4, 2018 at 5:49 am

    #2004325

  • RE: Separating SSIS Datetime

    There are a couple of ways you can do this.

    1) Build the file import connection manager to treat date and time as two separate import columns. This is...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    September 4, 2018 at 5:35 am

    #2004323

  • RE: Dilemma when refreshing UAT from Prod

    And once you do what Grant instructed, if you still get the error, you need to look at the backup tables in MSDB to find out what the correct "earlier...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    September 4, 2018 at 5:24 am

    #2004322

  • RE: A call to ‘LogonUserW’ failed with error code : ‘1385’

    frobins - Friday, July 20, 2018 9:17 AM

    This still doesn't address why you got the LogonUserW failed error.  I recently experienced this...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 23, 2018 at 3:44 am

    #1998561

Viewing 15 posts - 661 through 675 (of 9,715 total)