This is my query;
SELECT TOP 100 PERCENT dbo.vw_empresa_info.Cliente, dbo.vw_empresa_info.Comercial, ISNULL(dbo.vw_info_citas4wk.ONDATEA, '01/01/01')
FROM dbo.vw_info_citas4wk RIGHT OUTER JOIN
dbo.vw_empresa_info ON dbo.vw_info_citas4wk.Cliente = dbo.vw_empresa_info.Cliente AND
dbo.vw_info_citas4wk.Comercial = dbo.vw_empresa_info.Comercial
The problem is that I would like "Citas4wkChk" to be N, and if not, Y. How can I do this?
In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!