Lynn,

I'm not talking values. I'm talking names. If the collation is not the same as the one he listed, then the name "trade_date" might not be the column name.

But again,...

Matt Miller (3/9/2009)

Why wouldn't it guarantee uniqueness? You end up with distinct combinations of each item in the GROUP BY list, which is essentially what the DISTINCT will do....

ACK! Domain Admin BAD karma for security reasons. Make the user account a plain...

I understand what you're saying about the timestamp perfectly. However, you're still sending a ton of records one way or the other over the network. Let me put it this...

If you aren't getting the values you expect, then something is wrong. Either your table / column is case sensitive despite the fact that your DB is case insensitive or...

When I talk about processing resources, I'm not talking about field by field. I'm talking about having to take the timestamp of your DW to the timestamp of either your...

NP. Hope it helps. @=)

Bob Hovious (3/9/2009)

---

I have colleagues who use GROUP BY clauses without aggregation in place of a SELECT DISTINCT. The results appear to be the same. I've always used a DISTINCT...

sotn (3/9/2009)

---

I wasn't suggesting to use Timestamp as a date comparison just a value comparison, as I would be doing a join based on the primary key field (not the...

I'd agree with the temp mapping table approach because a CASE statement can inadvertantly overwrite an "earlier" conversion if you're not careful. Also, you can use the IN for the...

One thing not previously mentioned, which happens in our environment all the time. If you have procs constantly added to the database which the client needs to use and this...

Have you tried the following yet?

Select * from tbldeals

where trade_date = '03/06/2009';

Depending on your database collation, this might make all the difference.

Nelson,

Do you understand the difference between GROUP BY & ORDER BY? GROUP BY is like taking a bowl of fruit and putting the grapes with the grapes and the apples...

Did any of the other information help?

Have you looked at DDL triggers yet? They can help you log the information to the table. Then all you have to do is schedule a job that checks for...