Forum Replies Created

Viewing 15 posts - 4,126 through 4,140 (of 5,356 total)

  • RE: Frank

    quote:

    Any peer pressure to change? I’ll stay a purist (numbers guy)

    August 25, 2003 at 2:08 am

    #471169

  • RE: SQL Query converting fields

    quote:

    Please find the sample data

    I000000068-86814.0

    I000000068-450000.0

    I000000068-600000.0

    I000000068-1050000.0

    I000000068-200.0

    I000000069-100000.0

    I000000069-67066.0

    I000000069+450000.0

    I000000069+4028.0

    I000000069-2100000.0

    I000000069-2100000.0

    I000000069-2100000.0

    I000000070-1.3

    I000000070-221.56999999999999

    I000000070-2.5499999999999998

    I000000074-0.23000000000000001

    I000000076-0.40999999999999998

    I000000078-0.23000000000000001

    I000000078-0.65000000000000002

    I000000078+5.0000000000000003E-2

    I000000078+0.65000000000000002

    I000000082-2.9999999999999999E-2

    I000000082-4.0000000000000001E-2

    I000000086-0.01

    I000000086-5.0000000000000003E-2

    I000000090+0.0

    I000000163+0.5

    I000000571-0.80000000000000004

    I000000581-0.11

    I000000583-0.67000000000000004

    I000001165-0.35999999999999999

    I000001364+0.0

    I000001544+0.90000000000000002

    I000001589+0.90000000000000002

    I000001611-0.0

    I000001691-0.28999999999999998

    I000001737-0.82999999999999996

    I000001745-0.53000000000000003

    I000001768-0.33000000000000002

    I000001769-0.66000000000000003

    I000001807+0.0

    I000001970+0.0

    I000001990-0.5

    I000002666+0.01

    I000002737+0.67000000000000004

    I000002739-0.5

    I000002775-0.12

    I000003284+0.01

    I000003284+0.01

    I000003284+0.01

    I000003284+0.63

    I000003333-0.98999999999999999

    I000003333+0.02

    I000003333-0.01

    I000000069-2100000.0

    I000000069-2100000.0

    I000000069-2100000.0

    from this sample data you've provided, numeric wasn't your first chosen...

    August 25, 2003 at 2:04 am

    #471167

  • RE: database generation script

    quote:

    It looks like the script is to long (because of all the inserts we have for the data), and it is truncated...

    August 25, 2003 at 1:51 am

    #471165

  • RE: SQL Query converting fields

    quote:

    Thanks for the reply, i tried

    Select ItemId, AddSub,Qty, Cast(Qty as numeric(8,4))

    From InventoryAdjustmentDetail

    It gave me this error

    Arithmetic overflow error converting float to data...

    August 25, 2003 at 1:26 am

    #471160

  • RE: database generation script

    And what's the error you get from scripting the db?

    Cheers,

    Frank

    August 25, 2003 at 1:24 am

    #471158

  • RE: database generation script

    Hi Nicolas,

    quote:

    We've tried to use the SQLserver script generation tool, with no success.

    The database is not so big but each time...

    August 25, 2003 at 1:17 am

    #471155

  • RE: SQL Query converting fields

    Hi agarwalshailesh,

    quote:

    I have a table with structure as follows

    Column Name data typedescription

    ItemID char(10)

    AddSub ...

    August 25, 2003 at 1:13 am

    #471154

  • RE: How to Fix Inconsistent Metadata Errors

    Hi James,

    quote:

    Sorry Ken I have been out with a new baby and not doing much of anything.

    August 25, 2003 at 12:40 am

    #471152

  • RE: Initiate a program

    Hi John,

    what is this VB programm supossed to do?

    I think you should go for 5409045121009 (who is he? ) suggestion.

    Cheers,

    Frank

    August 25, 2003 at 12:34 am

    #471150

  • RE: Searching in Tables.

    Hi Steve,

    quote:

    I am a novice, can anyone show or tell me or have any examples on how to search for...

    August 25, 2003 at 12:22 am

    #471146

  • RE: Goodbye from: mssqlserver@topica.com

    Oops, and I forgot.

    The one with the most traffic is SQL2k. The other ones are VERY low traffic lists

    Cheers,

    Frank

    August 25, 2003 at 12:14 am

    #471145

  • RE: Goodbye from: mssqlserver@topica.com

    Hi spongemagnet and BrenBart,

    forget topica !!!!!!!

    The lists are not hosted there any more.

    The list have moved to

    http://ls.sswug.org/cgi-bin/lyris.pl?site=sswug&page=topic&topic=sql_server&text_mode=0&lang=english

    But I wonder, if you had been on the lists before, you were...

    August 25, 2003 at 12:12 am

    #471144

  • RE: Junior and Senior DBAs

    So, a senior DBA isn't working the whole day deep inside the DBMS, but rather taking care that everything else is going its normal way?

    And when the junior DBA comes...

    August 25, 2003 at 12:07 am

    #471142

  • RE: A virtual drink for everyone !!!

    Hi Len,

    quote:

    Bonus of virtual money

    NO VIRTUAL MONEY.

    The bonus is half that...

    August 24, 2003 at 11:56 pm

    #471140

  • RE: A virtual drink for everyone !!!

    Hi Calvin,

    quote:

    Congrats, Frank. EOTM, huh; good stuff. Hope they gave you a phat bonus.

    Tonight I'll barbecue a bratwurst in your...

    August 24, 2003 at 11:49 pm

    #471139

Viewing 15 posts - 4,126 through 4,140 (of 5,356 total)