the above also would not take into consideration if there were 3 or more rows that should condense to a single time slot you'd need to handle it differently, most...

you gotta try what i posted: you end up with a 15 character string with the preceeding zeros you requested.

SELECT RIGHT('000000000000000' + CONVERT(VARCHAR,1),15)

SELECT RIGHT('000000000000000' + CONVERT(VARCHAR,86456),15)

SELECT RIGHT('000000000000000'...

you want to change all the objects back to smdb;

--find everything NOT owned by dbo, and create the sqls to change them to dbo as owner:

select 'EXEC sp_changeobjectowner...

it really depends on what your UDF is doing;

we need that code to determine whether this can be done cleaner; the more real details you post, the better we...

when you say the columns are not in the same order, what do you mean? is the data in name:value pairs, like 'fruit:apple;vegetable:peas and carrots;'

could you post a couple of...

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