Forum Replies Created

Viewing 15 posts - 2,626 through 2,640 (of 15,381 total)

  • RE: Synchronise table on remote server via update trigger failing

    andrew gothard (7/21/2015)


    Hi all,

    I have the following scenario.

    We have a database on a 2005...

  • RE: http://naturerenewfacts.com/metabo-223x/

    spam reported. no replies please.

  • RE: T sql

    Lynn Pettis (7/17/2015)


    Sean Lange (7/17/2015)


    eboucicaut (7/17/2015)


    Hi Guys,

    how can I use words reserved in selected t sql, as Select GROUP, DESC, EXTERNAL, etc ..., i use thems with a linked server,...

  • RE: T sql

    eboucicaut (7/17/2015)


    Hi Guys,

    how can I use words reserved in selected t sql, as Select GROUP, DESC, EXTERNAL, etc ..., i use thems with a linked server, i have a error...

  • RE: Comparing tables for Like values

    slevin37 (7/17/2015)


    Sorry about that; Let me try to explain the whole purpose:

    We have a raw data file with mapped supplier names. These "normalized" mapped names are not exact matches to...

  • RE: Comparing tables for Like values

    slevin37 (7/17/2015)


    Sean Lange (7/17/2015)


    slevin37 (7/17/2015)


    Sure thing. For now, all i'm trying to do is select the fields from both to compare them and see how much different the spellings are:

    Declare...

  • RE: Comparing tables for Like values

    slevin37 (7/17/2015)


    Sure thing. For now, all i'm trying to do is select the fields from both to compare them and see how much different the spellings are:

    Declare @supplier varchar(255)

    Set...

  • RE: Comparing tables for Like values

    slevin37 (7/17/2015)


    Alvin Ramard (7/17/2015)


    A couple of things that may help.

    First do a Google search for "Fuzzy SQL Match". Some of the results might be helpful.

    Second, I've have to do something...

  • RE: Comparing tables for Like values

    slevin37 (7/17/2015)


    Hello,

    First post on this site; and its been a great tool for me, but I havent been able to find exactly what Im looking for so Im posing...

  • RE: Are the posted questions getting worse?

    ChrisM@Work (7/17/2015)


    Sean Lange (7/16/2015)


    SQLRNNR (7/16/2015)


    Sean Lange (7/16/2015)


    Another thing to do in Seattle...of course the NW is known for having lots of microbreweries but what often goes unmentioned is that many...

  • RE: Are the posted questions getting worse?

    SQLRNNR (7/16/2015)


    Sean Lange (7/16/2015)


    Another thing to do in Seattle...of course the NW is known for having lots of microbreweries but what often goes unmentioned is that many of them also...

  • RE: Function that replaces multiple values.

    pinky (7/16/2015)


    There may be more than 100 list of values that i may need to replace. I am reluctant to use Nested replace as its a big list. I was...

  • RE: Function that replaces multiple values.

    pinky (7/16/2015)


    Hello,

    I have created the below function and apply it on a column in a table to replace the below identified values with Blank. It works fine but i have...

  • RE: Row locks not escalating to table locks after 5000

    10 million rows across a link server is going to be slow no matter how you do it. I would suggest that doing your inserts in batches would be a...

  • RE: Are the posted questions getting worse?

    Another thing to do in Seattle...of course the NW is known for having lots of microbreweries but what often goes unmentioned is that many of them also make their own...

Viewing 15 posts - 2,626 through 2,640 (of 15,381 total)