[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