I won't be hanging around The Thread during the day Saturday and Sunday. From the looks of it, I may be freezing up and down the pitch those days...

Does the following ode help you out?

declare @IntDate bigint,

@CharDate varchar(32);

set @IntDate = 20100224184500;

set @CharDate = CAST(@IntDate as varchar(32));

select @IntDate, @CharDate, cast(stuff(stuff(stuff(@CharDate,13,0,':'),11,0,':'),9,0,' ')...

BaldingLoopMan (2/24/2010)

---

I think i may have made some quick judgements about you Lynn and for that i'm sorry. Apparently those u call friends on this site do not feel you...

halifaxdal (2/24/2010)

---

I just talked to AD guys, one of the clue is: How SQL talks to AD to authenticate a valid user? is it possible to manually configure (hardcode it)...

Tom.Thomson (2/24/2010)

---

I'm slightly concerned about the apples and oranges issue: is what you are measuring just generating a cte with the...

BaldingLoopMan (2/24/2010)

---

============================================================================

gsquared:

One of the most fundamental rights any human being has (or has been denied) is the right to choose with whom to associate. If Lynn, or anyone else, chooses...

Tom.Thomson (2/24/2010)

---

I'm slightly concerned about the apples and oranges issue: is what you are measuring just generating a cte with the...

Ditto, glad you were able to resolve your problem. Also glad that you provided feedback on your problem, as this could help others with a similar problem.

Not sure, but looks like it might be a missing or corrupt xprepl.dll file.

If you do post a dmp file, zip it and attach it to a post.

To do a side by side install, SQL Server 2008 will most like need to be a named instance if SQL Server 2000 is installed as the default instance.

reidres (2/24/2010)

---

The N being written to the table allows you to retreive the data in the proper order by including the necessary ORDER BY clause on the query. With out...

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