Thoughts and prayers for smooth operations and a speedy recovery.

BTW, Part 2 is very good. Dare I say, even excellent.

george sibbald (4/26/2009)

---

I want to return a list of all user databases in an instance with their datafile size and latest backup size. I want one row for each database...

Lynn,

Does this[/url] look anything like your desert?

Bob Hovious (4/26/2009)

---

Wayne:

You need to admit that you need help.

I'd like...

Bob Hovious (2/19/2009)

---

Personally though, I would rather have a smart, motivated person with very little knowledge but the ability and eagerness to learn, than a moderately knowledgeable person with no...

Bad code stories? Okay, how's this.

Company hired a VB developer to rewrite an application from Delphi to VB, but gave him rein over SQL. The rewrite was supposed to be...

Ok, I didn't see that before.

GSquared (4/24/2009)

---

Before you start stuffing the string, make sure that times before 10 AM are stored with leading zeroes. If not, you might have a problem when 9:00 AM...

or a DLL trigger?

Here's a one-command approach for the first one I did. It's uglier, but you don't have to call any procedures / functions.

select convert(char(8),

convert(datetime,

convert(datetime, stuff(stuff('154040',3,0,':'),6,0,':')) -

...

First, fire your developer and store the time in a datetime field.

In the meantime, use this code:

declare @Start char(6), @End char(6)

set @Start = '133737'

set @End = '154040'

declare @StartTime datetime, @EndTime...

I think the solution you already have is good, though I would change the current select to be select TOP 3 instead of using SET ROWCOUNT. (In the next version...

You can use the OpenRowset...

select SUM(IsNull(s.Sales,0)) Sales,

s.[Type],

p.Period

from #Period p

LEFT OUTER JOIN #Sales...

I just tried it... you can't combine them.