The example above the parsename/replace will work for N positions up to 8000/len(delimiter)

Gareth

Just thought about it a little more

You could also use

PARSENAME(REPLACE(STRING,'DELIMITER','.'),POSITION)

Here's a scalar UDF I just whipped up that works like ParseName but with a variable delimiter.

Supporting Objects Required:

Numbers table that all databases should have.

Copy and...

Are these

OR client_contacts.OrigCommunityID = '30260'

hardcoded in your query or built using some kind of dynamic sql from the application?

As part of your insert of a new document, along wtih inserting the document as a BLOB object you could open the document using the JET database driver in an...

SQL 2005 has DDL triggers but not an option i guess

I know this is really old but I have a little that might help someone down the line.

CREATE TABLE [dbo].[Schedule](

 [Id] [int] IDENTITY(1,1) NOT NULL,

 [Name] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

 [Description] [varchar](1000) COLLATE...

While I haven't tried this and i've encountered the same problem I wonder if you can right click the db in the object explorer and script the structure (table schema,...

thanks remi, that answers a question I had. wasn't aware you could use from on an update statement in t-sql... cheers.

If applicable, you could create an insert trigger which would then allow you access to the inserted tables... but this would only apply for a single insert.

IE:

Insert into ... ......

Yes, good suggestion John.

Select ..., [NumTabs] = (Len([*Column*]) - Len(Replace([*Column*],CHAR(9),""))),... from [*Table*]

Where [*Column*] is the column you want to count the number of tabs in, [*Table*] is the source table,...