Thank you yu.he. If what Sean posted earlier doesn't work, then I will give this a whirl as it should work as well. Thanks again.

Thank you for the help. Is this an example of a good post? http://www.sqlservercentral.com/Forums/Topic1414095-392-1.aspx or are you just picking on me?

I don't understand the need for the table creation. I...

Just a few minor tweaks in the WITH CTE code and you hit the nail right on the head. I thank you very much for your effort and time as...

So, to clarify this a bit for me, in the example table built by Luis above which I'm going to use for all references, CHARGE_BATCH_ID could be NULL? Also, STATUS...

Sorry for the last minute addtion. Thank you for looking at this again. Here is the same data in Excel. Rows 7 & 8 I would expect to see returned...

I admit, I was frustrated yesterday and I took it out on the forum. It just appears that with little effort on a post, I get the "best practices" post...

You know what, never mind. I'll go somewhere else for my answer. Thanks

I understand.

So what I learned here is, page file only the OS drive.

So I might recommend:

C - Currently 4GB - Change to "X"

D - Currently none - leave

E...

I inherited the server and responsibility this week. I didn't spend much time on the log drive yet (but I'll start looking into it). I'm curious about the OS drive...

Thank you very much. The results seem to be what I', looking for. The only thing, the group by used the wrong GUID. Switched it to charge_lines_guid and it work....

Thank you Matt,

I really appreciate your patience and help. I have put together a spreadsheet with some sample data and highlighted examples of what I want to get......

That's not it.

Analysis Services are running on a hosted box. Customers access their data through a website executing the cube data. The only way they can access their cube...

Never mind. My inability to spell has struck me yet again. I was able to add the DATEADD(...) to to query and it worked... Once I spelled SUBMITDATE right... Thank...

Sorry, you answered the question exactly how I asked it. Shame on me for not being more thorough. SUBMITDATE has hundreds of records that are integer. SUBMITDATE is just one...

I figured it out. I found a great tutorial on MSDN that solved all of my problems. http://msdn.microsoft.com/en-us/library/aa337491(v=sql.105).aspx