SELECT New_Life

Question

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Andy Warren SSC Guru Points: 119902 More actions · Answer 1

Nicely done!

Andy

NPeeters SSChampion Points: 12536 More actions · Answer 2

Frank,

Congratulations.

Seems odd to me that you still have some spare time, looking at the number of posts you have

Frank Kalis SSC Guru Points: 111183 More actions · Answer 3

Hi Noel,

quote:
Seems odd to me that you still have some spare time, looking at the number of posts you have

don't be confused!

I DO have spare time, because watching this site I only do while working

Cheers,

Frank

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

David Burrows SSC Guru Points: 65142 More actions · Answer 4

Many Congrats Frank,

Don't forget good procedure

DROP Dirty_Nappy

GO

SELECT Clean_Nappy FROM Nappy_Pile WHERE COUNT(Clean_Nappy) > 0

INSERT Baby INTO Clean_Nappy

GRANT ALL Smiles to Baby

GO

Far away is close at hand in the images of elsewhere.
Anon.

Frank Kalis SSC Guru Points: 111183 More actions · Answer 5

Thanks David and thanks to all who replied yet!

quote:

DROP Dirty_Nappy

GO

SELECT Clean_Nappy FROM Nappy_Pile WHERE COUNT(Clean_Nappy) > 0

INSERT Baby INTO Clean_Nappy

GRANT ALL Smiles to Baby

GO

I would add a

USE MANY_MANY_PATIENCE

GO

on top

Cheers,

Frank

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Clive Strong SSChampion Points: 11222 More actions · Answer 6

Congrats Frank!

Best of luck!

Clive Strong