"SELECT @tabremove = RIGHT(@stringWithTab, LEN(@strWithTab) - LEN(chr(9)))" . . . doesn't work because the "chr" function on the end should be "char".

you don't need to consider nulls and blanks because those same values...

this is a textbook case for merge replication.  see bol, "Filtering Published Data" and "Dynamic Filters".  the real issue is not getting the upload . . . it's preventing the...

merge. latency, relative to other models, is the lowest. there would be no connection/transaction continuity of course. so, anything in progress on the failed server would be lost. i don't...

nice box setup . . . extended memory is for the buffer cache only.  so, working within the normal 4gb virtual address space, there are two options only one of which is...

. . . a tough one in deed.  i'm sure this could be a bit more elegant but it does work. 

don't know why this post has the face icons . ....

this is our exact scenario and merge replication works great.

is the login for the subscriber on the publication access list tab?

SET NOCOUNT ON

DECLARE @tbl TABLE (GroupId INT,TaskId INT,Created SMALLDATETIME)

INSERT @tbl VALUES(1,2,'04/30/03 10:00')

INSERT @tbl VALUES(1,4,'04/30/03 10:15')

INSERT @tbl VALUES(2,9,'04/30/03 09:00')

INSERT @tbl VALUES(2,6,'04/30/03 09:05')

SELECT

    A.GroupId,

    A.TaskId

FROM

    @tbl A INNER JOIN

    @tbl B

        ON    A.GroupId = B.GroupId INNER JOIN

    @tbl C

        ON    A.Created...

might this work?

SELECTC.Cust_Name,

CASE

WHEN A.Account_No IS NOT NULL

THEN A.Account_No

ELSE 'NO ACCOUNT'

END

FROMCustomers C LEFT JOIN

Accounts A

ONC.Cust_Name = A.Cust_Name

ANDC.Location = A.Location

ANDA.Type IN (C.Acc_Type,'ALL')

WHEREA.Active = 'True'