my join is actually returning data, but its returning thousands of rows, unlike the except query. they should be the same.

i wrote a query but it took ages, so i came up with this instead:

select RowID, partnumber, countrycode

from tableA

where RowID = 200

except

select RowID, partnumber, countrycode

from tableB

where...

the contents arnt identical, but for the purposes of the issue here, they can be thought of as identical. T1 is an orders table. orders are created here. they are...

I would also like some info on this exam. I have done th e70-431, and want to take the next step. this exam, seems quite difficult, from reading the book...

perhaps the above query might work if you improve the indexing suituation on your tables. check out the execution plan for the query and see what that throws up.

I have this exact book and I would not have passed the exam without it. It does not cover absolutely everything for the exam, but if it did, it would...

simplicity! ! exactly what i needed. thank you very much.

This is not a problem with the book, its the format of the questions. They seem to be designed to trick you. This is why before you do the exam...

I passed this exam a few weeks ago. Here are the steps I think are necessary to pass. Note im not giving away any specifics here, just general guidelines.

1. Buy SQL...

would someone mind helping me understand whats going on in this script? For instance:

    FOR EACH oLogin IN oServer.Logins

        ''SQLDMOScript_AppendToFile=256

        ''SQLDMOScript_ToFileOnly=64

        ''SQLDMOScript_PrimaryObject=4

 ''SQLDMOScript2_LoginSID=1048576

 ''SQLDMOScript2_EncryptPWD=128

 ''SQLDMOScript2_UnicodeFile=4

        oLogin.Script 256 + 64 + 4, "<path for...

Just want to throw in my two cents. Im in the industry for just under two years now, and I found it most difficult to get my first job. I...

think i need a new job to help me develop my sql developer skills. they are not really used in my current position, thanks guys for the advice and info

the Exam insurance is no longer availiable as of the end of June. Im told there will be similar programs availiable by september, but at present , you only have...

Exam insurance promotion ends this month, so if you dont sit your exam within the next 5 days your voucher will be useless. so that seems to be the end...

i found this question and answer on the exam insurance faq page: