How many GBs for the heap the db?

We don't get e-mail notifications when you edit your question like that. You get faster help when replying to the question instead...

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

What are you trying to do exactly?

Never used cognos so I can't help.

That's what a datawarehouse does!

Anyhow, have fun.

Normally you'd join on the itinaty table where first port = 'port code'

Still not too sure where you need help here.

Can't see the tables, data nor code.

Not sure I understand. Myspace is hosted on sql server and it handles 1 million requests / sec.

Care to expand on your idea?

cengland0 (8/3/2011)

---

GSquared (8/3/2011)

---

Government's role in human civilization is application of force. So, the moment it moves outside of defense against force, it turns into a problem, not a solution....

Anybody familiar with Cognos?

http://www.sqlservercentral.com/Forums/Topic1150452-147-1.aspx

Not me anyways.

I'll see if I can reping this...

Can you paste the whole where clause you have right now (need to see the parenthesis)

It's still unclear to me atm. I'll read it back in a couple hours...

So basically you want the date filter to only apply to that 1 port.

All other ports show all rows no matter the dates?

Thanks for the feedback, adding to briefcase.

Of those 3 rows, which ones need to stay, which one needs to go.