I was able to arrive at a solution. Basically I ended up making about 7 temp tables and using CTEs twice to parse out the unneeded data. Thanks...

Just noticed one of today's headline articles might be relavent to what we're trying to do.

http://www.sqlservercentral.com/articles/T-SQL/70807/

It instructs how to elimate duplicate rows using the PARTITION BY clause. ...

Heh... so it's not possible that someone could enter an area and the battery on their cell phone gives out? It's also not possible that someone driving along enters an...

but to more specifically answer ur last post, no this is not data from a card scanner from a door. So someone holding a door open is not possible....

That's not possible. Every Entry will have an exit. Basically an entry event logs when a 1/3rd of a mile radius of a location is entered and the...

OK, sorry for the continuous questions, but I have another. The data I'm working with is a bit imperfect. Let's just say a certain cellphone manufacturer who is...

Thanks you very much for the hasty response, and I'm happy to provide sample data sets. This community is proving most helpful to me.

Just one more question, while posting...

I have another question now. I was trying to use a CTE to come up with a way to create a field. Basically I want to create the...

Thanks this is much better. And yeah in the end I need those 2 fields to be VARCHAR since I want to add one more value called 'Total'. ...

It works! Thank you very much. This will be a big help for me.

Yeah this looks like what I need. Thanks alot for the help. I'm gonna test soon, but if it works it should save me a lot of time,...

See below. If you want to keep it simple, just remove the WITH CUBE part from the previous code and use [Time to Fund Bin], and [App Source Bin]....

Here's what the code actually looks like. I'm trying to streamline the creation of the temp tables. I have 45 of these in my code.

---------------------------------------------------------------------------

DROP TABLE #HOMEOWNER_WEEK

SELECT

Section =...

I always want to apply WITH CUBE. Sorry for the confusion. WHen I initially posted the code I removed alot of things to make it simple. I...

Thanks for the quick response. Not quite what I'm looking for though. My problem is that I'm trying to stack about 20 temp tables together and what I...