Hate to tell you the bad news...

...sorry

...it was to remove all unique rows and the 1st of every duplicated row.

your output needs 2 rows 😉

Sorry. 🙂

the point of the exercise -

...so all that is left is a table full of records which were duplicated at least once!

(and some of these maybe duplicated in the...

I always hate these 'homework' questions 😉

But hats off to Barry - neat trick, though I'd never use it my databases, because I design them from the ground up...

There is a lot of this going on at the moment

usually the injection looks for text/character type fields and where there is enough space

adds in a script which embeds into...

Ted Pin (6/26/2008)

---

This reminds of when I told someone I was a data warehouse developer at Publix (a southern super market chain) and they asked me, "Oh yeah? So which...

Damn you're tellin me grave robbin's required for the medical profession.

*hastily lifts barrow covered in tarp, a leg and arm protrude from it*

Er..just going to town via the cemetery won't...

'IT Guy' similar to 'Family Guy' - yeah lets make an animated sitcom out of it

or how about American DBA, something like American Dad? There's only one letter different. 😀

Bremmy...

.

Ah but then they cannot challenge you and you can up the price! 😀

majorbloodnock (6/26/2008)

---

Um, thanks, Shaun :blush:

I'll admit I try to keep my posts as lighthearted as possible, but I never really thought of them as funny as such. Pleased to have...

Todd: dude that cracks me up 😀

I once did confuse "IT girl" with "it girl", damn I was naive, when I was younger, but thats a whole other story NSFW....

By SQL do you mean SQL Server?

Question 1 is dependant on where you ask -

Here it would be - for SQL Server - VBScript, Javascript or .Net (Microsoft slant)

Other...

Just a quick question -

Are you persisting data between pages in your site?

If yes how are you doing this?

--Shaun

steve smith (5/28/2008)

---

And, here I am, misinterpreting the question. I read it as using EITHER would satisfy the condition of not using BOTH!

There's always an orthogonal way to read...

Nope - you posted 😀 oh no so did I!...

I knew I'd seen this before as a real world fail, now I know where cheers for the reminder 😀