I tried to use this below command in end of my first query before Union All operator.But it is showing error message.  my first query only taking more time.How can...

Again i am posting with proper alignment.Now i  used OPTION (OPTIMIZE FOR UNKNOWN) in my first part at the end of query.Is it correct?.Whether i have to use in all the queries at the...

ok.Thank You.

cross apply taking more time when the table contains more records.so Is any other way to achieve cross apply concept in my query to improve performance.

Above query is working fine.i am going to use this query in my stored procedure.F_Chem_name and Language is input parameters for this below query.Is it possible to create view for...

This query returns the result of COM.F_Cas_Number, COM.F_Component_Id, COM.F_Chem_Name
FROM dbo.Components table.But i want to display F_PRODUCT from PDF_MSDS in the result.

F_PRODUCT
---------
360

Thank You Very Much.