I was sure that "we can Aggregate by columns not included in the SELECT", but I wasn't aware of that use of DISTINCT in Aggregate function, so I had to...

Very good question containing lot of information.

But I always suggest to break such single question in multiple questions having just (Yes/No) options rather then having so many options in...

Thanks Wayne

I was aware of this issue since long time, but didn't had any solution.

Thanks for sharing wonderful information with us.

Regards,

Hi,

It is always hard to get the right answer for this kind of question. There is more probability that you will miss at least one point.

So I think rather then...

Good Question.

Learned something new.

Never worked with secondary files, but then also was able to guess correct.

Regards,

Sorry for being late !!!

For SQLCE, you can use either Exists or In operator:

select *

from t1 where maintdte not in (select MAX(maintdte) from t1)

Regards,

Mayank Parmar

Hi,

I never created any encrypted stored procedure. So I just guessed, any my guessing was correct.

Regards,

Mayank Parmar

Good Question to ask !!!

Hi Christian

You are right, I should mention that : "Service had already been enabled in db1"

Regards,

Yes Phil,

Normally to enable the Broker Service, you need to simply use : "ENABLE_BROKER"

But when you restore the back up of database db1 to database db2, and after that if...

You need to set registry value on [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Text] Set ImportMixedTypes as Text.

I have implemented it in my website www.relationshiplist.biz and it worked for me.