hi

i am attaching my query part in doc.plz see it and reply me asap

hi

the thing is i cannot show my data ,its confidential ,i can show my execution plan,but when i save it comes with query,is there any way i can show only...

hi

i cant put my all execution plan,all oher field is 0%,except table spool and key lookup.

i dont understand how to increase my time

hi

i am seeing table spool 50% and keylookup 69%

so i think this both can be problem

hi

i know how to use cdc,but i am asking ways to handle updates on table

if you installed oracle client on sql server ,then what is the use of if.u need to create linked server to oracle client and then oracle client make connection...

i know this link,just tell me what this 2 condition do

archive 1 is for each loop after the first condition and archive 2 is for loop after the second condition

hi

ON DELETE CASCADE is applied while table creating ,here table is already created

i cant change them

thank u so much,its really helpful

hi guys,

Can we discuss what are the way,we can check that the consolidated tables were generated correctly?

And i want to clarify ths is nt my hw,i dont know about...

Thanks a lot SQLkiwi.

You solve my prob.

@jeff,

well dear,if u dont wanna to help me,just stay out of this matter,i dont mind.

i am not begging u ,to help me

thank u

One way to show its registered or not

SELECT SUM(num_trans) as 'No of Transactions', SUM(spend) as 'Total Spend','registered'

FROM (

select num_trans,spend from...

this is not a my hw,and this forum is about to help each other,i m learning so many things.

and i am learning through this blog

group by o f what?registered