It is oracle query. need to find where it is taking long time and how we can improve it

@thom-2, the modified query is also taking long time around 900 seconds
@Mitchell, Yes it is using views and have joins in that . When i tried to...

The explain plan is as below:

Thanks for the information provided....

When I copied the dll and also the code snipped from the link, and tried to execute it getting an error "The operation is not supported...

But i am looking in VB6 (not .NET) or SQL Server. When I checked those links, I am not able to find the MSMQ.dll there. It would be great if...

Hi,

Thanks for your reply,

Could you please send sample code while will send messages to MQ either using SQL Server or VB6 only.

If requires any references from where i can add...

I need to get the last 2 columns which are price in a single row. currently it is getting as null and value, value and null as values but i...

I have added iif in both stored procedures as isnull(varname,0)

and also in rdl i used iif isnothing(varname,0,varname) but still no luck

Thanks

Naveen

the input and output should be similar

table a

col1 col2 col3

us 01/01/2012 10

us 02/02/2012 11

us 03/03/2012 33

gpb 01/01/2012 20

gbp 02/02/2012 21

chf 01/01/2012 30

output should be

us o3/03/2012 33 02/02/2012 11

gbp 02/01/2012 21...

Thanks very much its working fine, but where there is only 1 record for a group (in this case for chf), it should not display the same record for both

RAISED THIS IN ACCESS FORUM, BUT IF ANY OF THEM CAN GIVE ME A IDEA OF HOW TO GET IT IN ACCESS, WILL BE GREAT

even if you can suggest me the general query which will work in all databases it would be great

thanks, but can you tell me the same how we can write in MSAccess as it doesnt support partition and with.

Looking in MS-Access

Thanks & Regards

Naveen

check if sql server agent service is running..

There is a tool SQL Data Compare which will do that.