something like this?

SELECT DISTINCT categories FROM sometable ORDER BY categories

will give you the list you described;

sorry, i cant seem to see how you know which column is which;there's no obvious pattern in the sample you rpovided.

If you could determine that column 3 was always an...

it's easier than you thought.

several ways.

add a constraint to the table where UserID <> @InvitedUserid.

Use the If example below.

this is one of those situations where the client side would have more functionality than server side.

once placed in an ADODB recordset, the recordset has the datatype and defined size...

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