You can do something similar

IWETHEY v. 0.3.0 | TODO

1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User

Welcome to IWETHEY!

Post #38,935

by Steven A S

5/16/02 5:03:18 PM

5/16/02 5:06:06 PM

You can do something similar

If you really don't want to attack the SQL all in one go, you can do something like this:


CREATE VIEW T1 AS SELECT * FROM FOOTABLE WHERE X > Y;
CREATE VIEW T2 
     AS SELECT EMPNO,CHARGE AS AMT,WHEN AS TIME 
     FROM T1 A, BARTABLE B
     WHERE A.SERIAL = B.SSN;
SELECT EMPNO,SUM(AMT) FROM T2 GROUP BY EMPNO;

This would be the same thing as the procedure you explained (based on my understanding of it's meaning at least)

~~~)-Steven----

"I want you to remember that no bastard ever won a war by dying for his country.
He won it by making the other poor dumb bastard die for his country..."

General George S. Patton

Edited by Steven A S May 16, 2002, 05:05:24 PM EDT

Edited by Steven A S May 16, 2002, 05:06:06 PM EDT

Expand All History

Post #38,955

by tablizer

5/16/02 8:30:53 PM

Views are too formal

Often, one has to go thru the DBA to have views. Temporary views may be a partial solution, but the standard is fuzzy on this. It may also be less "atomic" than my suggestion.

________________
oop.ismad.com

SQL's Replacement Rant - (tablizer) - (6) - May 16, 2002, 02:23:56 PM EDT

Maybe you would prefer... - (ChrisR) - (1) - May 16, 2002, 03:42:24 PM EDT

It *is* declarative - (tablizer) - May 16, 2002, 08:26:58 PM EDT

You can do something similar - (Steven A S) - (1) - May 16, 2002, 05:06:06 PM EDT

Views are too formal - (tablizer) - May 16, 2002, 08:30:53 PM EDT

SQL "non-sequential"? Look up the concept 'SQL Cursor'. HTH! -NT - (CRConrad) - (1) - May 17, 2002, 08:13:51 AM EDT

Cursors are proprietary add-ons -NT - (tablizer) - May 17, 2002, 03:58:16 PM EDT

iwethey.org

I have fun with that on St Patrick’s day until they start to chase me.
43 ms