Hi Grant

Nice post and Thanks

By the way, what is your call sign?

Thank you

Refreshed my mind and helped a lot

Appreciate it.

OK, I found it

Hope this is better method?

Thank you for guiding me to the right direction.

Did it successfully using dynamicSQL and it works like a charm.

Thanks for the replies

Do you think the replication will allow the users to access both DBs (separate users/purposes) while replicating?

Never done these before and need to read more on...

If its only Management Studio, I think you can install it from Installation DVD. Dunno whether any special license required.

If you need the Database engine as well, then I advice...

Thank you very much.

The problem solved using the method suggested and it worked very well. Trying to comprehend the sql;-)

Thanks again

Thanks for the guidance.

One week monitoring of current server (using more than one tool) showed us not much IOPS but more than 95% CPU and Physical RAM usage most of...

Hi Gila

That was really helpful and I ran one script from the book and result for one DB is attached herewith as an excel book. Please check the values and...

Thank you for the very helpful response.

I am going to talk to the server vendor on Monday about the storage again. Also, going to run the performance monitor on the...

So,...

As I stated earlier, it is used inside the CASE..END to calculate a value. Eg:

SELECT S_Person,Sales,(CASE WHEN Sales > 100 THEN (Sales * [Commission Per]) ELSE 0 END) AS Commission...

My GOD :w00t:

That was new to me. Thank you very much for ORDER BY hint

Thank you for the reply. Were really useful to create my version like

SELECT T.CusRange,COUNT(*) AS NoOfCustomers

FROM (

SELECT CASE

WHEN Amount > 10000000 THEN '0: Over 10M'

...

Dear Jack

Actually, that's what I have done. How can overcome this issue? Any better workaround methods?