chill8 (10/9/2009)

---

I work at Ford Motor in Dearborn as a SQL DBA Team Leader. Basically we are on our own here as it pertains to our career development. ...

Education is very important and I too, am fortunate to work for a company who supports it. We get $10,000 per year for tuition reimbursement on top of any...

I am not a DBA, per se, even though I am the "main" administrator of our local plant's SQL Server system (I do have DBA help from Corporate IT if...

Actually, I got it. The query in my post is a sub-select statement. I put the coalesce in the main select and it works.

Here is the SQL query:

declare @thisDate as datetime

declare @endDate as datetime

set @thisDate = dateadd(d, -8, getdate())

set @endDate = dateadd(d, 28, @thisdate)

SELECT DISTINCT pps.Date, shift.actual_shift, pps.Cases_Scheduled * product.quartile as Scheduled, cc.Case_Code,...

This is good information. Thanks

Yes, this does help and I suspected this to be the case. I am not very strong in writing the SQL queries and I really appreciate the help. ...

Same server - pretty much the same connection, just a different database.

Interestingly enough, I am facing this exact thing right now. Where I work, we have a critical software web application for the plant I work at. Originally this...

Steve,

Thanks for the reply. Myself being a published author of fictional works, I agree and maybe that is why I have the mindset that I have. I just...

I am faced with a similar dilemma. I work for a very large food company. Currently I work in IT in a plant. Because of recent "Lean"...

LOL! Like we are doing here at our company still. We have many legacy VB6 apps that are in production.

I am rich - I have a loving and happy family, good friends and I am happy with my life. That is what makes me rich. I have...

Thanks for the reponse! I decided to do the same thing 🙂 Just keep it in the report itself.

Thanks for the information. This will greatly help me.