Forum Replies Created

Viewing 15 posts - 55,651 through 55,665 (of 59,078 total)

  • RE: PATINDEX bug?

    Thanks for the feedback, Kung Lao.

    July 25, 2007 at 6:23 pm

    #722451

  • RE: Rollup information within a table

    Is GROUP BY what you're looking for?

    July 25, 2007 at 7:33 am

    #722275

  • RE: Parsing string

    This sounds like the text version of a "name/value" table... I'm with MrPoleCat... if you could post a bit of the text table, perhaps we could help.

    July 25, 2007 at 7:32 am

    #722272

  • RE: Problem with Date

    I don't know what sqlcomm1.ExecuteNonQuery() does because I'm no GUI programmer... UPDATE's are actually a form of a query and that may be your problem (but dunno for sure).  But...

    July 25, 2007 at 6:54 am

    #722253

  • RE: How to get DELETED data from log ?

    Heh... and I just "assumed"... we all know what happens when you do that, eh

    July 25, 2007 at 6:34 am

    #722243

  • RE: tempdb size increased !

    Well... that depends... do you want to shrink the file or not?  The NOTRUNCATE causes the "freed file space to be retained in the files".  If you want to actually...

    July 25, 2007 at 6:29 am

    #722240

  • RE: tempdb size increased !

    Heh... not unless some fool thought it would be a good place to store permanent data

    July 25, 2007 at 6:19 am

    #722234

  • RE: Recurring values

    Sum of the quantities for a given part.  Quantity is add if the RowType is 'Receive', Quantity is subtracted if the RowType is 'Issue'.  Another name for 'RunningBalance' might be...

    July 25, 2007 at 6:15 am

    #722233

  • RE: Recurring values

    Haven't figured out the long term/shorterm things yet, but here's some more realistic data to play with... created a single "work" table just to help imagine what's being received and...

    July 24, 2007 at 11:18 pm

    #722128

  • RE: Recurring values

    Heh... I think you're making a mistake using FLOAT on the RATEs (which I assume will be currency amounts of some sort).  If you don't think so, try this...

    July 24, 2007 at 10:48 pm

    #722123

  • RE: Recurring values

    Heh... I just noticed that the dates in the example data are in the "dmy" format which means the examples posted are not in the correct date order and the...

    July 24, 2007 at 9:42 pm

    #722115

  • RE: Problem with Date

    Chaitra,

    Any feed back on this?  Was that the problem or something else?

    July 24, 2007 at 8:54 pm

    #722111

  • RE: Recurring values

    Oh shoot... although the answer to the formula above may have originally been posted incorrectly, I think I finally get this process that you're looking for...  Not sure what the...

    July 24, 2007 at 8:38 pm

    #722110

  • RE: Recurring values

    And, sorry, I'm still not getting it... (2(20)+2(20-15)) = 50... not 45... True?

    July 24, 2007 at 8:24 pm

    #722109

  • RE: Rounding numeric data

    You bet.  Thank you for the feedback, Ram.

    July 24, 2007 at 8:13 pm

    #722107

Viewing 15 posts - 55,651 through 55,665 (of 59,078 total)