Forum Replies Created

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

  • RE: Distinct on Geographic

    Create a CTE that has a ROW_NUMBER column, and then select rows where that column = 1 ROW_NUMBER() = 1

    WITH src AS (

    select

    z.country,

    z.city,

    z.state,

    z.Country,

    z.GeogCol1,

    z.GeogColTemp,

    z.zipcode,

    l.data_date,

    l.loan,

    l.mtgrlastname,

    l.mtgrfirstname,

    l.propertystreetnum,

    l.propertydirection,

    l.propertystreet,

    l.cityname,

    l.propertystate,

    ROW_NUMBER() OVER (PARTITION BY l.propertynumber, l.propertystreet,...

  • RE: How to Discover the T-SQL Command that Causes a Trigger to Fire

    Thanks--that does the trick. Here's the trigger for posterity. It writes the length of a text field before and after the update into another table. Also grabs the...

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