scarlam (10/25/2012)

---

I apologize about that. Glad you were able to make sense of my question. My table structure would follow along the lines of what you have posted.

How...

To assist those who want to assist you. please post the table definition, sample data and required results from the sample data.(Click on the first link in my signature block...

If I understand your request correctly, this may be helpful to you

CREATE TABLE #Dob(birth VARCHAR(15))

INSERT INTO #Dob

SELECT '24-10-2012' UNION ALL

SELECT '01-01-2011'

...

Try reading these:

Estimating the Size of a Nonclustered Index

http://msdn.microsoft.com/en-us/library/ms190620(v=sql.100).aspx

Estimating the Size of a Clustered Index

http://msdn.microsoft.com/en-us/library/ms178085(v=sql.100).aspx

Here is one way;

-- Created only to show effect of ORDER BY clause

CREATE TABLE #t(proj VARCHAR(1),carac VARCHAR(5))

INSERT INTO #t

SELECT...

This might be what you need.

SELECT sqlserver_start_time FROM sys.dm_os_sys_info

Returns :

2012-10-17 23:03:26.687

So create your table and then insert the result of the T-SL, it will give you at least...

Thanks, always nice to be reminded of the basics ...

Nice question - glad I read it 3 times .... subtle but nice

In the previous link note the following:

You can also decide whether to save the package to...

You can learn how by going to this link.

http://msdn.microsoft.com/en-us/library/ms141209(v=sql.100).aspx

You can answer your questions by obtaining a copy of

Microsoft SQL Server 2008 Upgrade Advisor

http://www.microsoft.com/en-us/download/details.aspx?id=11455

scottichrosaviakosmos (10/14/2012)

---

i have a table and a column with dates. there are multiple dates for same date . these dates are inserted on basis of a procedure run on working...

Thanks for a good question - good thing I had my coffee before answering

Again thanks

Whoopps clicked too often ...

Nice simple question on the basics. Every one should get this right (I hope)