Forum Replies Created

Viewing 15 posts - 91 through 105 (of 279 total)

  • RE: extract the number before %

    You could just query on WHERE score > '80%'

    "greater than" will be calculated alphabetically here. Presuming your data is as one would expect, ie values between 0% and 100%

    Not sure...

    ------------------------------------------------------------------------
    Bite-sized fiction (with added teeth) [/url]

  • RE: Sum Null values

    rkaria (1/7/2011)


    its a calulated field.

    =iif(Fields!valuehome.Value>0,Fields!valuehome.Value,"0.00")

    Not sure where to define what type of field it is

    Assuming valuehome is a numeric type, then wrapping 0.00 in quotes would be trying to put...

    ------------------------------------------------------------------------
    Bite-sized fiction (with added teeth) [/url]

  • RE: Sum Null values

    rkaria (1/7/2011)


    Hiya

    its just shows as '#error' in the cell.

    It is pounds values

    (bold font added by me)

    Is this in SQL Server? Or Excel?

    ------------------------------------------------------------------------
    Bite-sized fiction (with added teeth) [/url]

  • RE: "Backup detected log corruption in database. Context is Bad End Sector"

    Thanks again Paul.

    There's a lot more reading that I need to do...

    ------------------------------------------------------------------------
    Bite-sized fiction (with added teeth) [/url]

  • RE: "Backup detected log corruption in database. Context is Bad End Sector"

    Another question, if I may - the logs of those databases have been successfully backing up since the failed one.

    If they are still corrupt, how come all the rest of...

    ------------------------------------------------------------------------
    Bite-sized fiction (with added teeth) [/url]

  • RE: "Backup detected log corruption in database. Context is Bad End Sector"

    Thanks Paul

    I'll run the FULL>SIMPLE>FULL switch and hopefully set the ball rolling on the rest of it

    ------------------------------------------------------------------------
    Bite-sized fiction (with added teeth) [/url]

  • RE: "Backup detected log corruption in database. Context is Bad End Sector"

    Thanks Gail, much appreciated

    ------------------------------------------------------------------------
    Bite-sized fiction (with added teeth) [/url]

  • RE: "Backup detected log corruption in database. Context is Bad End Sector"

    These are native backups. DPM is also used, although for some reason that is not part of the DBA team's responsibilities so I don't know much about them

    ------------------------------------------------------------------------
    Bite-sized fiction (with added teeth) [/url]

  • RE: Need help on Microsoft SQL Server 2008 R2 Service Pack

    SQL Server 2008 and SQL Server 2008 R2 are different versions of SQL Server in the "proper" sense, despite the similar names. Therefore SP1 for SQL Server 2008 (non-R2)...

    ------------------------------------------------------------------------
    Bite-sized fiction (with added teeth) [/url]

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (12/9/2010)Trying to finish a first draft of a short story first.

    Do you find that preoccupation with things techy stops the creative streak at all? When I'm having...

    ------------------------------------------------------------------------
    Bite-sized fiction (with added teeth) [/url]

  • RE: Error when configuring SQL job step to execute powershell script

    Ah, they're the best kind of issues 🙂

    ------------------------------------------------------------------------
    Bite-sized fiction (with added teeth) [/url]

  • RE: Error when configuring SQL job step to execute powershell script

    Do you get an error if you set it up as a CmdExec jobstep that executes

    powershell c:\myfilepath\script.ps1

    Well, obviouslyyou won't get an error while creating the job step in...

    ------------------------------------------------------------------------
    Bite-sized fiction (with added teeth) [/url]

  • RE: SSIS and SQLAgent problems saving file to mapped drive when run as job

    ... and we have lift-off!

    Many thanks again

    ------------------------------------------------------------------------
    Bite-sized fiction (with added teeth) [/url]

  • RE: SSIS and SQLAgent problems saving file to mapped drive when run as job

    Thank you both.

    I will set up UNC paths and see how that goes.

    ------------------------------------------------------------------------
    Bite-sized fiction (with added teeth) [/url]

  • RE: VB.Net or Not

    Having used both, C# wins hands down for me. Much cleaner syntax!

    ------------------------------------------------------------------------
    Bite-sized fiction (with added teeth) [/url]

Viewing 15 posts - 91 through 105 (of 279 total)