I think a cool feature of sql server 2005 and above that you don't always hear a lot about is the recursive query with the CTE. We use this...

I have a unique situation in my job. I have the DBA responsibilities for my company's sql servers. The dev and test servers along with the sql servers...

I am a developer. I code in .net, but I also develop in sql server as well. If you ask my opinion, the developers out there that don't...

Glad you worked through it and figued it out.

Ben

Hey Steve,

I thought I would send you a link to my brother's old band. They aren't together anymore, but you can listen and download their music at:

http://www.myspace.com/theespiviesofficialpage

I...

Hugo,

It is the precision of the variable you are putting the value into that matter. @min-2 is a numeric(10,4), so you will get your four decimal places...

Why wouldn't you just divide by 60.0?

As soon as you add the .0 is becomes numeric.

Ben

Thanks, I am glad you put forth the effort and were rewarded for it.

Ben

You are welcome.

Thanks for not complaining about the formatting.

If I do another Question of the day I will have to watch my formatting.

Ben

Trey,

Fair enough. I guess I have seen a lot harder questions of the day and I guess the formatting didn't seem that hard to fix to me. I...

Trey,

The purpose of this question of the day was to show that sometimes when looking at complicated code, the bug or problem can be something simple. If you never...

Webrunner,

select @startDt = getdate()

select @startDt =

dateadd(millisecond,0-datepart(millisecond,@startDt),

dateadd(second,0-datepart(second,@startDt),

dateadd(minute, 30-datepart(minute,@startDt),

dateadd(hour,10-datepart(hour,@startDt),

@startDt))))

So the idea is that you can start with any date time and set it to a specific time.

If you want the time...

Hugo,

To do what you suggest would cause this Question to be too easy. Perhaps you are fortunate enough to NOT have inherited some poor code from previous employees. ...

Sorry for the misdirection. I thought it was what made this question fun. I found a problem just like this in some code I inherited from some previous...

I understand the EULA protects us from having to fix it for free. My point is for several of our clients the fence (encryption) keeps us from having to...