Forum Replies Created

Viewing post 1 (of 2 total)

  • RE: View data is inconsistent

    The view is automatically generated by third-party software based on a web form definition we create and is defined as follows:

    CREATE view [dbo].[DallasMobile] (

    SalesResult,RejectionStage0,RejectionStage1,RejectionStage2,RejectionNotes,

    DoNotContactReason,BusinessName,ProbabilityIndex,AccountType,FollowUpDateIndex,

    StreetNumber,ESIID,NoOutcomeReason,FollowUpDate,SwapDiscountPct,Notes,Priority,

    Result,ProbabilityToClose,SwapDiscountValue,FollowUpTime,SICDescription,

    StreetName,LastUpdateDate,ContactFirstName,ContactLastName,TerritoryID,City,

    EstimatedUsagekWh,FollowupContactFirstName,PriceperkW,PriceperkWh,

    FollowupContactLastName,REP,State,JobTitle,ContactTelephoneNumber,Zip,

    ContractExpirationDate,FollowUpNotes,PerkWhAveragePrice,NumberofTimesContacted,

    LastDateWithTXUE,ContactFaxNumber,RelatedLocations,RelatedLookupRecordNumber,

    ActionItemId, RecordId, CreatedAt, CreatedBy, LastModifiedAt, LastModifiedBy,

    CurrentStateName)

    with SCHEMABINDING

    as...

Viewing post 1 (of 2 total)