and should i drop the ## table in sp2 and sp3 both?

oh. I am now thinking off making changes in sp1 adding ## table in there and then using that in sp2 and sp3.

how do i reference those in sp2...

thanks for replying. I did not understand what you mean.

Thank you !! Well written and thought out.

thanks for the reply. will do so. How to check execution plan (navigation please) and how to interpret that? any good links here?

thanks again

Thank you so much Anthony !!. I am going to try that. appreciate your time and help.

thank you. I am very new to this so please excuse if any of the questions looks basic.

the query has no parameters.

something like this

create table #product

(

prod_id int

,prod_detail...

Thank you for your advice !! That helped a lot !!

Thank you a bunch !! 🙂 🙂

I see exams 70-448, 70-452, 70-467 , 70-460.

I work on 2008 what would be better ?

these are the videos you talked about ?

http://www.microsoft.com/feeds/TechNet/en-us/How-to-videos/SQL_Server_2008_Microsoft_Certified_Master_(MCM)_Readiness_Videos.xml

Thank you for your help !!

Thank you for your help. Saved a lot of time. very much appreciated.

Thank you Matt, Rick, Derek, Lynn. Greatly appreciate your time and help on this.

I tried that (removing ending dates to be null) and but it is not working.Did you mean something else?

Thank you for your responses. just corrected that.

sometimes the manufacturing goes beyond the dates specified, therefore the code includes all those scenarios when the manufacturing went outside the time-limits specified.

In...

You will have to add column group and group by 'casetype' field in your dataset