You could do this:

mike 84768 (2/24/2010)

---

You could also use the Datepart function...returns an integer representation of the year.

WHERE...

Actually using it to parse HTML, iirc. I didn't write the code, I shared my knowledge of the Tally table with a co-worker who implemented it.

Here is some test code:

create table #TestTable (

DataValue varchar(24)

);

insert into #TestTable

select '399.' union all

select '400.' union all

select '400.367.' union all

select '400.35.369.' union all

select '37.367.369.3' union all

select...

Based on the data provided in your original post, what would be the expected result?

tstaker (2/24/2010)

---

Lynn Pettis (2/24/2010)

---

I have to disagree here. This is a good way to see how some thinks. Do they write a cursor or while loop to complete...

reidres (2/24/2010)

---

Lynn Pettis (2/24/2010)

---

My problem with comparing the two solutions above is you are actually comparing apples to oranges. Jason's routine is returning the results...

tstaker (2/24/2010)

---

CirquedeSQLeil (2/23/2010)

---

reidres (2/23/2010)

---

OK, I ran Jason's (CirquedeSQLeil) updated code (modified by me as before) and got 0:54, which puts it as the fastest time of the scalable three that...

jcrawf02 (2/24/2010)

---

Interesting change Lynn. I love when you guys start testing competing methods, because it always means that I'm going to learn good stuff without actually having to *do* anything...

Improved the performance of my code, I moved the row_number() function into its own CTE instead of in the last CTE accomplishing CROSS JOIN's. Increased performance almost 50%.

My problem with comparing the two solutions above is you are actually comparing apples to oranges. Jason's routine is returning the results directly where as...

And?

Please be aware that by using the ALLOW_DATA_LOSS repair option you may have done just that, lost data. Please start a scheduled backup plan immediately so that if this...

GT-897544 (2/23/2010)

---

SAT_SQL (2/23/2010)

---

Hi

All

my DB, please provide any step by step procudure for the .

It look like this satmman(suspect)

primary database coruppeted,it is in the suspected mode want to...

I posted my solution to the FizzBuzz challange on AskSSC. :smooooth:

Should we save the 12,000 post for Gail when she gets back from being on-site with a client?