Actually you can cast to int, but then you have to use something like

select cast(cast(getdate()-.5 as bigint) as datetime)

select getdate()

select dateadd(d,datediff(d,0,getdate()),0)

select cast(cast(getdate()-.5 as bigint) as datetime)

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

2004-02-25...

While being more precise might be appropriate here, most of the times it's a nasty habit, because once you've committed yourself you'll get...

More than one way to skin that cat.

for the sake of simplicity, I would use Antares686 solution. I bet it is also the one with best performance. At least...

We're drifting off-topic.

Last one from me. When we run projections on the whole portfolio of our insured persons we deal with tens of...

Sorry, forgot to add that when I mean I use Excel I didn't mean that I also use Excel's built-in functions, which I agree are very limited. We use a...

I know Excel's limitation pretty well

I didn't mean I download hundreds of thousands of rows. The degree...

Declarative referential integrity

use pubs

go

declare @stmt nvarchar(100)

declare @t_name varchar(10)

set @t_name = 'authors'

set @stmt = 'SELECT * FROM ' + @t_name

exec sp_executesql @stmt

Also read http://www.sommarskog.se/dynamic_sql.html

DOS ????

To steal Kenneth' slogan: 'It depends...'

A lot of people seem to prefer mailing lists rather the webforums.

As for improvements in performance this might be interesting

http://www.sqlservercentral.com/columnists/jtravis/sp_performance.asp

http://www.sqlservercentral.com/columnists/bkelley/procedurecache.asp

As for renaming:

Take a look at BOL for 'renaming stored procedures'. Seems to be more work than looping through...

I hear you!

At home with only a 56k modem it's a real pain, but at work there is no huge delay at all. So I would suspect that no your...

Mark, thanks for given a hint on the 'correct' answer

Maybe it should only be allowed for a member to browse those QOD threads...

Medians, Quartiles, Quintiles, Deciles, Percentiles. Moreover these measures are reported grouped by any number of columns (and I have never seen this capability anywhere else). In this context, the use...

After Frank's diatribe, I'm not sure my input is needed, but here's a couple thoughts.

It's just to help the original poster to collect...