I tried Rtrim, still no luck!

my result there is just an example.

you can assume that the name same with country

name = country

yes, it is a problem that the resultset is having blank column values! I want to remove those blank values in my resultset.

Any ideas how to remove them?

i used NOT...

there are blanks in the returned rows!

What do diagnostic record counts show

ie:

select count(*) As CountNull from dbo.SAME_NAME_DOB_GENDER

where name is NULL

0 row

select count(*) As CountBlank from dbo.SAME_NAME_DOB_GENDER

where name = ''

43...

select * from dbo.SAME_NAME_DOB_GENDER

where name is not NULL and name <> ''

Hi Guus! Just wondering if you have the scripts? email me leonson@hotmail.com

Cheers!

>Script    - there are some scripts doing this for you ( search the internet for >this )   basic steps;...

Just wondering why this happen???

Luckily, I can see in one computer the list of users so that I can assign them...

Thanks Guus! You're Right! That what I did and it's works now! =)

Thanks Greg!

Can you include your user defined function in DATE FUNCTION?

select dateadd(day,-1, MaxLoginTime('2004-11-20 00:55:41.000'))

got error msg:

Server: Msg 195, Level 15, State 10, Line 1

'MaxLoginTime' is not a recognized function name.

Got it! Thanks guys!!!

just a small db...where is the box???

restore complete with errors...

Here's the error log:

2004-11-18 15:31:21.84 spid11    1 transactions rolled back in database 'LEON' (7).

2004-11-18 15:31:21.95 spid11    Recovery is checkpointing database 'LEON' (7)

2004-11-18 15:31:23.32 spid3     Recovery complete.

2004-11-18 15:31:23.32 spid3     SQL global...

Thanks Dave!

Thanks for the link but in the article it didn't explain what the cost really mean.