The complexity required for these statements is a pretty good example of why you should just leave time as a datetime field.

That said, you can use something like this:

select *...

That's an interesting update. I'd make sure that this was right, but here is how you'd write that:

UPDATE P

SET OrderNo = S.OrderNo

FROM Payment P

...

Add it right after all the joins in the CTE.

REPLACE(String,' ','')

Cross post. No more replies here please. Reply here instead:

http://www.sqlservercentral.com/Forums/Topic810794-8-1.aspx

A couple things.

First, don't cross post.

Second,...

Jus (10/29/2009)

---

Garadin..This was plain self join i know....Some time back i have seen a solution to simillar kind of problem in SSC in a different form, i guess they were...

I'm sorry, was there a question in there somewhere?

Heh, no, it was my fault. It's how I was considering doing...

What have you tried so far?

Look up ROW_NUMBER in BOL and have a look. The idea would be to number all the rows then join the table...

If you already have a list of all the languages, a simple crosstab (or pivot, whichever is easier for you) should solve it unless I'm misreading something here. Jeff...

dmoldovan (10/29/2009)

---

I'm still not sure what result do you want to obtain...howhver try to use '[C-F]' / [CDEF] instead of 'C, D, E, F'.

See also BOL ---> "Pattern Matching in...

lmu92 (10/28/2009)

---

Garadin (10/28/2009)

---

I do seem to remember that there are slightly different variants of both of these methods that are supposed to overcome very specific problems though (using a higher...

Err oops, forgot you specified you were using a stored procedure. Yes, they're dropped implicitly when the SP ends.

That's not going to work out too well. There are a lot of options for doing something like this, but this one isn't going to support concurrency at all....