Posted by Greg D. Moore \(Strider\) on 11/26/07 13:09

"Bart op de grote markt" <warnezb@googlemail.com> wrote in message
news:3e7b897e-7ff7-436f-9291-adc2ab732c32@s36g2000prg.googlegroups.com...
> On 25 nov, 19:59, --CELKO-- <jcelko...@earthlink.net> wrote:
>> >> I guess there is no function to do this... What is the simplest
>> >> solution? <<
>>
>> Do it in the front end instead violating 1NF in the Database side.
>
> Hi,
>
> I'm not an expert in that area, but I thought NF had to do with
> database design and not with querying a database? Correct me if I'm
> wrong.

You're "wrong".

You can't really separate the two. That's like saying that wheels on a car
have to do with the design, not with the actual driving.

If you design your database properly, your queries follow from that.


>
> I would like most of the logic on server side, (the report result is
> retrieved by an excel report that mainly adds lay-out and adds the
> possibility to further process the results) because when an update of
> the report is needed, I only need to change the stored procedure and
> not the 'front-end' excel reports with everybody that uses it.
>

Then do it in a middle layer. What happens when your DB changes for other
reasons but your reports aren't supposed to?


>
> Kind regards,
>
> Bart



--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

[Back to original message]