By id i am testing the latest record and testing the condition . It is actually a two procedure that needs to be combine to get the single query output...

I just commented and ran it fetches around 1074733 in 9 mins .When i run the inner query it fetches one row

when i run the inner join seperately

INNER...

To add with it is taking the inner query output (policy id) and returing the one row only . I really dont understand why the other policyid is coming into...

Thanks for your info . When i just run the query i am still getting one record alone . Why i am not getting all the policy records in the...

Thanks for your infor . I will post the execution plan when i get the permission .Along with it i will update the table details .

This query works fine for...

For the proc logic i have created a query based on the earlier input but the query run for 2.48 mins .

1.How can i optimize this query .

2.Is there any...

Hi ,

Thanks for your response . It should be single query and not procedure .When i ran the query for one record i am getting below error

Msg...

Thanks for your response .As said it is fully supported and i am getting the result fine . The problem is i need to incorprate the query in bo universe...

Thanks for your response . i tried the way what you said but i dont find any records gettig populated .While earlier things are fine and record counts are perfect...

Since ansi 92 of bo standards does not support outer apply i tried putting an left outer commented in one of the posts and i tried the following way

SELECT...

thanks a lot . Instead of outer apply if i try for Left outer or right outer i am getting an error in where .The reason i am saying this...

Thanks for your reply . When i ran the query and checked

1. Due to inner join that is made ,It check for only c1 . For sitenumber c1 the...

Thanks . I would appreciate if you could help me in using case statements .Looking for your reply how to include case statements .Also i have not come across this...