This will return Null if the dived is by zero

SUM(TotalMaterialValue) / NULLIF(SUM(TotalQuantityMade), 0) AS AverageMaterialCost,

...

Log into the server as an Administrator and open the SQL Sever Management Studio using Windows Authentication and see if you still get the same issue.

I don't think the substring function is recognized by SSRS 2005. I get Unrecognized identifier error message.

Please disregard... i found the answer. I needed to change the character length to Max.

Please disregard... i found the answer. I needed to change the character length to Max.

Check out the links below... it might help you.

http://www.sqlservercentral.com/Forums/Topic328124-148-1.aspx

http://www.sqlservercentral.com/Forums/Topic459767-148-1.aspx

http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/e26692b8-8044-4813-b643-0c181a1ea4fe/

I have done a remote connection to SSIS before and you're right it is slow, but never had the issue you described. Even thought you can open it, you...

SQL Server Integration Services Package is usually the second one from the bottom on the drop down list for Type. If you are not able to see it, then...

Okay Thank you guys

This works perfectly fine... Thank you so much for your help!

No, I don't want to make changes to the table... maybe create a temp table to display the data.

The issue that I'm running into is that if the clients data...

Hey Nevyn thank you so much for your help... this works as I expected it.

Yes, I was thinking about using SSRS... how would you do this in SSRS easier?

Below is the table definition. I wish I had a script to share, but I didn't know where to begin. I even did a search online for similar...

Nevyn thank you that worked.

Okay I'll work on that bteraberry, thanks

I have a different question along the same line... not sure if I should create the separate post or...

Yes, sorry I posted the wrong data and average measurement... that is what happened when you're in a hurry;-). I have edited the original post. Thanks for that.