hi all,

thanks chirag for your suggestion. but that code is still giving me a number, which i supposed is the number of distinct entries..

anyway,i found a way to do it.

SELECT...

hi all,

i managed to get a result using the above suggestions,but i am not sure hw to interpret it.first of all, wat i want is,to find out how many times...

halo.. thanks so much for your suggestions. i will check the stuff u mentioned,and hope it'l solve the problem.. thanks again;)

forgot to mention another weird symptom. the first time this happened, i thought it was a permission error.so i meddled with the permissions,and granted datareader and datawriter access to the...

hi evryone..

i manage to execute the sql query, and got a 3rd table which merged all the data from table 1 and 2.however, when i randomly checked the data in...

hi every one,

thanks for ur replies..i double checked my sql statement and executed it again..it worked!!

thanks so much:-)

hi,

i tried your suggestion.i can parse it without any error.but when i tried to run it,i get:"String or binary data would be truncated.

The statement has been terminated."

seem to me dat...

hi ppl!!

i tried using the select into statement.however, i cant see how i can actually merge two columns from two tables into one.

maybe i shud explain further.

Table1 has (userid,username,password,email,status)

Table2 has...

hi people!!

thank you so much for your replies..

i will try out the methods u suggested.Actually,i am suuposed to be integrating a few tools into one.All the tools have a general...