Appreciate your article.

This is with lot of explanation, but we can achieve the output more efficient way with the sorting of rolename also:

select distinct a.userid, substring(b.rolename, 1, len(b.rolename )-1)...

Actualy, I have updated some data in my database and want to retrieve that data.

But I don't know how to retrieve that data.

I have also read some topics...

Hi Vikas and Andrew,

I have created two logins, login A and B. After that, I made the Login A as db_owner and create a new schema with the name of...

Hi,

It's good query, but it not works in SQL 2000

Is there any query, which will give the same outpur and can use in SQL 2000

Hi,

You can use this query to get the tablename and rowcount of a database

select so.name, si.rowcnt from sysobjects so

join sysindexes si on so.id = si.id and so.type = 'U'

Thanks all,

I downloaded the XPSMTP80.DLL and added it in database. Now I able to generate the mail.

But I think that the dll file XPSMTP80 was made by some person with...

Hi,

Try this on this way....

create table #table

(

row1 varchar(1000)

)

insert into #table select '01008,03072,0045,R,,,,,,,,,,,,,,,,,,,,,,,,,,,,,-17'

insert into #table select '01008,03072,0046,R,,,,,,,,,,,,,,,,,,,,,,,,,,,,,311'

insert into #table select '01008,03072,0048,R,,,,,,,,,,,,,,,,,,,,,,,,,,,,,12336'

insert into #table select '01008,03072,0049,R,,,,,,,,,,,,,,,,,,,,,,,,,,,,,986'

insert into #table select '01008,03072,0056,C,,,,,,,-1057'

insert into #table...