[thelist] ASP.NET: UNION query not returning expected results
Joel D Canfield
joel at streamliine.com
Thu Sep 27 17:04:39 CDT 2007
> if you then apply a filter after the result set has been returned, all
> offices from the first SELECT except (maybe) one will be removed
>
> this just seems ~so~ in line with microsoft's approach to things...
astute observation
hey, Tab points out that SQL allows these things called 'stored
procedures' that might do me up nicely
'cept, how would I convince it not to apply the filter to the returned
results?
I dislike enormously the way .NET manages this stuff, and I wish the
client wasn't a) an excellent payer and b) a good friend or I'd abandon
this for happier things
joel
More information about the thelist
mailing list