Viewing 2 posts - 1 through 2 (of 2 total)
@Zuber: Check out PIVOT, which will do what you're after. http://msdn.microsoft.com/en-us/library/ms177410.aspx
Alternatively you might be better doing that clientside with a transpose or equivalent, depending on the language.
January 24, 2012 at 4:09 am
A nice idea, but your trigger relies on the fact that you would only ever delete one product at a time. You'd have to be very careful about other procedures...
June 9, 2010 at 5:24 am