Forum Replies Created

Viewing 15 posts - 4,021 through 4,035 (of 9,722 total)

  • RE: Querying a specific period

    sstteevvee22 (9/10/2012)

    Here is my query:

    SELECT dbo.RHeads.Branch, dbo.RLines.Part, dbo.Stock.Free AS [On Hand], dbo.RLines.CQty AS [Qty Last Received],

    dbo.RHeads.DateTime AS Date,

    ...

    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 10, 2012 at 8:07 am

    #1535707

  • RE: Recursive query to produce business_unit, parent_item_no, level of recursion, child_item_no

    Look up Common Table Expressions in Books Online. That's precisely what it was created for.

    http://msdn.microsoft.com/en-us/library/ms190766(v=SQL.105).aspx

    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 10, 2012 at 8:05 am

    #1535705

  • RE: SQL 2K8 Integration services not installed?

    Check out this thread. I bet you have the same issue.

    http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/f127d838-4a45-49bc-b925-d08886f066f9

    I found it by googling your error message.

    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 10, 2012 at 8:02 am

    #1535699

  • RE: UNION Help

    aaron.reese (9/10/2012)

    the view with UNION ALL the same query once for each agent table

    Not something I recommend. The view will have to be recreated every time a new agents table...

    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 10, 2012 at 7:23 am

    #1535672

  • RE: UNION Help

    DBayliss, if you can follow t.brown's advice, that would be the best solution to your issue. If you are constrained from making changes to the existing schema, here are a...

    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 10, 2012 at 6:07 am

    #1535638

  • RE: SSIS runs in debug but not from job

    We've had the same issue due to permissions and we've had the same issue due to missing or out of date dll files on our server.

    Was this package developed by...

    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 10, 2012 at 5:56 am

    #1535633

  • RE: Are the posted questions getting worse?

    Scott D. Jacobson (9/9/2012)

    Just saw this on Hacker News and immediately thought of this long running thread: http://mattgemmell.com/2008/12/08/what-have-you-tried/%5B/url%5D

    The Hacker News comments are interesting as well.

    Yeah, the comment that led 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.

    September 10, 2012 at 5:16 am

    #1535621

  • RE: Installing SQL SERVER 2012 Developer Edition On Top of 2005 Editioon

    jrichards54

    Just a quick FYI: Next time you reply to someone's post and want to quote it, just hit the quote button instead of reply. It will use the forum code...

    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 10, 2012 at 4:57 am

    #1535614

  • RE: Common questions asked in SQL Server DBA Interview

    tua022012 (9/10/2012)

    Thanks for your link. It's useful for our community.

    Same material can be found at: Production executive interview questions[/url]

    I hope it's useful for you and you like it. Please continue...

    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 10, 2012 at 4:27 am

    #1535596

  • RE: Are the posted questions getting worse?

    jasona.work (9/7/2012)

    Ah, the feeling you get when you do something for yourself, from scratch, without finding someone elses' code to use...

    Even if it is something that a seasoned DBA (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 7, 2012 at 11:32 am

    #1535201

  • RE: Installing SQL SERVER 2012 Developer Edition On Top of 2005 Editioon

    jrichards54

    Can you post the latest installation log for SQL Server? The one from when you attempted to install and the it failed due to a blocked install.

    Also, what features did...

    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 7, 2012 at 8:09 am

    #1535076

  • RE: Are the posted questions getting worse?

    jcrawf02 (9/7/2012)

    Brandie Tarvin (9/7/2012)

    All,

    Tomorrow's SQL Saturday post is going to be about SQL Server resources. I'm including things like this forum, Tek-Tips, a few blogs, Twitter hashtags.

    Does anyone have recommendations...

    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 7, 2012 at 6:27 am

    #1535028

  • RE: Are the posted questions getting worse?

    All,

    Tomorrow's SQL Saturday post is going to be about SQL Server resources. I'm including things like this forum, Tek-Tips, a few blogs, Twitter hashtags.

    Does anyone have recommendations for resources 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.

    September 7, 2012 at 6:03 am

    #1535022

  • RE: How to create excel destination dynamically in SSIS 2008?

    You can use an expression to calculate based on a value of a variable. The variable will be what you alter based on what's coming in.

    Because I don't know anything...

    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 7, 2012 at 6:01 am

    #1535021

  • RE: Hide multiple Columns based on Parameter value in SSRS 2004

    I believe you have to nest your IIF code to account for all possible permeations of the parameters. It's been a while since I used SSRS, though, so I'm 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 7, 2012 at 4:39 am

    #1534983

Viewing 15 posts - 4,021 through 4,035 (of 9,722 total)