Viewing 2 posts - 1 through 2 (of 2 total)
Nice article. You can actually drop the cursor completely and replace with the following
DECLARE @fields nvarchar(4000)
DECLARE @values nvarchar(4000)
SET @fields = ''
SET @values = ''
SELECT @fields = @fields+...
December 29, 2008 at 9:03 am
#918419
It is also possible to do the query with just left joins,
SELECT a.PersonID, a.Version , a.dedate,
[is improper] = CASE WHEN MAX(c.version) IS NOT...
November 13, 2008 at 5:01 am
#897991