How can be create a updatable view whit DISTINCT clause? -- sql server new users

Tom Moreau
3/30/2006 12:00:00 AM

You can't. What you can do is create an INSTEAD OF trigger on the view that
does the update for you.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
[quoted text, click to view]
How can be create a updatable view whit DISTINCT clause?

TIA

Dan

sql server new users : How can be create a updatable view whit DISTINCT clause?