Forum Replies Created

Viewing 15 posts - 2,146 through 2,160 (of 3,232 total)

  • RE: Urgent! - How to extract number from a string

    OK, so can you define in English exactly what you want?  Are you looking for all numeric characters prior to the first blank character ' '?  Or all numeric characters...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    August 22, 2007 at 10:04 am

    #728628

  • RE: Urgent! - How to extract number from a string

    I'm sure you will find as many methods to do this as there are developers/DBAs, but this should work for you.  Feel free to put this into a UDF for...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    August 22, 2007 at 9:56 am

    #728624

  • RE: BULK INSERT Error

    From a command prompt, run bcp -v to get your version number.  Please post it.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    August 17, 2007 at 3:51 pm

    #727769

  • RE: SQL Server not utilizing free memory

    If you are running SQL Server on any account other than the system account, make sure that you've granted that user the 'lock pages in memory' right.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    August 16, 2007 at 3:54 pm

    #727510

  • RE: Odd return results - problem with query?

    That's a first!  Well, you beat me to post # 3709.....

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    August 12, 2007 at 10:01 pm

    #726356

  • RE: Help getting rid of sql default tables

    I agree Remi, the likeliness of this being a joke is quite high and Adam’s advice is not advice at all.  I guess I just...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    August 10, 2007 at 4:05 pm

    #726227

  • RE: Urgent Help Needed!!!!

    Let's all continue this in the other thread please as it seems to be more productive.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    August 10, 2007 at 3:52 pm

    #726219

  • RE: Help getting rid of sql default tables

    Adam,

    I'm just curious here but why would he need to re-install SQL Server if he's only effected a user table?  I can see if he were to have deleted...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    August 10, 2007 at 3:51 pm

    #726217

  • RE: Urgent Help Needed!!!!

    Please see my post in your other thread:

    http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=389804

     

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    August 10, 2007 at 3:30 pm

    #726209

  • RE: Help getting rid of sql default tables

    Ryan,

     

    Although what you are attempting to do here is quite shocking, I’m not sure that deserves a...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    August 10, 2007 at 3:27 pm

    #726207

  • RE: Odd return results - problem with query?

    Terrence,

    Your query may produce unwanted results.  First of all, you don't need the self-join.  How do I know this?  Well, you are not using table B for any reason...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    August 10, 2007 at 2:19 pm

    #726167

  • RE: Heap tables with lots of unused space

    Well, I totally agree with you assessment from your #2 in that since there is no CI and therefore no direct link to the data page, SQL Server scans...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    August 10, 2007 at 1:59 pm

    #726164

  • RE: need help in query

    Well, if there are 3 addresses for the client, your query will return the client data along with the 3 different addresses, but I would not consider this duplicate data. ...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    August 10, 2007 at 7:20 am

    #725988

  • RE: unique top record

    Have you given my query a shot yet?

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    August 9, 2007 at 8:46 am

    #725750

  • RE: Rows missing in results

    Nested cursors….awesome!  How many hours does this take to run on your 70,000 rows?  Since this is your first time here, I won’t be to...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    August 8, 2007 at 3:03 pm

    #725538

Viewing 15 posts - 2,146 through 2,160 (of 3,232 total)