You should specifically state the collation you want to use.

Example:

SELECT col2 COLLATE Latin_General_CP1_cI_AS AS col1_collation FROM myTable WHERE col1=1

anuhya.mudumba (9/5/2010)

---

Thanks Lutz for your reply...

I cannot use it in the sql part. The requiremment is such that i should get the raw data from the tables and perform all...

What code do you run that takes 20sec?

Could you post the actual execution plan?

Without any auto-incrementing column or a datetime column with default=getdate() it's almost impossible to say. If data were inserted manually, there might be a chance to either echeck transaction logs...

Since your description is not very clear (maybe even contradictory when looking at #12345 and #12344 and the mixed usage of "most recent") I'm only guessing here:

Either Row_Number or a...

Would you mind providing an example of what you're looking for?

No. The solution I was talking about will work regardless of any DATEFORMAT setting.

If you use such a concept in...

If you want to insert a date without a time portion you can use the format YYYYMMDD.

This will work independent of any language setting.

As a side note: it's not the...

Great!

Now, would you mind posting what therror was so others might benefit?

would something like the following help?

SUM(CASE WHEN col1> 0 THEN col1 ELSE 0 END) AS DEBIT,

SUM(CASE WHEN col1< 0 THEN col1 ELSE 0 END) AS CREDIT

If not, please post table...

Jeff,

if I would have received 1$ each time a link to one of your articles (just to name Tally, CrossTab and DynamicCrossTab) did help an OP to solve one of...

You posted twice but still missed the right forum...;-)

For those trying to answer the question: it seems like it's related to SS2K8, even if posted in SS2K forum....

Please don't cross post.

It is just a waste of resources if there are answers or additional information in one thread that would be helpful to those reading the other.

Please respond...

Steve Jones - Editor (9/3/2010)

---

It is a nice break during the day. Course, I've spent 20 minutes out there 3 nights in a row with a bucket of water trying...

abe.nito (9/3/2010)

---

Sorry about not indicating it was for a homework, guys! The homework is actually trying to get an expert advice on how to do it and trying to apply...