SQL Queries

[#1]

Hi All

I have attched SQL query.

Please let me know can I decode this query to map all the logic of query in qlikview.I am not supposed to do directly run the query.

Can anyone tell me what can I do for this query?

I don't have any requirement document. I need to decode the query to pull out requirement.

How can proceed with this query. I'm confused.

Please help me regatding this.

Regards,

Kushal

[deepakk]

hi Kushal,

Running this query will have performance issue. Do the following activites.

1) Analyze the number of tables. Pull each one into a single qvd;

2) Understand teh joins between this tables and try to join them using the qvd.

3) Use the where clause on necessary tables.

4) take out only the necessry fields as required in the script.

Deepak

[#3]

Hi Deepak,

Thanx for the reply.

But it's very difficult to find the joins between table as the query is complex.

[#4]

Hi Deepak,

Thanx for the reply.

But it's very difficult to find the joins between table as the query is complex.

Regards,

Kushal

[#5]

Hi Deepak,

Thanx for the reply.

But it's very difficult to find the joins between table as the query is complex.

Regards,

Kushal

[#6]

Hi Deepak,

Thanx for the reply.

But it's very difficult to find the joins between table as the query is complex.

Regards,

Kushal

[deepakk]

hi Kushal,

I understand that. Once you break down the code , you will get it.. It will take time.

Best of Luck

Deepak