Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM SQL » View Thread |
Messages 11 to 12 of 12 total |
Getting various forecast counts into a table. |
Sun, Sep 2 2007 6:31 PM | Permanent Link |
"Adam H." | Good Morning Tim,
Hope your weekend was as enjoyable as mine! > << Thanks Tim. (Although don't ask me how to do the same thing in EDB at > the moment ) <vbg> >> > > Just use CREATE TEMPORARY TABLE..AS instead of SELECT..INTO. Then just > refer to the temporary table in the subsequent queries, and be sure to > DROP the temporary table when you're done. Doesn't sound too hard. Guess just a little bit of a learning curve for me to work with. Out of curiosity, why the change to this anyway? Does this meet more of an industry standard, or does it have to do with additional features? Cheers Adam |
Tue, Sep 4 2007 9:38 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Adam,
<< Hope your weekend was as enjoyable as mine! >> Uh, not really. I got to paint the kids' rooms since they hadn't been done in a while and they needed an update to reflect the fact that they're not in elementary school anymore. They don't call it Labor Day weekend for nothing here in the States. << Out of curiosity, why the change to this anyway? Does this meet more of an industry standard, or does it have to do with additional features? >> CREATE TABLE..AS is industry standard, plus 1.06 will implement the standard INTO behavior, which is to put the contents of a single-column, single-row SELECT query into an output parameter that can be retrieved by the calling session. -- Tim Young Elevate Software www.elevatesoft.com |
« Previous Page | Page 2 of 2 | |
Jump to Page: 1 2 |
This web page was last updated on Sunday, May 19, 2024 at 08:46 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |