Why should I ask single quotes? Do you understand that I have a problem to run two selects at once rather than run a single individual select? What makes you think that I have the quotes issue?
Which question? `Because "1" does not look like a usual column name.` is a statement, `Because you showed no FROM.` is a statement, ` So your question shows a limited knowledge on SQL and we want to help` is a statement. Statement = not question. You have no questions to start with. You just
@Val It sounds like you want to return a single result set with two different shapes i.e. one column then two columns. Generally this isn't possible, you have to issue two queries then process each result separately. How you did this precisely depends on the engine and driver. I have no idea what special features "SQL Lite" might offer here. I have never used it.
@Val I very much doubt @ypercube was calling you stupid. He was simply trying to answer your question. You asked why it wasn't working, and he attempted to answer that by saying you are missing a FROM ... clause in your SQL Statement.
@Val Judging from a quick look at the support site it seems multiple statements just have to be separated by a semicolon.
> Once you have entered your sql statement(s) into the Enter SQL text box, you can click on the Run SQL button or press ctrl + F12 or ctrl ; (control semicolon) When multiple sql statements are to be run, each sql statement must be terminated by a semicolon.
@Val Don't know then :) Seems unlikely such a basic thing would be caused by a bug, but as I say, I have no idea what I'm talking about when it comes to sqlite or specific tools like sqlite-manager. Sorry.
I don't even know if any of the regulars in this chat room know sqlite.
On a positive note, I have learned how to spell it today.
We are the Borg. Lower your shields and surrender your ships. We will add your biological and technological distinctiveness to our own. Your culture will adapt to service us. Resistance is futile.
Why should I ask single quotes? Do you understand that I have a problem to run two selects at once rather than run a single individual select? What makes you think that I have the quotes issue?
I cannot find specific tag ' SQL Server installation' however there is a tag 'Installation'. If we could create this tag it would be good for users to use this tag to specifically tell this is installation related to SQL Server. It would ease the search as well.
Thanks and Reagrds
Shanky
@JackDouglas seems like I have to swallow my words, but anyway, he did end up using single quotes and refused to answer a simple question in a way that I find offensive
Why should I ask single quotes? Do you understand that I have a problem to run two selects at once rather than run a single individual select? What makes you think that I have the quotes issue?
> For resilience when confronted with historical SQL statements, SQLite will sometimes **bend the quoting rules** above:
If a keyword in single quotes (ex: 'key' or 'glob') is used in a context where an identifier is allowed but where a string literal is not allowed, then the token is understood to be an identifier instead of a string literal.
If a keyword in double quotes (ex: "key" or "glob") is used in a context where it cannot be resolved to an identifier but where a string literal is allowed, then the token is understood to be a string literal instead of an identifier.
@Lamak It's relatively easy to read more into something written in someone's second/third/nth language than was actually there. Can't say if that was the case here, but it's true nonetheless.
@Lamak Perhaps/probably/don't know. Yes I saw them first time. I'm just not sure it ever helps calling someone out on it. Rudeness is a localized problem that we probably can't help with. And it's off topic :)
OTOH it's also good to vent and not bottle things up so I'm probably talking rubbish.
@PaulWhite I'm sensitive, ok? (joking). In any case, I can move on when people is being rude to me, but I get really mad when people is being rude to another person who is trying to help
People vote differently on meta, I'm just pointing that out. On main, downvotes mean "you shouldn't have asked that question here", on meta they just mean "I don't agree". I'm not saying that's good or bad, it is however a fact and knowing it can prevent misunderstandings. — Jack Douglas ♦1 min ago
I hate them. My house has them so bad it's ridiculous. The worst is when they scurry by before you can kill them and then you know. It's out there. Somewhere.
Given the string:
'I think that PostgreSQL is nifty'
I would like to operate on the individual words found within that string. Essentially, I have a separate from which I can get word details and would like to join an unnested array of that string on this dictionary.
So far I have:
selec...
Here’s a question again in the Jeffery Archer’s “The Prodigal Daughter.”
The heroin of the novel, Florentina Kane’s husband, Richard finds in the Wall Street in a morning that Jake Thomas, Chairman of Lester Bank took a counter measure to block Richard’s cornering the stocks of the bank with an a...
It uses a code generation architecture (a bit like Wherescape Red) and manages to combine the worst aspects of strong typing with no type safety at all - i.e. you have to manually ensure your metadata all lines up correctly.
And its diagnostics are only marginally less obtuse and unhelpful than SSIS.
And did I mention the mapping editor is written in Java and still manages to be unusably slow - even on modern PCs?
Thanks, bluefeet, for the reference -- but my previous implementations all looked something like that and it just wasn't acceptable. — user30427831 hour ago
So, you don't need to express your opinion if you cannot do it in a polite manner. Also, it is usually better to wait until the OP clarifies their intent. — dezso3 mins ago
SELECT CASE WHEN a.IsActive = 1 THEN b.Amount WHEN a.IsActive=0 AND a.CancelDate BETWEEN b.EffectiveDate and DATEADD(d, 1, b.CanelDate) THEN b.Amount ELSE 0 END As Amount FROM A LEFT OUTER JOIN B on A.guid = B.guid
Ignoring the between and the function applied to it... if I were trying to optimize an index for table A in this join, can it be done?
I cannot find specific tag ' SQL Server installation' however there is a tag 'Installation'. If we could create this tag it would be good for users to use this tag to specifically tell this is installation related to SQL Server. It would ease the search as well.
Thanks and Reagrds
Shanky
Given the string:
'I think that PostgreSQL is nifty'
I would like to operate on the individual words found within that string. Essentially, I have a separate from which I can get word details and would like to join an unnested array of that string on this dictionary.
So far I have:
selec...
