Forum Replies Created

Viewing 15 posts - 4,456 through 4,470 (of 5,356 total)

  • RE: float problems (with front-end Java app.)

    Hi Michelle,

    sorry, just came across your response.

    quote:


    However, our test data was inserted for that example as: 0.054, but when a quick SELECT...

  • RE: Not Rounding

    Hi Mani,

    quote:


    Are u saying that he best solution is to change the datatype to decimal to get high precision.


    July 29, 2003 at 12:40 am

    #467400

  • RE: How do you handle logins and groups

    Hi Ron,

    quote:


    We create the NT Groups, assign the groups to SQL Server with the permissions needed by the groups. The users...

  • RE: Not Rounding

    Hi Mani,

    quote:


    Here are three statements

    1.SELECT A.RetailPrice * F.salesQuantity FROM StockDept A .....

    Result 29.989999999999998

    2. select round(29.989999999999998,2)

    Result 29.990000000000000

    3.SELECT round(A.RetailPrice * F.salesQuantity,2) ...

  • RE: Variable Issue

    Hi Nelson,

    quote:


    What I'm doing is.

    other server creates a TXT file from all records and save it as ex: file name 07300300.15S, so...

  • RE: Variable Issue

    quote:


    Ex: suppose the number found is 15

    so I need it understand 15.S


    so, you have...

  • RE: Variable Issue

    Hi Nelson,

    quote:


    I have this command line and I need said that '@@' can be any number between 01 and 99

    how I do...

  • RE: Dynamic Columns

    quote:


    Sorry Frank, is that better.


    Hi David,

    that's an inherent error in the forum software, it...

  • RE: sql 2000 and sql 7

    quote:


    Yes, I have full permissions on SQL 7 server.


    ok, I guess someone else will come...

  • RE: sql 2000 and sql 7

    quote:


    Yes, the value is <> 0

    this is the hardware situation.

    Server A: windows 2000, SQL 2000

    Server B: windows NT, SQL 7


  • RE: sql 2000 and sql 7

    quote:


    about 74000 rows, but I get timeout when I execute the query.


    not that much, did...

  • RE: sql 2000 and sql 7

    quote:


    The query is just a simple "Select * from [SQLserver7].database.dbo.table".


    How many rows are to be...

  • RE: sql 2000 and sql 7

    Hi qwerty,

    quote:


    I have performance problem when I create a select from sql 2000 into sql 7

    How can I solve this problem


  • RE: weekly report

    quote:


    the intention was humor...it's monday morning, i'm sitting in this hole-of-a-cube at this suck-ass job, and i really need some...if you'd like...

  • RE: weekly report

    quote:


    it's clint all right, and it don't need no elaboration...! 🙂


    come on, bear with...

Viewing 15 posts - 4,456 through 4,470 (of 5,356 total)