create a stored procedure with insert and update using a cursor

  • paul.starr (11/13/2008)


    Does this help any:

    COLUMN NAMES

    CustomerID

    ParentCustomerID

    ParentContactID

    Name

    ShortName

    ReferenceNo

    Logo

    CustomerTypeID

    Templates

    CorpURL

    CorpEmail

    SupportEmail

    SalesEmail

    OtherEmail

    DefaultContactID

    Markup

    DefaultCurrencyID

    PriceListID

    FreightID

    PaymentTypeID

    PaymentTermID

    PaymentTermNotes

    ShippingPolicyID

    CarrierID

    ShippingMethodID

    EffectiveDate

    ExpiryDate

    DefaultTaxRate

    DefaultQuoteDiscount

    DiscountComments

    Notes

    Deleted

    Status

    StatusComments

    StatusChangeDate

    StatusChangeUser

    CreateDate

    CreateUser

    MaintenanceDate

    MaintenanceUser

    LockUser

    LockSessionID

    LockDate

    PriceList_MaintenanceDate

    SyncStatus

    SyncDate

    SyncUser

    DiscountMode

    UpchargeMode

    CreateCustomerID

    CreateContactID

    MaintenanceCustomerID

    MaintenanceContactID

    InUse

    CustomerSalesModel

    CustomerPrefix

    State

    DefaultCustomerAddressID

    DefaultCustomerID

    datatypes, character length

    nvarchar30

    nvarchar30

    nvarchar30

    nvarchar50

    nvarchar20

    nvarchar50

    nvarchar200

    nvarchar30

    nvarchar250

    nvarchar250

    nvarchar50

    nvarchar50

    nvarchar50

    nvarchar50

    nvarchar30

    decimalNULL

    nvarchar30

    nvarchar30

    nvarchar30

    nvarchar30

    nvarchar30

    nvarchar500

    nvarchar30

    nvarchar30

    nvarchar30

    datetimeNULL

    datetimeNULL

    decimalNULL

    decimalNULL

    nvarchar500

    ntext1073741823

    intNULL

    intNULL

    nvarchar500

    datetimeNULL

    nvarchar50

    datetimeNULL

    nvarchar50

    datetimeNULL

    nvarchar50

    nvarchar50

    nvarchar36

    datetimeNULL

    datetimeNULL

    intNULL

    datetimeNULL

    nvarchar50

    intNULL

    intNULL

    nvarchar30

    nvarchar30

    nvarchar30

    nvarchar30

    intNULL

    intNULL

    nvarchar20

    intNULL

    nvarchar30

    nvarchar30

    No. It doesn't. You have to give us something that doesn't require more than cut and paste to use. We have our own jobs to work as well, and unless we are doing this on our own time, we can't be spending extra time doing work you should do up front to make it easier for us to help you.

    Can I ask you something? Have you even really read the article I keep asking you to read?

  • Paul,

    Since you seem to be unwilling to read the post we've tried to send you to a dozen times so far, let me sum up the gist of it to save us all some time.

    If you can't write us a script to completely generate your environment on our own machines that we don't have to do anything to other than copy/paste and run, you might as well stop now, because we're not going to spend the time to modify your zero-effort responses.

    This means, we don't have to add so much as a comma to your code before we have *ALL* tables that are referenced in this issue set up on our machines *AND* populated with sample data. No idea how to do that? Then read the post, and stop posting garbage.

    Seth Phelabaum


    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

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

You must be logged in to reply to this topic. Login to reply