Ever had a beginners course in statistics? Results should be too volatile...

Since I started my statistics, my avg. postcount daily is about ~8, since I record yours, yours is ~6,32. Guess when both counts will intersect

Copy Chris' script into Query Analyzer, replace dbid and objectid with valid values, add a

SELECT * FROM #ind

DROP TABLE #ind

There you go.

Your posting made me aware of DBCC IND. Found it now in Inside SQL Server. Very, very useful at times

DBCC IND is undocumented.

Btw, would this help?

SELECT     

 CAST(OBJECT_NAME(sysind.id) AS CHAR(20)) AS TableName

 , CAST(sysind.name AS CHAR(30)) AS IdxName

 , FILENAME

 , CAST(sysfg.groupname AS CHAR(10)) AS GroupName

FROM...

You can also set up a trace to monitor this.

See if this helps http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlmag01/html/TrackingDownEventClues.asp

Just to add.

Even if you don't supply a numeric value like 0, an empty string will also cause the 19000101 date in a date column:

select cast('' as datetime)

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

1900-01-01...

To me it looks like you're complicating things here

What's the purpose of this whole exercise? What should this calculation mean?

Do you really want to bet on this?

Thanks, I've never been away.

Just reducing activity to work, learn and read.

FWIW, another one:

select

 convert(char(8),dateadd(ss,datediff(mi,'2005-05-16 15:02:33.347', '2005-05-17 09:23:30.813') ,0),108)

I'm not sure if I understand you correctly, but CASTing to DECIMAL works for me

declare @a float

set @a =8.5164835164835168E-2

select

 @a

 , round(cast(@a as decimal(5,3)),3)

 , cast(round(@a,3) as decimal(5,3))

----------------------------------------------------- ------- -------...

Are you sure your front-end doesn't enter a 0 into the column?

FWIW, here's an interesting article by SQL Server MVP Itzik Ben-Gan on this topic

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlmag02/html/groupingtimeintervals.asp

• BOL
• Inside SQL Server 2000 by Kalen Delaney
• The Guru's Guide to SQL Server Internals by Ken Henderson