You could keep the function, but change it to an inline TVF, like this

CREATE FUNCTION dbo.Stringmultitypes ( @id int )
RETURNS table
AS
  RETURN SELECT Types = CAST(STUFF((
...

If the source and destination tables are the same structure, you can swap out the partitions

Are you truly still using SQL 7 or SQL 2000?

Is there a way to specify a column name for the IN section of code to keep it dynamic? Otherwise, every time there is a new value in the...

SELECT
acc
, COUNT(*) AS numOfAcc
, COUNT(DISTINCT token) AS numOfTokenPerAcc
FROM 
dbo.Test1
GROUP BY acc

Based on your sample data, this returns the same result.

WITH cteData AS (
  SELECT      t.tid, t.b, t.E, seq.st, seq.nd
  FROM...

Man!  You are so right!  This is going to be totally liberating for me!

To commemorate my new found joyous method for doing my job without being a bottleneck,...

To add to what Grant has stated, I agree that "new" voices are a bonus on any forum but I have seen some "new" people come in with...

My apologies.  I wanted to Quote Jeff's answer, but accidentally hit the REPORT link instead.  Are Admins/Mods able to please undo my error

This was the post (copied from my mail)

To...

Declare @DBID Int Set @DBID = DB_ID ()
Checkpoint
DBCC DROPCLEANBUFFERS WITH NO_INFOMSGS
DBCC FLUSHPROCINDB (@DBID) WITH NO_INFOMSGS

That will clear execution plans and data from memory, which would...

NOLOCK and READUNCOMMITTED only affect reads.  This proc is doing inserts and updates, so it MAY have an impact if all other procs use NOLOCK/READ UNCOMMITTED.

My gut says that changing...

You are formatting your input string with style 101, and then asking SQL to interpret it as style 100.

You need to match your style to your input string

How to post data/code on a forum to get the best help.