I think this is very basic question. so do a search in google.

just try out this code

Select Detp_Desc

from document a ,department b

where a.doc_id = right(document_list,1)

Anybody explain me the N.N Part alone ?

Thanks Edvassie !

Any experts want to share their opinion in 'tempbd size'. Your inputs are highly appreciable.

Thanks Jeff ! Really i felt i have gathered some good idea.

Expecting some good answers from veteran developer.

You are correct. We have moved our database from 'virtual server' to 'stand alone' server.

Wow.....

There is a huge difference....Really !

Virutal server took 10 minutes to execute a query whereas standalone...

Gila,

if you give some generic solution to this problem,then it would be useful to everybody who have faced or going to face. Suppose if the server version is 7 or...

Try to avoid select * at any point of time.

Do write your sqlcode like

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

Select id,

name,

...

I want to know about our strength.

Any expert answer for my question ?

Any idea ?

I am not saying ' He doesn't have any work (or) he is working for me'. I thought, he might have the dump of all articles in a CD or...

I mean... Partnership with microsoft.

Will they build for me 😛