Re: [ACFUG Discuss] SQL Server Question

2013-05-22 Thread MCG
...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Jason Delmore *Sent:* Tuesday, May 21, 2013 11:15 AM *To:* discussion@acfug.org *Subject:* Re: [ACFUG Discuss] SQL Server Question ** ** I don't think there is anything wrong with using stored procs over inline SQL to retrieve data

Re: [ACFUG Discuss] SQL Server Question

2013-05-22 Thread Dawn Hoagland
Chattanooga, TN 37405 p 423.267.7375 ** ** *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Jason Delmore *Sent:* Tuesday, May 21, 2013 11:15 AM *To:* discussion@acfug.org *Subject:* Re: [ACFUG Discuss] SQL Server Question ** ** I don't think there is anything

Re: [ACFUG Discuss] SQL Server Question

2013-05-22 Thread Steven
:15 AM *To:* discussion@acfug.org *Subject:* Re: [ACFUG Discuss] SQL Server Question ** ** I don't think there is anything wrong with using stored procs over inline SQL to retrieve data. However, in my view of the world this is application behavior and not reporting. Application behavior

Re: [ACFUG Discuss] SQL Server Question

2013-05-22 Thread Frank Moorman
mailto:discussion@acfug.org *Subject:* Re: [ACFUG Discuss] SQL Server Question I don't think there is anything wrong with using stored procs over inline SQL to retrieve data. However, in my view of the world this is application behavior and not reporting

[ACFUG Discuss] SQL Server Question

2013-05-21 Thread MCG
Yes it's been a while, but I've gotten pulled into database design, and this group has always been the best place to turn to for technical knowledge. The team here inherited a crap database, over 200+ tables for an unexciting claim system, and is now adding new features. Yes, views are better

Re: [ACFUG Discuss] SQL Server Question

2013-05-21 Thread Jason Delmore
I don't think there is anything wrong with using stored procs over inline SQL to retrieve data. However, in my view of the world this is application behavior and not reporting. Application behavior should be modeled in objects and the best way is to use persistent components (Hibernate/ORM.)