"Yener" <someone@com.com> wrote in message
news:ORi4O$6wFHA.2620@TK2MSFTNGP09.phx.gbl...
>i am using RDA to synch data between sql server 2000 and my PDA. i try to
>get a parameter list according to the group of a user in my program. my
>query to pull is something like that :
>
> "select id ,name from parametertable where groupid in ( select g.id from
> grouptable g inner join usertable u on u.groupid = g.id where u.is =
> <<userid>>)" with TRACKINGOFF option
>
> this query works well in sql server 2000 and brings what i want. but it
> gets all the items of parameter table in the PDA. i do not understand
> why.
> i am new to RDA , is there anything that i miss ?
>
> thanks
>
>
>
>

"Darren Shaffer" <darrenshaffer@discussions.microsoft.com> wrote in message
news:O0%238iFgxFHA.1252@TK2MSFTNGP09.phx.gbl...
> try rewriting the query to not use subquery for the RDA pull.
> use a join if possible.
> --
> Darren Shaffer
> .NET Compact Framework MVP
> Principal Architect
> Connected Innovation
> www.connectedinnovation.com
>
> "Yener" <someone@com.com> wrote in message
> news:ORi4O$6wFHA.2620@TK2MSFTNGP09.phx.gbl...
>>i am using RDA to synch data between sql server 2000 and my PDA. i try to
>>get a parameter list according to the group of a user in my program. my
>>query to pull is something like that :
>>
>> "select id ,name from parametertable where groupid in ( select g.id from
>> grouptable g inner join usertable u on u.groupid = g.id where u.is =
>> <<userid>>)" with TRACKINGOFF option
>>
>> this query works well in sql server 2000 and brings what i want. but it
>> gets all the items of parameter table in the PDA. i do not understand
>> why.
>> i am new to RDA , is there anything that i miss ?
>>
>> thanks
>>
>>
>>
>>
>
>

"Yener" <someone@com.com> wrote in message
news:%232QRy5CzFHA.2540@TK2MSFTNGP09.phx.gbl...
>
> i found another code at the bottom that pulls the same table again!
> i am sorry!!
> "Darren Shaffer" <darrenshaffer@discussions.microsoft.com> wrote in
> message news:O0%238iFgxFHA.1252@TK2MSFTNGP09.phx.gbl...
>> try rewriting the query to not use subquery for the RDA pull.
>> use a join if possible.
>> --
>> Darren Shaffer
>> .NET Compact Framework MVP
>> Principal Architect
>> Connected Innovation
>> www.connectedinnovation.com
>>
>> "Yener" <someone@com.com> wrote in message
>> news:ORi4O$6wFHA.2620@TK2MSFTNGP09.phx.gbl...
>>>i am using RDA to synch data between sql server 2000 and my PDA. i try to
>>>get a parameter list according to the group of a user in my program. my
>>>query to pull is something like that :
>>>
>>> "select id ,name from parametertable where groupid in ( select g.id from
>>> grouptable g inner join usertable u on u.groupid = g.id where u.is =
>>> <<userid>>)" with TRACKINGOFF option
>>>
>>> this query works well in sql server 2000 and brings what i want. but it
>>> gets all the items of parameter table in the PDA. i do not understand
>>> why.
>>> i am new to RDA , is there anything that i miss ?
>>>
>>> thanks
>>>
>>>
>>>
>>>
>>
>>
>
>

"Darren Shaffer" <darrenshaffer@discussions.microsoft.com> wrote in message
news:eqyDGkMzFHA.3812@TK2MSFTNGP09.phx.gbl...
> so is your problem solved? not sure if we've helped you here or not.
> --
> Darren Shaffer
> .NET Compact Framework MVP
> Principal Architect
> Connected Innovation
> www.connectedinnovation.com
>
> "Yener" <someone@com.com> wrote in message
> news:%232QRy5CzFHA.2540@TK2MSFTNGP09.phx.gbl...
>>
>> i found another code at the bottom that pulls the same table again!
>> i am sorry!!
>> "Darren Shaffer" <darrenshaffer@discussions.microsoft.com> wrote in
>> message news:O0%238iFgxFHA.1252@TK2MSFTNGP09.phx.gbl...
>>> try rewriting the query to not use subquery for the RDA pull.
>>> use a join if possible.
>>> --
>>> Darren Shaffer
>>> .NET Compact Framework MVP
>>> Principal Architect
>>> Connected Innovation
>>> www.connectedinnovation.com
>>>
>>> "Yener" <someone@com.com> wrote in message
>>> news:ORi4O$6wFHA.2620@TK2MSFTNGP09.phx.gbl...
>>>>i am using RDA to synch data between sql server 2000 and my PDA. i try
>>>>to get a parameter list according to the group of a user in my program.
>>>>my query to pull is something like that :
>>>>
>>>> "select id ,name from parametertable where groupid in ( select g.id
>>>> from
>>>> grouptable g inner join usertable u on u.groupid = g.id where u.is =
>>>> <<userid>>)" with TRACKINGOFF option
>>>>
>>>> this query works well in sql server 2000 and brings what i want. but
>>>> it gets all the items of parameter table in the PDA. i do not
>>>> understand why.
>>>> i am new to RDA , is there anything that i miss ?
>>>>
>>>> thanks
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>