Here is the function I use for this purpose: It requires a numbers table. It will split a string based on any single or multi byte delimiter.

CREATE FUNCTION dbo.ParseString3 ( 

Simon,

SQL server also supports a function to see if a column has been updated. The syntax is UPDATE(column_name) and will return true if the column has been updated. You...

There are a lot of factors to consider with indexes.

1. When you are considering a candidate for a clustered index, consider the selectivity of the index. A clustered index should...

If you can be explicit, be explicit. Otherwise SQL may have to do an implict conversion (which adds overhead).

Be sure to check and make sure you do not have any...

This will do it:

PRINT CAST(CAST(20070105 as VARCHAR(8)) AS SMALLDATETIME)

Be wary of the overhead this will add in a query.

No Problem, I'm glad I could help!

Of course, sorry! When building the PIVOT result set, SQL Server automatically adds a GROUP BY clause that groups by all the columns from the table_source that are not either...

If I understand your post correctly, you don't need to group by in the UPDATE. just use the distinct keyword in the select statement following the update.

just a quick thought:

try replaceing

SELECT * FROM PersonStat

with

SELECT URN, StartName, StartValue FROM PersonStat

Hi,

the workaround you are attempting is correct. Keep in mind that sp_executesql requires an NVARCHAR parameter. Prefix your string with an N. See this example:

DECLARE @str1 VARCHAR(8000)
DECLARE @str2 VARCHAR(8000)

SET...

Heh, I guess I'm really slow today. Glad you're sorted Jeremie

Noeld has already posted a great resource to solve your problem while I was working on it. I've got this code now so I might as well post it. This...