You're using a syntax that's not valid for Vertica. Please read the documentation.
Vertica only supports exports locally.
The client your using needs to have support for a file export. For example, in Excel, you could set up the ODBC connection and import the data.
@JNK Yes but multi-row VALUES is just a UNION ALL of expressions, so type is determined initially by the first row. It's more typing to be explicit, but IMO it is better.
Does UNION ALL guarantee the order of results? I mean, if we take a simple statement of SELECT * FROM a UNION ALL SELECT * FROM b, will rows from a always precede rows from b in SQL Server? This is not about whether rows from a or rows from b will always be sorted the same, it's just about the order of the groups of rows.
I asked someone recently about this, because they said in their answer that the order would be the same. They replied it's in the standard but admitted it was only their observation with regard to SQL Server specifically (as well as the many other database systems they worked with).
@MaxVernon Yes, that's what I would go with. I'm asking because I was questioning someone's claim that the order would be preserved and was told it's in the standard.
I'd go with the fallback answer of "it may appear that way but it's subject to the whims of the database internals and can change at any time unless there's an explicit order by"
Can I be sure that the result set of the following script will always be sorted like this O-R-D-E-R ?
SELECT 'O'
UNION ALL
SELECT 'R'
UNION ALL
SELECT 'D'
UNION ALL
SELECT 'E'
UNION ALL
SELECT 'R'
Can it be proved to sometimes be in a different order?
@AndriyM The standard has: > If a <query expression> does not simply contain an <order by clause>, then the ordering of rows in the table specified by that that <query expression> is implementation-dependent.
Version lie shim for SQL Server 2014
The above question was closed (for incorrect reasons IMHO). I've answered the charges and the question hasn't been revisited. Is there no process whereby those who close questions periodically review those questions when they're edited to clarify any reasons ...
I am looking to download sample ERP data sets to play with in sql server. Can anyone give me suggestions where can i get the sample data for banking domain , finance domain, insurance domain or health domain
We produce N widgets daily, they require these raw materials. Takes N lead time to get those materials in. Sales cycle is X, accounting (AR/AP/GL) does y, etc. Big, ugly, interconnected mess
My first post college job was working on one that used a "c like" language for interacting with the data
They used a database, Ingres, that was targeted for unix but we were one of two companies that insisted running it on NT. Anyways, all the processing was procedural but I learned some SQL on it
And by learning, I wrote what was probably a cartesian product and crashed the database server
I'd get the bigwigs from the shop storming over to our building and you could hear their teeth grinding as they stood over your shoulder waiting for you to perform miracles
SQL server 2008 problem
When I wrote the request does not underline errors
+No completes writing the names of the tables and .. when typing the first letters of which
Knowing that if the demand is true, then the result shows true
Thank you
So... when you go to the emergency room with a broken arm, do you just say "Urgent, nailpolish is wrong color" and then get mad when the doctor tells you they're not cosmeticians? — Marc B7 mins ago
I suspect your package has the package protection level set to EncryptSensitiveWithUserKey. It's a lazy implementation and it will encrypt any connection string data, even if it's using windows auth
@ypercube sure it does. It just doesn't let the user select the actual month they want. What OP needs is a clear stored procedure that does basic TSQL (which means this is an SO Q) but what this answer offers is a RAD approach designed to indicate quickly in a demo how the product should work and as such I consider the informality of this post quite the avant garde expression for how little effort would go into such a query. I can definitely understand the delicate cycle of decision that led to this new poster on our site sharing such a simple selection, and allowing us to infer the obvious — jcolebrand ♦44 secs ago
too much?
That may have been a little too much ...
@neilmcguigan got a second?
@Neil Feel free to take your time when crafting your post. You don't often need to edit 20 times in posting. ;-)
I'm really tempted to gin up an answer that changes the system date to whatever month is selected and then Serg's answer would be correct. Problem is, that'd require me reading php manuals
We would like to comment on behalf of the company.
There are several questions on this website, the possible solution to which can be the use of our tool.
Our answers were always deleted by the site administration, despite of the fact that they contained useful information for the SO users. Th...
Not sure if anyone else got this, but I found the following in my mailbox:
Hi, Peter!
My name is [removed], and I’m Sales & Marketing Manager in
Ispirer Systems. I found your contacts on stackoverflow.com. We are
impressed with your activity on this website. Our company would
appre...
I'm just gonna keep a browser window open to this answer the rest of the day. It's like watching the National Debt Clock tick! — Ogre Psalm3318 mins ago
So not to complain or anything but out of all of the submissions put in for SQL Sat MSP I've found some of the suggestions to be a little disappointing. It's like they had to get all the hits in or something. A good portion of these have been done many times at user groups/last years SQL sat MSP/most of the other SQLSaturdays in the Midwest.
I am trying to find the average games and average plat appearances for the MLB over the 2012 season for outfielders ORDERED BY their birthYear. Currently, this SQL shows entries for each player. The database is the lahman database
http://seanlahman.com/files/database/readme2012.txt
I get the ...
It might be that they wanted to go with known quantities versus risking an unknown entities. To me, that's the beauty of these events. It might be great, might be crap
Part of the purpose of these, as I see it, is to grow your local speaker base but if you don't pick locals, you can't grow them. Crazy
I have altered it to include hardcoded variables when I pulled this chunk of code from the stored procedure. I ran it independent of the application with the same result. I need one insert statement and one update statement to execute if the required conditions are met per record share processed....