Reported as spam

Reported as spam

You can also make the function much more efficient and also enable it to go parallel by making it an ITVF
CREATE FUNCTION udf_IsAlpha(@Word nvarchar(50))
RETURNS TABLE WITH...

This should do the trick
WITH cteData AS (
SELECT
  Id
  , Name
  , sequel
  ,    Id + Name + CAST(ROW_NUMBER() OVER(PARTITION BY Id,...

Why not use SSIS to get the required data from ServerA, and save it to a staging table on ServerB.  Then join to the staging table on ServerB, and truncate...

I hit the "Clear Cookies" button at the bottom of the Main Forum Page.
This has marked ALL posts as unread, and restored the functionality.

Reported as spam

reported as spam