Forum Replies Created

Viewing 15 posts - 1,006 through 1,020 (of 9,725 total)

  • RE: Are the posted questions getting worse?

    Luis Cazares - Tuesday, May 16, 2017 10:35 AM

    Those are orcas highly trained by Muslims, Russians, and Mexicans to invade the...

    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.

    May 16, 2017 at 10:40 am

    #1942732

  • RE: Are the posted questions getting worse?

    Is it just me or does it seem orcas are getting in on the black market organ market?

    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.

    May 16, 2017 at 7:04 am

    #1942690

  • RE: SSIS ForEach Loop Container recursion question

    Phil Parkin - Friday, May 12, 2017 12:13 PM

    Just to clarify, consistency is not a prerequisite for my suggestion. Only that...

    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.

    May 15, 2017 at 8:10 am

    #1942557

  • RE: SSIS ForEach Loop Container recursion question

    Thom A - Friday, May 12, 2017 7:21 AM

    I was actually planning to use a Script Component and an ADO variable as...

    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.

    May 12, 2017 at 12:06 pm

    #1942379

  • RE: SSIS ForEach Loop Container recursion question

    FridayNightGiant - Friday, May 12, 2017 11:33 AM

    I've done something similar in the past, here is some sample code I mocked up

    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.

    May 12, 2017 at 12:01 pm

    #1942377

  • RE: SSIS ForEach Loop Container recursion question

    Phil Parkin - Friday, May 12, 2017 5:47 AM

    If you know the absolute maximum number of rows in the source, you could...

    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.

    May 12, 2017 at 12:00 pm

    #1942376

  • RE: SSIS ForEach Loop Container recursion question

    Eirikur Eiriksson - Friday, May 12, 2017 5:28 AM

    Are you exporting the data from a table?
    😎

    Yes. I've got a table with...

    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.

    May 12, 2017 at 11:59 am

    #1942375

  • RE: SSIS ForEach Loop Container recursion question

    Thanks, Guys. I'm going to watch this thread for a little bit more (I want to hear what Thom has to say) before digging back into this. I've been banging...

    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.

    May 12, 2017 at 5:22 am

    #1942300

  • RE: Are the posted questions getting worse?

    Thanks, Thom.

    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.

    May 12, 2017 at 5:19 am

    #1942299

  • RE: Are the posted questions getting worse?

    I could use a little bit of SSIS brainstorming assistance over here if someone wouldn't mind. This one has me kind of stumped.

    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.

    May 12, 2017 at 5:02 am

    #1942295

  • RE: Are the posted questions getting worse?

    jonathan.crawford - Thursday, May 11, 2017 11:41 AM

    Brandie Tarvin - Tuesday, May 9, 2017 4:47 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.

    May 12, 2017 at 4:00 am

    #1942292

  • RE: Are the posted questions getting worse?

    FYI: I just got accepted to speak at the 2017 Grace Hopper Conference about Careers in Database Administration. I'm doing the Student Opportunity Labs section of the conference. It's 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.

    May 11, 2017 at 9:06 am

    #1942176

  • RE: Are the posted questions getting worse?

    Sorry, John. I live in the 50 States but did not win a $10 gift card, so I'm the wrong person to ask on both counts.

    On the other...

    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.

    May 11, 2017 at 5:16 am

    #1942135

  • RE: Cannot create a row of size 8208 which is greater than the allowable maximum row size of 8060.

    To add on to what the others are saying, all variable columns NVARCHAR and VARCHAR have an additional overhead added to the length you've give them. I believe (Lynn, correct...

    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.

    May 11, 2017 at 4:49 am

    #1942134

  • RE: Cannot create a row of size 8208 which is greater than the allowable maximum row size of 8060.

    The reason Gail is asking for the table definition (as in the CREATE TABLE & CREATE INDEX statements) is because we can add up the data types and lengths to...

    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.

    May 10, 2017 at 8:57 am

    #1942027

Viewing 15 posts - 1,006 through 1,020 (of 9,725 total)