This should work for 2008.

WITH cteRows AS(

SELECT fmc_terminal,

fmc_date,

fmc_prodlnk,...

mahi123 (12/12/2014)

---

Thanks for your reply,

i have been created procedure but i want data in select statements, because in front end code we have to pass optinal perameters something, s that...

Have you ever feel that posters are just trolling you by saying that a solution doesn't work even when you have tested it correctly? I feel that Lynn is a...

Have you tried using SSRS?

John Mitchell-245523 (12/11/2014)

---

You need to copy and paste the plan into a text file and save it with a .sqlplan extension. You can then open it in graphical form...

Are you aware of this possible combination of values?

WITH SomeTable AS(

SELECT CAST( '20141209' AS DATE) AS date,

...

This isn't pretty, but it might be what you need to handle one to many relationships between managers and employees.

SELECT CEO.Emplid AS CEO,

SrVP.Emplid AS SrVP,

...

Could you post both execution plans to have a better idea on what you're talking about?

Should I insist on this method? I just added a NULLIF function and it works.

SELECT CAST( CAST( 19000000 + NULLIF(oldDate, 0) AS CHAR(8)) AS date)

FROM( VALUES('0980412'),('1100323'), ('0'))x(oldDate)

It hurts to love someone and not to be loved in return, but it hurts even more to have an UPDATE without a WHERE.

Try this example:

CREATE TABLE CustomerCredit(

...

You just need to change the order in your conditions.

SELECT CASE

WHEN C.Insuranceid = 'MCD' THEN 'Medicaid'

WHEN...

Trying to go back to the original problem, I think the SP that is supposed to fill your temp table has some sort of problem. Either the data is not...

Your main problem is the stored procedure. Unless you change the code from the procedure, you'll end up with RBAR anyway.

Unless you force the order (which you shouldn't in most cases), it really doesn't matter which table you use first in your query. SQL Server will decide the best option...

Take a look at Gail Shaw's article on catch-all queries.

http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

If you have any questions, come back and we'll help you.