How can we help you today? How can we help you today?

Can I have Cross/Outer Apply or Cross Join match the same format style as other join conditions?

This is what I want ..

From BaseRate t3 Cross Join 
         MasterBenefitsRates t4 Left Join
         EmployeesBenefitsRates t5 On t4.CompanyID = t5.CompanyID
                                               And t4.BenefitID = t5.BenefitID

This is what I get ..

  From BaseRate t3 Cross Join MasterBenefitsRates t4 Left Join
           EmployeesBenefitsRates t5 On t4.CompanyID = t5.CompanyID
                                               And t4.BenefitID = t5.BenefitID


Really bad with multiple cross applies - Keeps appending to the end of the previous join. Any way to treat the "Apply and cross join" just like the other join conditions?

petes
0

Comments

2 comments

Sort by
  • petes
    The cross apply had to do with parentheses alignment. I fixed that to my liking - but cross join - not so much.
    petes
    0
  • Pete_Ruiz

    It seems that this is a known issue that is currently being reviewed. You can reference this by SP-6989. I've went ahead and linked a support ticket to this bug and will update you on it as it progresses. Sorry for any inconvenience this might have caused. Please let me know if there are any questions.


    Kind regards,


    Pete Ruiz
    Redgate Support

    Pete_Ruiz
    0

Add comment

Please sign in to leave a comment.