while facing similar problem earlier, i had given up this because of not having much time to spend on this. now i think i got the answer to this problem....

even i had the similar scenario and dealt the same way. i havent found any way out yet.

good luck with your task of opening and closing DTS.

I think you want to count number of views in database rather than...

i checked few of the string functions which can be used with unicode dataypes on Latin1_General_CI_AS collation

list of functions that can be used with unicode datatypes

len

substring

charindex

patindex

cast and convert

ltrim and rtrim

stuff

left...

can you please post the exact results you got after running above query as number of columns in sql query dont match with your output results?

The one way I've found to get around this is to first move the data into a table variable, then move it to the other server. Since table variables...

thanks. that was the answer i was looking for

Can you please clarify that you need 'cat' as value in column or substring in column name?

Hi Adam

The link you provided is really good.

But unfortunately i am back in the grave. The test i did with @@ERROR also failed. It compiles but fails when i...

i think this would fail if it finds "Size" in the beginning of string. How will it substract 2 chars if current position of the string is 1?

I haven't tested...

You can use SOUNDEX() in sql server.

more details can be found at http://msdn2.microsoft.com/en-us/library/ms187384.aspx

It is sometimes very dangerous to use this function. It is entirely dependent on your...

There is another way to acheive this result using COALESCE.

CREATE TABLE test

(id int

, comment varchar(255))

INSERT INTO test

VALUES (1, 'JOHN SMITH')

INSERT INTO test

VALUES (1, 'SURRENDER')

INSERT INTO test

VALUES (1, 'TO COPS')

SELECT *...

try this

DECLARE @s-2 varchar(255)

SET @s-2 = 'Mark_m_andrew_levey_caa12002'

SELECT substring(@s, charindex('_caa', @s-2)+1 , len(@s))

if you are trying to find all tables in database with zero row count, you have to write a program which runs a query to find row count for each...

i think, the conclusion depends on what you need and the way you like. 🙂