First insert_offset is zero based

Second your patindex will only find occurrance if the column ends with 123456789123456789

Try this

WHILE 1=1

BEGIN

  SELECT @ptrval_s = TEXTPTR(Text_Column),

    @patptr=PATINDEX('%123456789123456789%',Text_Column)-1

    FROM #MyTable  where...

It means the table has been altered in the diagram but the diagram has not been saved.

If the 'column' may or may not contain spaces then this should work

SET column = LEFT(REPLACE(column,' ',''),9)

When you state this would 'violate the primary key constraint' then any modification of...

OK if we're playing at guessing the query

I got out my ouija board and got this

Not sure what you are asking for but

WHERE trandate < @ENDDATE

seems right as long as @ENDDATE is set correctly

So, today is Thursday 22 Dec, midnight tonight would be

'2005-12-23 00:00:00.000'

Therefore this...

You are actually using T2.firstname+T2.surname+T2.email as a unique id

WOW! I surpassed even myself

I enjoyed the "urn" joke!

and what's a "grecian" "urn"

a damn sight more than me

OK first off the top of my head and providing there are no duplicate contacts!

SELECT T1.*,T2.*

FROM T1

INNER JOIN (SELECT a.[id],MIN(a.firstname+a.surname+a.email) AS FROM T2 a GROUP BY a.[id])...

As stated in the link you will not be able to replace your temp table with a table variable and even if you could I doubt there would be any...

Yep, if you put a valid path to a filename in the 'Output File' field then all the output of the DTSrun will be in that file including any errors....

Don't need to use a cursor

CREATE FUNCTION fn_GetDays(@Secs As int)

RETURNS varchar(36) AS

BEGIN

DECLARE @GetDays varchar(36)

-- Get the Days, Hours, Minutes, Seconds returned with input in Seconds

--...

I think this is what you mean

UPDATE h

SET h.codsuc = 'AT'

FROM ventven h

INNER JOIN (SELECT l.nofact

FROM vligven l

WHERE l.codart IN ('TOT PPO01Z', 'TOT PPO000Z')

GROUP...

Also remember that non fatal errors will not stop/abort a proc unless you set XACT_ABORT otherwise you will have to trap non fatal errors after each statement.

OK try this, may work better as no conversion to datetime required

SELECT

CAST(TS_TIME_ASSIGNED / 86400 as varchar) + ' days ' +

CAST((TS_TIME_ASSIGNED % 86400) / 3600 as varchar) +...