Home Forums SQL Server 2005 Development Global Temp Tables: Triggers Vs Stored Procedure RE: Global Temp Tables: Triggers Vs Stored Procedure

  • If by 'helping you out' you mean 'write it for you' then...no - not me 😛

    (I already have a job!)

    The best way to learn stuff is to take an idea and experiment with it. Create a table variable, start a transaction, insert some data into it, and then roll back your transaction. Finally, select everything from the table variable.

    That should give you an idea how to proceed. If you get stuck, post back with your best attempt so far, and why you are stuck.

    Paul