Database

djj55 wrote:

I have around 300 stored procedures that I would like to know what if any tables are used.

I are Troll

declare @t table(dt date, tm int)
insert into @t 
	select '2010-01-05',15 union all 
	select '2010-01-05',16 union all 
	select '2010-01-05',18 union all 
	select '2010-01-05',36 union all 
	select '2010-01-05',59 union all 
	select '2010-01-06',01 union all 
	select '2010-01-06',20 union all 
	select '2010-01-07',30 union all 
	select '2009-12-21',34 union all 
	select '2009-12-22',12

select dt,CntMins  = COUNT(tm),TotalMins = SUM(tm) from @t
group by dt
--order by SUM(tm) desc --[Incase you want to see the result in Descending Order]

dt	CntMins	TotalMins
2009-12-21	1	34
2009-12-22	1	12
2010-01-05	5	144
2010-01-06	2	21
2010-01-07	1	30

GROUP BY CONVERT(DATETIME,Modified,103)

SELECT COUNT(*)
FROM EquityCounter
GROUP BY CONVERT(DATE,Modified)

GROUP BY CONVERT(DATETIME,LEFT(CONVERT(VARCHAR(50),Modified),11))

Mycroft Holmes wrote:

Still gotta be better than a temp table!

John Simmons / outlaw programmer wrote:

regardless of how big your timeout value was?

I are Troll

John Simmons / outlaw programmer wrote:

How bad would a stored proc have to be