I've never heard of OTLT, but I have heard of EAV (and used it!). Basically, the setup is as follows: there is a static metadata repository that holds the table...

To me, dynamic code (SQL or otherwise) is the greatest thing since sliced bread. My applications don't have large amounts of data, but they have tremendous amounts of metadata, metadata...

Whether something is good or bad depends on the circumstances. It's slightly more administrative work, but if you would otherwise have to write 25,000 different extraction routines (literally), you deal...

Hi Phill,

I've done similar things in different circumstances. It's probably how I would implement it were I to use the current version of SQL Server.

I've never had any doubt that...

Hi David,

Thanks, but this isn't going onto the web, it's not going into a browser at all.

Also, don't you mean XSL to format it? Isn't the DTD where the data...

Hi,

Not knocking RPG at all. It did what it was designed to do, which was a very necessary task, and it did it well. People trusted (and still do, I...

Wow Scott!

RPG, a blast from the past...hardcore! Blinking green letters on a black background. You know, the pharma industry really has never moved past that, still Unix/Oracle/SAS. Their one step...

Hi,

Thanks Rudy. Your post definitely makes up my mind, unless someone makes me an offer I can't refuse . I'll start with Oracle, then,...

Hi,

I really want formatted results, but just in text format. I know what you're saying about Crystal or Reporting Services (or Oracle Reports, for that matter), but they're just too...

Hi,

Thanks Peter. The scripts will not be pre-programmed by the app, but will be created by a programmer and then called by the app. If I understand you correctly, SQL+...

Hi Tony,

Thanks. Execution speed really isn't an issue with my app, so that's not a problem with SQL+. But how would you duplicate the functionality with stored procedures? Is there...

Hi,

I expect that most of the functionality that I will require would be covered by BCP; since I need text based reports, perhaps, with some real effort, DTS could be...

Hi,

This is the kind of thing that SQL+ can do with the results of a single query:

...

Thanks. Does DTS do things like column aliasing, summaries, counts, etc., or is it just a way to dump query output? And the reporting services, how do they transfer data?

The...

Hi,

SQL+ is basically a general purpose command line front end to the Oracle database. It also has extended functionalities that let you create text based reports. By setting some parameters...