Forum Replies Created

Viewing 7 posts - 76 through 82 (of 82 total)

  • RE: A Lack of SQL

    As was the case with me, I expect that many programmers not initially familiar with T-SQL, who start working on the platform will get exposed and then begin to harness...

  • RE: The More Things Change ...

    Have we been prepared to handle change?

    The formula in college is first a program of general classes and then later more specialty classes. The Microsoft certification I'm working on seems...

  • RE: You Are a Professional, So Speak Up

    Technical personnel are not always invited to help solve a mission-critical business problem during the initial brainstorming stage. They're often involved later when they can be assigned specific tasks and...

  • RE: Owning the Spelling Suggestion Feature

    Regarding number of round trips... In my implementation of spell suggestion, I use a single stored procedure call which uses a single T-SQL statement using a set-based approach even though...

  • RE: UPDATE statement that creates duplicate records

    I actually verified that there were duplicates. The row count was unexpected. So I followd up with a query checking for duplicates - you know - with a GROUP BY...

  • RE: UPDATE statement that creates duplicate records

    No triggers on table B.

  • RE: UPDATE statement that creates duplicate records

    Trigger Code (object names changed for anonymity):

    CREATE TRIGGER u_PartInformation ON PartInformation FOR UPDATE

    AS

    -- Propagate updates to description fields.

    IF UPDATE(part_num) OR UPDATE(headline_id) OR UPDATE(epd) OR UPDATE(catalog) OR...

Viewing 7 posts - 76 through 82 (of 82 total)