i think i was able to do this as a set based operation by joining the table against itself:

take a look at the same data and my results, adn tell...

yes...but you have to take the same code from that function, which uses charindex and other stuff, and incorporate it into your query.

That makes it harder to read, but...

can you add another column of data which contains only the non-HTML data, and fulltext against that instead?

I've got this old 2000 proc to strip html out via TSQL, but...

Since your operating system is a server operating system(ie Windows2000 Server, 2000 Advanced Server, Windows 2003) the install dummies itself down to the Express Version.

I believe that is what you...

take a look at your WHERE statement:

WHERE TIMESTAMP=(SELECT MAX(TIMESTAMP)FROM DEMANDSPREAD)",

because this query is keying off of the TIMESTAMP column, it would greatly benefit from having an index on it.

that...

look in the script contributions here on SSC and find the split() function. it takes a string, and converts it to a table based on the delimiter.

select dbo.split(@a,',') would return...

to do what yoiu are asking, you need to take the RIGHT() 15 chars of 15 '0' + the convert of your value.

for example

SELECT RIGHT('000000000000000' + CONVERT(VARCHAR,GETDATE(),112) ,15)

look at...

anytime you SELECT something, you technically could insert it into another table.

if you did SELECT TOP 5 NAME FROM sysobjects WHERE xtype='U', there's 5 rows right?

if INSERT INTO SOMETABLE(TableNames)   SELECT...

--As Ray identified, an integer will return as a valid date, so you need to filter the results with what date ranges are acecptable for you:

declare @someval int,

        @MinDate...

system stored procedures have a lot of notes in Books Online.

all the other stored procs would be created by your developers or some other party, so it's up to...

just a quick note: your trigger will fail if the INSERTED table has more than one row . you should change it to something like this:

if update(entry)

  begin

    update results_ext...

awesome! glad it worked out for you.

It was a neat challenge to try and figure that one out. It's really just grabbing building blocks of code I used before, and...

lol sorry for pointing out the obvious...I'll read a bit more on it and see if i find something un-obvious.

Gordon that latch type 2 error made me remember that there was  a problem in early service packs....while it might not be your specific problem, what version is on your...

bcp doesn't allow you to append files, but the COPY command certainly is able to do it.

here's a complete example: it uses the function i suggested above.

psuedocode: bcp, make header,...