use it works thank you

can i delete one of the backups from the file ?

thnx

so the resone for still seeing the other database that my current user however its in the windows group for this login and it also have a login for this...

i have make alogin on sql server but now i downt know how to use it to secure the other databases when i contct to sql via the userAcount ...

select SUM (e.t) ,curr

from (select BuyCurr as curr, BuyAmt as t from #myTrade UNION all select sellCurr as curr, sellAmt as t from #myTrade ) as e

GROUP BY Curr

...

i face the same problem can anybody help us on that

thanx for help but i coundnt make use of this link as the information so distrbuted could you please sugest me any other may to get start ?

first thanx alot for your great help

can i ask about how is the shap of the xml variable parsing tree and how can i move through it and...

first thanx for help

who can i make it run dynmicly (if i dont know the number of child how to make it retrive all of them)

what dos the [1] mean on the select statment

i think in this case the right inner join but if you need the cartasian product of the 2 table you have to use the select from 2 table select...

thns the topic was very usefull

i dont really understand what you mean

that true wasnt he want to get 85 ?