Search results for query: *

Well if have you have dealt with a Peoplesoft team within a company asking them to provide data to a subscriber application you will know why at times you have to get stuck with this inefficient database design.

I see what you are saying but imagine the managebility and readbility of the code when the table can contain around 90 columns :( pfe

Any takers?

There are cursors defined which will handle the case where multiple rows get updated. pfe

any help here? pfe

When you created the DTS package, at the final step there will be an option which says Run Immediately (which is selected by default). In the same page there are a couple of other options which gives you the flexibility to schedule the DTS to run at any desired time.

Druer, There is a meta directory which subscribes to data from SQL (which has a dump od Peoplesoft data). The software piece (here by call it connector) which actually bridges SQL data and meta directory data needs to know which columns got updated for a record so that it does not spend time...

Hello All, I'm new to SQL programming and was looking for some help ... There is an update trigger on a table which does SELECT * INTO #DELETED FROM DELETED (so that the old value is captured)initially and later at some point in the logic, the name of the updated column is determined and...