Here is my advice:

1.Create a C# Application that Can read data from those services an schedule it so that you can accomplish your goal

2. It is possible to use COM...

Select ApplicationName, Convert(varchar(13), StartTime,121) as Dte, Count(*) NoOfUsers

from YourTraceTable

group by ApplicationName, Convert(varchar(13), StartTime,121)

order by 1,2

As you probably can see there is no uniformity in for example Jr sometimes was set on the first name, sometimes on the Last ... some names have even stuff...

and if the replicated data was done with merge then have alook at

sp_validatemergepulication and sp_validatemergesubscription

or if it is transactional or snapshot:

sp_publication_validation may prove usefull

Well I am off!!!

Have a good weekend

Steve,

How sure are you that ALL your data is following the Last,First, middle format?

And if you feel confident how will persons with two or more Names or Surnames are handled?

Can you post some examples?

Have you tried?:

BULK INSERT Data.dbo.TableName

FROM '\\server\filename'

WITH

(FIELDTERMINATOR = ',',

ROWTERMINATOR = '\r\n'

)

Create trigger on YourParentTable for Update

as

if @@rowcount = 0 return

if update(YourParentBitColumn)

 begin

  Update C set ChildTableBitColumn =  i.YourParentBitColumn

   YourChildTable  C

   join

   inserted i

   on c.pkey = i.pkey 

   where

 (i.YourParentBitColumn is...

03 Nissan Pathfinder .I would like my 88 honda back though .... maybe not

[Edit:] Oh, and yes I AM STUCK with it

Happy to Help

can you write an example of what you are trying to accomplish ?

select convert(varchar(12),getdate(),114)

Does this table has a CLUSTERED index or is it missing one?

I feel compeled to warn you if you are using SQL Logins that method does not work in Access 2000!

Cheers!

how about:

the concatention can also be used with chaindex:

IF(SELECT CHARINDEX( ','+'JK' +',' , ','+'TRC, JK3, YS, HA'+',')) > 1

print 'alright'

ELSE

print 'oh no'

and "oh no" is returned