Thanks Preethi,

I was thinking in the line of this...

select *, TotalMonth = Region1 + Region2 + Region3 + Region4

from

(

Select

Sum(Case Region When 1 Then (xvalues) Else 0 End) As Region1,

Sum(Case...

thanks all for your replies. The order by was causing the problem. Why didn't it effect if I used the select statement alone?

"select column2, column3,column4, column1 from #table order by...

The first step before you can begin log shipping is to ensure that the SQL Server login IDs are synchronized between the production and standby servers. This is important because...

Not sure if this answer your question, but check the article posted by Joseph Sack http://www.sqlservercentral.com/columnists/jsack/aweadventures.asp

No sure what the message means since it is in Italian. My guest was there may be problemw with ASP data connection. Make sure the connection have right to access...