Thanks you for all your help!
FMI:
Is it possible for it to return not distinct pairs also?
Thanks again!
Igor Tandetnik wrote:
>
> Cnichols <cnichol...@gmail.com> wrote:
>> Ok I also tried to think about it from a different approached and
>> didnt get the result I
that have not
been asked (questions that have not been recorded in stats with a session of
7)?
Cnichols wrote:
>
> Ok I also tried to think about it from a different approached and didnt
> get the result I wanted ...
>
> SELECT COUNT() FROM Temp
> WHERE Id IN (SELECT QuestionI
that happening there is that We are looping through each
row in Temp and seeing if that Id is present in Stats table with a session
of 7
since Stats has 46 results with 7 and ALL those QuestionIds assoc with 7 are
in the temp (id) table I don not understand why I would also get only 29
Cnichols wrote
I expected it to return 46 results, not fewer as you mentioned, except it
returns 51 which I am trying to figure out why ... there is only one
duplicate in Temp, but why would that still produce more results then 46?
Igor Tandetnik wrote:
>
> "Cnichols" <cnichol...@gmail.com&
for the same session if ask unique was enable)
Igor Tandetnik wrote:
>
> "Cnichols" <cnichol...@gmail.com> wrote
> in message news:21676221.p...@talk.nabble.com
>> What i am trying to do right now is select the questions that have
>> been asked for the current
I have stumped myself with this sql goal.
With this statement I am working with 3 tables
Stats - contains question asked history and if it was answered correcty
sessionid
questionid
correct
Questions - contains a list questions and mul choice answers and answer
id - pk
.
I was not aware of composite keys so I quickly learned what they where and I
have decided to contemplate my database design. I searched for performance
issues with using composite keys and I was not able to find much information
related to SQLite.
Igor Tandetnik wrote:
>
> Cnichols &
First off I want to thanks everybody that help me learn the greatness of
REPLACE INTO I have crafted some very complex statements that ended saving
mass amounts of time programming and much more efficient.
Onto the new problem.
I am attempting to INSERT OR REPLACE rows into an AccountState like
wrote:
>
> Cnichols <[EMAIL PROTECTED]> wrote:
>> Thanks alot the UPDATE works great! Although the REPLACE INTO still
>> only executes the last row of a multi discount.
>
> I see. MA to DA is a one-to-many relation, too. You need to move all the
> tables into
I disagree I myself see this as a feature. I think the programmer should be
responsible for file checking because if it is not a SQLite database SQLite
will inform you.
Dave Dyer wrote:
>
>
> It would have saved me 2 days of chasing bogons if sqlite_open
> had an alternative form which only
it be more logical to try to achieve this by
using ifnull and nullif on the D.Modifier to get the correct sum function()?
Igor Tandetnik wrote:
>
> Cnichols <[EMAIL PROTECTED]> wrote:
>> I have a complex SQL statement which attempts to update all Member
>> Accounts
Thanks alot the UPDATE works great! Although the REPLACE INTO still only
executes the last row of a multi discount.
Igor Tandetnik wrote:
>
> Cnichols <[EMAIL PROTECTED]> wrote:
>> I have a complex SQL statement which attempts to update all Member
>> Accounts
hat you want?
>
> -Clark
>
> - Original Message
> From: Cnichols <[EMAIL PROTECTED]>
> To: sqlite-users@sqlite.org
> Sent: Thursday, November 30, 2006 2:22:19 PM
> Subject: [sqlite] REPLACE INTO Only Executes last SELECT?
>
>
> I have a c
I have a complex SQL statement which attempts to update all Member Accounts
balance with a discount if there anniversary falls between last handled date
and the current day.
REPLACE INTO MemberAccounts (MemberId, Balance)
SELECT DA.MemberId, (MA.Balance - D.Amount) AS Amount
FROM
14 matches
Mail list logo