Hi Gail,

What if we have 2 SQL servers, 2 listeners, and both the SQL servers are having read only databases.

EX: the user should login to SQL01 and read...

Sorry.. the code works my bad i had duplicate servername is the txt file.

Question: what if i have multiple servernames? do i need to use multiple >>>>?

Thank you.. but this inserts duplicate records for the first server name..

This is working thanks.....!!!

sql server 2008 sp2

so how should we use this statement without returning 2 records

select

case when Void = 0 then SUM(weight) end AS totalweight

from test

when i use this i get

result as:

total weight

NULL

1.7

Please...

Iam getting the following error when used executing the query

select

sum(1-void) as Countofsuccess,

sum(void) as countoffailure

from test

Msg 8117, Level 16, State 1, Line 1

Operand data type bit is invalid for sum operator.

Thanks a lot,

It works good.

Iam having a date coulmn with datatype as varchar (8) and time coulmn with datatye varchar (4)

data:

date column: 20061025

time column : 1228

Thanks.

yes, i was using view designer and getting that error. I had to see it because i am getting the same error in the production database error log and it...

here you go with the full stored procedure. And yes my table is very large it contains 64 million records.

can you please help me with this.

Thanks.

I have this type of ASCii characters in the column how do i find all in a single query other than alphanumarics.

Thanks,

(space)

!

"

#

$

%

&

'

(

)

*

+

,

-

.

/

:

;

<

=

>

?

Yes, am looking for the special charaacters in the column other than numbers and the alphabets.

Thanks.

Yes

I have a table in which a couple of columns (varchar) is having ASCii characters so how do i find them using a sql query?

Thanks.