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...

Absolutely agreed.

Now the OP can decide which scenario he's dealing with and he has the "best-fit solution" for either one. Can't be any better, right?

WayneS (9/2/2010)

---

...

Based on this, where the work order ID is the 2nd "field" in this string, I would suggest :

declare @test-2 varchar(100);

set @test-2 = 'W~W51247~0~1~0';

select Item

from dbo.DelimitedSplit8K(@test, '~')

...