Forum Replies Created

Viewing 11 posts - 1 through 11 (of 11 total)

  • RE: Updating a table column

    David's SQL worked for me

    Thanks David

  • RE: help w/ trimming column

    update mci_geocodable set zipcode_2  = left(zipcode_2,5)

    error "left" invalid identifier

    the '0000' part isn't important as long as I get rid of those last 4 characters, just that 90% of the zip...

  • RE: help w/ trimming column

    Thanks for everyones help I really do appreciate it...

    They are US zip codes, sorry for not clarifying that earlier...

    I'm still not having any...

  • RE: help w/ trimming column

    Here's the first version that I tried...

    update mci_geocodable set zipcode_2 = left(zipcode_2,9(zipcode_2) - 4) where right(zipcode_2,4)='0000'

    Question??? what is this sql statement supposed to do???  1) create a new column and and populate it....

  • RE: help w/ trimming column

    I'm using your statment... I'm not sure if I have an extra space some where or what, it looks like all of your parenthesis are closed.

  • RE: help w/ trimming column

    varchar...

    I keep getting a missing right parenthesis error for some reason.

    Thanks

  • RE: SQL Limits and Suspect databases

    What's a "t/a" ?

    Would having a second .mbf make the database run more effeciently. Also when I looked at the Server error log I...

  • RE: SQL Limits and Suspect databases

    Torn page detection is on, I'll turn it off and see how things go...

    When you mention the tempdb do you mean the file \\Program Files\Microsoft SQL Server\ServerName\Data\tempdb.mdf file?

    Thanks....

  • RE: SQL Limits and Suspect databases

    Thanks for anserwing my question

    I've tried the sp_resetstatus procedure but I get an error saying I cann't Alter my database because it is "Suspect" when...

  • RE: Cannt setup/write to SAN

    The 2000 server box is mapped, I can see it in explorer and my computer. I was even able to copy something into it using exporer. SQL just can't see...

  • RE: Cannt setup/write to SAN

    Ron,

    It is connecting through TCP and the 2000 box is a front end to local disks.

    Thanks, Meredith

Viewing 11 posts - 1 through 11 (of 11 total)