Thanks for your reply.

Can you give me any idea on how to start with SP for replication or any articles on key points to noted on configuring replication between SQL...

But in this case , the apllication is sending some strings

example

(SVDB, N, Y; SFGB, N, N; SGTE Y, S; SVHG Y,Y; SVFH, Y, Y; ........)

data set in string may...

Thanks for your advice.

But let me know, how can the strings of data can be revitrieved one by one and check if one of the value (Acctid ) in the...

Thank you,

This is working fine

Thanks for your reply.

I wil try testing using this.

Thanks for the script , it is working fine

Thanks for your response. It works fine.

Thanks for your response.

I have already tried that option.

But what i actually required is that, each day there are number of entries for quantity.

Quantity mean "shares" a accountid makes. So...

I have tried starting with the below query

select t3.id, t2.groupname, t1.quantity, t1.price,t1.date from table3 t3

join table2 t2 on t2.groupid=t3.groupid

join executions_history t1 on t1.accountid=t3.accountid

where

t2.groupname='s1'

In result i need the sum(quantity *...

Thanks for your immediate response.

Do you have any scripts to find out who are(were) logged in on a server and what databases they access.

Thanks for your response.

If the server is SQL 7, how can i do it.