Forum Replies Created

Viewing 15 posts - 7,366 through 7,380 (of 18,926 total)

  • RE: Sum Null values

    rkaria (1/7/2011)

    rkaria (1/7/2011)

    This worked a treat for all the totals that i am using....thank you so much for your help.

    this was for ninja RGR_US

    You're welcomed.

    January 7, 2011 at 7:08 am

    #1270636

  • RE: Can't Replace Blank Value on a NVARCHAR

    steveb. (1/7/2011)

    from books on line

    string_pattern

    Is the substring to be found. string_pattern can be of a character or binary data type. string_pattern cannot be an empty string ('').

    Or put another...

    January 7, 2011 at 7:07 am

    #1270634

  • RE: Can't Replace Blank Value on a NVARCHAR

    UDPATE T SET Weight1 = '0' from dbo.tTable1 WHERE Weight1 = ''

    Also it might be worth it to convert that column to an integer or decimal. Then keep the...

    January 7, 2011 at 7:06 am

    #1270633

  • RE: Procedure and sys tables

    What are you trying to do exactly (the bigger project).

    You cannot use a variable for the db name. It has to be dynamic sql.

    January 7, 2011 at 7:04 am

    #1270630

  • 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

    Does this work for you?

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

    You could also try cdbl instead of val.

    January 7, 2011 at 6:27 am

    #1270600

  • RE: Sum Null values

    Could also be SQL server with Access as front end....

    That message is always a cast error or an error in the formula.

    January 7, 2011 at 6:08 am

    #1270591

  • RE: utility

    Sounds like shared hosting w/o admin access.

    January 6, 2011 at 8:24 am

    #1270129

  • RE: Tackle the Question of the Day on your cell phone

    Seems to work from my laptop as well... talk about your big bonuses :hehe:.

    January 6, 2011 at 7:51 am

    #1270104

  • RE: I want to edit SSRS Projects Remotely

    The bids project can be on a shared drive, accessible from everywhere.

    January 6, 2011 at 7:48 am

    #1270100

  • RE: Goals

    Steve Jones - SSC Editor (1/4/2011)

    For those of you setting weight goals, I'd discourage that. I think you ought to work on your health, and trying to get to the...

    January 6, 2011 at 7:44 am

    #1270095

  • RE: DB Reverts to Single-User Mode

    Ninja's_RGR'us (1/5/2011)

    Hmm, why the heck didn't I think of that???

    Yup, just open the trace file, script it out, disable the default trace and run that one of startup and we're...

    January 5, 2011 at 11:41 am

    #1269672

  • RE: DB Reverts to Single-User Mode

    Hmm, why the heck didn't I think of that???

    Yup, just open the trace file, script it out, disable the default trace and run that one of startup and we're done.

    January 5, 2011 at 11:32 am

    #1269668

  • RE: DB Reverts to Single-User Mode

    ALZDBA (1/5/2011)

    I must admit I haven't heart of such a setting to controle the file size for the default trace, nor did I search for it in sqlserver.

    The easiest way...

    January 5, 2011 at 9:54 am

    #1269607

  • RE: TRUNCATE in TRANSACTION

    cengland0 (1/5/2011)

    Ninja's_RGR'us (1/5/2011)

    Spin it however you want it, young 40+ years ago, AND programming, is still not young today :w00t:.

    My first exposure to computers was a mainframe using magnetic core...

    January 5, 2011 at 9:16 am

    #1269582

  • RE: Parameters SSRS- BIDS

    I don't have bids 2008 here so I can't give you a screenshot nor look arount. AFAIK, the parameters are also available in the same treeview as the datasets.

    January 5, 2011 at 9:13 am

    #1269579

Viewing 15 posts - 7,366 through 7,380 (of 18,926 total)