I have a table with four columns a CampaignRecipientID column,CampaignRecipientKey column,datetime created column and a datetime updated column. I want to store a count which gets incremented by 1 whenever the DateTime field is updated. Ideally I would like to store this information in a separate database in a table with the following columns
Is it possible to write a trigger to achieve this ? And if so how ?
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs).
Being someone who is always looking for alternatives to "work your data", I came across this …