it's not working. do you have other idea. This error is not occurring in our development office, only in the client.

Client computers are running windows xp sp2.

no one else know?

Ok... Many thanks to all of you! I will just play w/ it around!

Thanks again!

The subquery is a correlated subquery. All the where clause are different. Example:

select ...,

(select count(*) from myview where myview.id = m.id and myview.field1 = 1 and ....) as fieldname,

(select count(*)...

The select subqueries contains agregrate functions like:

(select count(*) from myview where ...) as field1

(select sum(field) from my where ...) as field2

How to use case for sql? Can you show some...

I get it now! I can kill the process so that I can take offline the database.

Thanks!

oh i see! i wish it will be on the next version of sqlserver

many thanks to u!!!!

Thanks! But why its not allowed in sqlserver to use directly expression fields?

thanks for the idea of derived table.

Thanks to this extended sproc technique. I just learned that it is possible to create objects inside sqlserver, what a nice feature!

Many thanks for the script Tobi. I will just...

I used this UDF alot to return only the date part. I got from some site. It is also possible to get the time part mathematically. I just forget the...

Many thanks to you Antares! And also for the tip on IF EXISTS alternative.

thanx for informing me.

i already install msde w/ a blank password. it goes well. and its only for learning purposes.

now, i just want to get tutorials about msde. do u...

tnx for the reply...

i dnt have any previous msde installed and solve my own problem. i just use the command:

setup.exe blanksapwd=1