Forum Replies Created

Viewing 15 posts - 5,461 through 5,475 (of 9,728 total)

  • RE: Query is not summarizing results

    I'm seeing two things. 1) In your result set, you refer to customer 9181, who doesn't exist in the test data. I'm assuming you meant 9151 and this is just...

    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 28, 2011 at 5:13 am

    #1359939

  • RE: Query is not summarizing results

    Eugene Elutin (7/28/2011)

    1. If you re using SSRS to produce report, grouping can be done in SSRD itself

    FYI: I agree with the above statement. In fact, in SSRS, you can...

    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 28, 2011 at 5:00 am

    #1359934

  • RE: Query is not summarizing results

    I'm taking a look at this now.

    Just an FYI: Your DROP TABLE script will error out for those of us who don't have your table in our dbs. If you...

    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 28, 2011 at 4:57 am

    #1359931

  • RE: Are the posted questions getting worse?

    WhineWhine, RantRant, ComplainComplain.

    Why does morning have to come so early? Can't it wait until I wake up for real?

    [/rant]

    So, are there any pastries or donuts at the water cooler today?...

    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 28, 2011 at 4:48 am

    #1359928

  • RE: Except vs. Left Join vs. Not Exists

    Paul,

    Thank you for that post. It was very informative.

    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 28, 2011 at 4:39 am

    #1359922

  • RE: Convert() Functionality -> MS webpage error?

    Ah. Thank you for pointing that out.

    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 27, 2011 at 12:07 pm

    #1359581

  • RE: sys.objects$ (with a Dollar sign)

    I don't see either view or table called sys.objects$ (just did the Resource user db on my local dev copy).

    Lowell, make sure to rename the db before you try...

    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 27, 2011 at 11:55 am

    #1359570

  • RE: sys.objects$ (with a Dollar sign)

    Lowell (7/27/2011)

    so is that the super secret resource database? how can i select from it, if i reeeallly wanted to?

    Bad Lowell. We're not supposed to be selecting from Microsoft's secret...

    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 27, 2011 at 11:32 am

    #1359542

  • RE: Today's Random Word!

    ...but I still love you guys. @=)

    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 27, 2011 at 11:10 am

    #1359518

  • RE: Today's Random Word!

    Spam.

    This thread and The Thread are killing my inbox!

    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 27, 2011 at 11:10 am

    #1359516

  • RE: sp_send_dbmail

    An ANSI character set is a set of numbers that represent every letter in the alphabet and every number from 0-9. They also represent punctuation marks, spaces, tabs, line breaks,...

    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 27, 2011 at 11:04 am

    #1359512

  • RE: Stored proc returning puzzling error - Invalid column name

    Glad we could help. And very glad it wasn't something worse.

    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 27, 2011 at 10:55 am

    #1359505

  • RE: select SERVERPROPERTY('COLLATION')

    chandan_jha18 (7/27/2011)

    Lowell (7/27/2011)

    based on this ms doc, where changing the server collation requires a rebuild:

    http://msdn.microsoft.com/en-us/library/ms179254.aspx,

    i'm guessing that the server collation is actually the collation of the resource database, regardless...

    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 27, 2011 at 7:22 am

    #1359227

  • RE: Query is not summarizing results

    Could you clarify what you're looking for in the result set. As you can see from the back-n-forth here, we all have different thoughts about what you're looking for.

    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 27, 2011 at 7:19 am

    #1359222

  • RE: Today's Random Word!

    bopeavy (7/27/2011)

    Ray K (7/27/2011)

    WOTD: coffee

    Tea

    Green

    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 27, 2011 at 7:17 am

    #1359219

Viewing 15 posts - 5,461 through 5,475 (of 9,728 total)