Alvin Ramard (6/9/2009)

---

I don't think that's...

I really hope you have more than three columns in this table. there is no order assumed in a table, so what determines the order of the rows in...

Okay, I must be in pissy mood today and I have NO idea why. I just lmgtfy twice in the same thread...

Really? Here, let me Google that for you also.

Unfortunately, I have no idea. How is the data being moved from the staging table? Are you using SSIS, T-SQL Query?

It would help to have more in depth...

An ER Diagram is a Entity-Relationship Diagram. There is no way we can...

Just a little thing, but may I suggest you write the query more like this:

select

database_name,

max(backup_finish_date) as backup_finish_date

from

msdb.dbo.backupset ...

karthikeyan (6/9/2009)

---

Gail,

i expected this question from you. Since i studied these concepts just to pass the exams, beacuse that time i don't know the real time usage and it will...

Paul M. Corley (6/8/2009)

---

SQL Server date functions don't calculate FISCAL dates very well mainly because of the multiple ways you can assign the 5th week of the month. I...

What works for one server, my not work well for another. You really need to accomplish this more on a server by server basis. Every application will be...

At this point, contact your network/server admin people. There are only two administrative terminal services connections available to a Windows Server. If you can't connect, then both connections...

Why do you keep opening new threads? Use the original thread you first started. Continually open new threads is just going to get people upset, and you won't...

Still waiting for an explanation as well as what the sample data SHOULD look like if it was sorted correctly.

Please do not double post requests for help.

Please post any responses here.

Sounds like you are trying to connect to your sql server system on one of the two remote admin terminal services connections and both are in use.

If you have a...