I never try to blame or cheat anybody. Becuase i don't like that, i always go smoothly with my sorrounding.

I thought i gave my advice without hurting him. But...

Oh.. i never think my advice turn into very bad one. I don't try to act arrogant(never).

If my words looks like that , then i am sorry.

sqldba,

first of all try yourself, otherwise you can't learn anything new. Try to write your own SP. Becuase it is a basic one, without knowing how to wite a simple...

Sqldba,

CREATE PROCEDURE ***

@macname varchar(30),

@user varchar(30)

AS

--Select user from table1 where tuser =@user

If (Macid= @macname)

begin

...

Say for example,

create table #Emp

(

Eno int,

Ename varchar(5)

)

insert into #Emp

select 1,'AA'

union all

select 1,'AA'

union all

select 2,'BB'

union all

select 3,'CC'

select distinct * into #FinalResult

from #Emp

will give you the expected result.

Simply you can use DISTINCT keyword.

If you give some sample data's you will get lot of help from here.

I also studied the below URL. So i am clear with Sybase side.

http://www.mydatabasesupport.com/forums/sybase/239321-sql-error-code-404-too-many-ands-ors-expression.html

Now, I want to know the limitations in Sql2000,sql2005 and sql2008.

can anybody refer some URL's ?

I want to know the MAXIMUM limitations of the following statements.

where could i find the details ?

IF

CASE

AND's

OR's

Number of columns in a SELECT statement

Trigger ( Upto 128 nested level...

Just i saw the below URL.

http://answers.google.com/answers/threadview?id=315972

but no guarantee there for others... how do you know that some RDBMS's won't simply turn the IN list to a working table and join...

Reproduction using the AdventerWorks demo database:

1) Run this first and save the output to a text file:

select 'or ContactID = ' + cast(ContactID as varchar(20) )

from Person.Contact

2. ...

I have executed a query which has more number of ( around 500) string's in the IN clause. (All of us know IN...

I searched on websites, and found one URL.

http://www.dbforums.com/showthread.php?t=931923

Any inputs apart from the above one ?

anybody want to refer some URL's to know about it, then it would be nice.

Thanks a lot for all of your suggestions and advices.

I have done my presentation very well. They are quite happy. My offshore manager also appreciated me.

As you people suggested, i...