Will it satisy all my needs ?

User will not enter any values. 'AND' and 'NULL' values are constant values.

what i have mentioned in the Insert statement is the constant value .

I want to split the AcctDetails...

I am having Sqlserver 2000 Client tool. Right now i am using Sql Server 2000.

My onsite has installed sqlserver 2005 and asked me to install Sqlserver2005 tool in my local...

Thanks a lot David and Jeff !

Really i gathered some knowledge about Cursor and 'SetBased' Thearoy from your posts.

Regards

Karthik

Thanks Simon !

Can you expalin about Merger Join and Hash Join ?

Regards

Karthik

Hi Jeff,

Thanks !Really i got some idea to use while loop instead of Cursor.

I have two questions.

1) What is the difference between Cursor and While Loop ? as you mentioned...

Jeff,

I am believing you ! 

Are you Happy now ?

I thought this is different question, then only i...

Thanks a lot to give answer for all the questions !

Yes Simon , You are Correct ! They have Sybase BackGroud.How you find it ?

Regards

Karthik

Thanks Andras and Gila !

Thanks Andras !

Mentioned Article is very nice !

Regards

Karthik

shall we implement try...catch logic in sql2000 ?

Regards

Karthik

Jeff,

Can you tell me why database is designed based on 'Set Based' instead of 'Row by Row'. What is the advantage over it ? While designing server why cant we apply row by...

My Code is,

----------------------------------------------------------------------

select name into #t1   

from sysobjects   

where type ='U' 

and name not in ('ProductCommitmentWorkflow', 

                 'Tranche', 

                 'CompanyTrans', 

                 'ProductFeatureSelection', 

                 'ProductFeature', 

                 'ProductSubType', 

                 'ProductType' 

                 )    ...

Giff,

I am using Sqlserver2000. I have only DBO access not DBA access permission. I dont have Management Studio , i am having Enterprise Manager in my PC.

How to handle those...

Peter,

This is my code.

CompanyTrans Table : 180240

AcctEntry Table : 755320

-------------------------------------------------------------------SELECT DISTINCT Seq = identity (10),

 A.CompanyInstitNbr, A.TransNbr,

 CONVERT (char (10), A.PostingDate, 111) +

  CONVERT (char (5), A.TransNbr) +

  CONVERT (char (8), A.ValueDate, 1) Combo,

 TransTypeCode...