Thanks you for all your help!
FMI:
Is it possible for it to return not distinct pairs also?
Thanks again!
Igor Tandetnik wrote:
>
> Cnichols wrote:
>> Ok I also tried to think about it from a different approached and
>> didnt get the result I wanted ...
>>
>
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
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" wrote
> in mess
onids also for the same session if ask unique was enable)
Igor Tandetnik wrote:
>
> "Cnichols" 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 session (ie 7)
>
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
.
et
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
odifier = 1
GROUP BY DA.MemberId
Igor Tandetnik 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 relatio
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 w
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 balance
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 balance
rAccounts (MemberId, Balance)
> SELECT..." will do what 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 Onl
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 DiscountsAppli
14 matches
Mail list logo