Thank you very much for the explanation, I think using CAST will work. I have some more testing to do but it looks good so far. I really...

Thank you all for your suggestions! I really appreciate it 🙂

Thank you. I appreciate your help! I took a class in SSRS for 2008 a couple of years ago, I just never did anything with it as I...

Thank you for the prompt response. I will do that. Once it is installed, how do I connect to the existing Report Server?

That did make a difference...I guess I never thought about that before. Thanks 🙂

That is a great article. I am going to re-read it before I do anything. I had a consultant for my Manufacturing ERP set up SQL for me...

The report runs much quicker now that I have gotten rid of the unnecessary tables, fields, etc. but I've attached the execution plan for your review. I'm not really...

I'm going to make some adjustments to this report on my end first. Now that I am looking at it, there are some parameters and selections that don't need...

This works great, thank you so much. I can create a view to get the information that I need into my report but is there a more efficient way?...

Sean - This is great! Can I change the order of the data before the rowid's are assigned? I'd like to sort by WORKORDER_BASE_ID, then by WORKORDER_LOT_ID, then...

Very interesting...let me do some testing and let you know (probably tomorrow). I think this might work!

Thank you all for your help. Below is the final query that generated my view with the data I wanted to retrieve:

SELECT T1.ROWID, T1.WORKORDER_TYPE, T1.WORKORDER_BASE_ID,...

I will work with this a bit and see what I can come up with. I have to leave for an off site meeting. Thank you for your...

Below is the entire query. The statement provided by Lowell provides the desired results, thank you. How can I best utilize this data to create a view or...

Yes, I read the article. When you reply with a response like 'Post It?' it was a bit unclear what you wanted me to post, the query or the...