Forum Replies Created

Viewing 15 posts - 4,786 through 4,800 (of 9,707 total)

  • RE: Stored proc help

    gmamata7 (1/25/2012)

    Hi Tarvin,

    Ah, good ol' Litespeed. Was this is a script generated by the Litespeed console?

    What exactly are you trying to accomplish with the OUTPUT variable?

    I have an existing...

    January 26, 2012 at 6:16 am

    #1438723

  • RE: query database for different packages for same employee

    Please be more specific about what you've tried. Show us the code where you added another column and it didn't work. Post the error that occurred. Give us an INSERT...

    January 26, 2012 at 5:54 am

    #1438713

  • RE: Are the posted questions getting worse?

    SQL Kiwi (1/25/2012)

    Brandie Tarvin (1/25/2012)

    Anyone can fly. You just throw yourself at the ground and miss.

    Been reading Douglas Adams recently, Brandie?

    Hee. I was wondering how long it would take for...

    January 26, 2012 at 5:36 am

    #1438704

  • RE: Are the posted questions getting worse?

    Roy Ernest (1/25/2012)

    Brandie Tarvin (1/25/2012)

    I wish I could attend all the international SQL Saturdays. That would be so much fun.

    I have been thinking about testing remote presentation at some U.S....

    January 26, 2012 at 5:35 am

    #1438702

  • RE: Are the posted questions getting worse?

    I wish I could attend all the international SQL Saturdays. That would be so much fun.

    I have been thinking about testing remote presentation at some U.S. Saturday's though, and expanding...

    January 25, 2012 at 12:35 pm

    #1438390

  • RE: Table design bias to rows or columns

    I have to agree with Sean. Use # 1. First of all, it adheres to the rules of normalization, plus it takes advantage of the fact that you have access...

    January 25, 2012 at 12:33 pm

    #1438386

  • RE: How to output results from a "Execute T-SQL Statement Task" in a Maintenance Plan in SQL 2008

    Try putting the results into a table then reporting off the table.

    January 25, 2012 at 12:30 pm

    #1438385

  • RE: query database for different packages for same employee

    Whenever you have an aggregate of any type in a UNION statement, verify that the datatype for that aggregate is the same in all sections of the UNION.

    0 AS [ADV_EFT]...

    January 25, 2012 at 12:28 pm

    #1438382

  • RE: Notify Operator Task - Unable to set "Notification Message Subject"

    Jeff, I just saw this. Are you sure the issue isn't your connection? I see it set to Local. What happens if you set it to an actual server name?...

    January 25, 2012 at 12:21 pm

    #1438378

  • RE: What is a flat table?

    Layman's explanation. Think of an Excel spreadsheet. Just one page. Now imagine it's filled with your banking information. The first 5-7 columns are your customer names and addresses, the next...

    January 25, 2012 at 12:18 pm

    #1438373

  • RE: Match Canceling Records

    I would be tempted to look at the code that enters the transactions and see if there is anything there that can be cribbed into your solution. But aside from...

    January 25, 2012 at 11:54 am

    #1438354

  • RE: Are the posted questions getting worse?

    jcrawf02 (1/25/2012)

    Steve Jones - SSC Editor (1/25/2012)

    SQL Kiwi (1/24/2012)

    Steve Jones - SSC Editor (1/24/2012)

    But you can ski?

    I tried snowboarding once (in a supervised inside environment[/url]) and that was enough to...

    January 25, 2012 at 11:40 am

    #1438348

  • RE: SQL Developer licensing

    Andrew Collins (1/25/2012)

    I have not said microsoft have told me i could use the data this way.

    The reason i started this thread was beacuse i wanted to find out if...

    January 25, 2012 at 11:39 am

    #1438347

  • RE: SQL Developer licensing

    GilaMonster (1/25/2012)

    Brandie Tarvin (1/25/2012)

    I hate to break it to you, but there is no good excuse you can give Microsoft for using live data in report development. You can, as...

    January 25, 2012 at 10:35 am

    #1438317

  • RE: SQL Developer licensing

    SQLKnowItAll (1/25/2012)

    Brandie Tarvin (1/25/2012)

    mean that replication is an acceptable DRS.

    For my own understanding... I assume you mean database DR, as I can see this being an acceptable solution for site...

    January 25, 2012 at 10:10 am

    #1438307

Viewing 15 posts - 4,786 through 4,800 (of 9,707 total)