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)

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

    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...

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

    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...

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

    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...

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

    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

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

    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...

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

    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 ...

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

    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.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

    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

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

    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...

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

    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

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

    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...

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

    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...

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

    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...

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

    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...

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

    August 24, 2003 at 11:49 pm

    #471139

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