Home Forums SQL Server 2008 SQL Server 2008 Administration Insert into a table when new record RE: Insert into a table when new record

  • April 5, 2013 at 1:12 pm

    #1604099

    johnnyrmtl (4/5/2013)

    I apologize for the vagueness 🙂

    What I have is table1 which has been imported externally with 4 fields including an (AccountDescription) field

    srvnameAccountAccountDescriptionDATE_CREATION

    -----------------------------------------------------------------------------

    I need to be able to copy only 3 fields from another similar table whenever a new record is added as less the (AccountDescription) ,the data in this field is manually entered by me

    srvnameAccount DATE_CREATION

    I hope it's clearer

    I will go with no. At least to me it is much less clear than it was previously. ddl for the two tables and an explanation would go a long way here.

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/