GSquared (11/29/2011)

---

Having "Others" as the column value is a matter of a Case or IsNull/Coalesce statement in the Select clause.

In the Order By, you can put a Case statement like:

Order...

Thanks for all the help and concern about the preciseness about the date/time. The project doesn't require that precise at this time.

LutzM (11/24/2011)

---

You didn't mention anything about the parameter @timeline, just three scenarios...

Based on more than 500 points on your side I would have expected you know how to provide ready...

I just figured out these queries to pull out data:

--Since last year

select LastUpdatedOn from infosys where datediff(dd, LastUpdatedOn, getdate() ) <= 365

--Since year to end

SELECT LastUpdatedOn From Infosys where LastUpdatedOn...

For a test I wrote this query and hoping to get all records within the last year (<=365 days), but it gives me more than that:

select LastUpdatedOn from infosys

where datediff(dd,...

Thank you but I don't think that answered the question:

say the table has two columns: ID, LastUpdatedOn

It has records like:

42009-02-13 17:43:33.110

122009-03-02 11:54:19.590

142010-10-13 18:13:46.470

162011-02-11 10:43:45.503

172010-09-29 14:18:12.720

182010-05-22 18:00:20.680

192009-04-16 16:02:07.540

202008-11-12 12:39:07.343

212009-10-13...

Cause identified! It turned out that I was missing some privileges in the server, I can't create database! That's why although I installed it, it was actually never been installed...

I found mdf file for the sample database, however I failed with this:

TITLE: Microsoft SQL Server Management Studio

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

Cannot show requested dialog.

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

ADDITIONAL INFORMATION:

Parameter name: nColIndex

Actual value was -1. (Microsoft.SqlServer.GridControl)

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

BUTTONS:

OK

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

Actually in the instance dropdownlist, it doesn't allow me to manually type in anything.

And Management Studio does see a localhost and all the system databases! So the instance does exist.

I just did it again: this time I noticed the problem might be because the "installation instance" is empty when I installed it. Why it is empty? and I can't...

DBCC CHECKDB didn't find out any error in the database, is there other method that I can check the health of the database? I am sure there is some problem...

GilaMonster (9/13/2011)

---

Absolutely,...

A backup room is being seeked and hopefully we find it so we don't have to do the fix on the real prod server

OK, back to the topic, it would be greatly appreciated if you can watch this more like a realtime, I will be having a conf with the original db's tech...