Ryan

What is the usage scale for the website? Number of concurrent users, etc.

How mission critical is it?

--Shaun

I'm confused how are these opposed;-

"...not to solve technical issues, but to add value to the business."

In my job I solve technical issues that add value to the business. 😉

(thats...

We are assuming the OP is saying;-

when a simultaneous insert occurs from two client appliactions

the id of the two inserted records in a/the table are identical.

This indicates no...

As I posted earlier - I did a 2.5 hour stint from home via VPN to my work PC - easiest thing in the world. Oh - ho comming upto...

timmy_patterson (8/5/2008)

---

I'm having trouble understanding Step 4. Where do tables 'TAB' and 'Tally' come from?

Thanks,

Tim

Insert into SOURCE(Name, Age, Sex)

Select Name

, Age

, CHAR(ASCII(Sex) & 1) --extract and preserve the [Sex]...

You used a temp table - forbidden by the article requirements.

Sorry,

Just havin a bad mood moment, please don't take it personally, I get worked up on long running threads....;)

try as hard as you can;-

and still the dupe removers and requirments non-readers supply solutions to the problem already

answered/solved and burried by rbarryyoung, chris.morriss and Phil Factor.

All legends.

*Shaun drinks...

Thanks Phil

love the eBook and the SimpleTalk articles, always a good read.:)

The one about the ex-riot policemane turned DBA should have been quoted on the Stored Procs vs ORM thread....

Been waiting for it....:D

Phil could you give a more verbose explanation of your code please?

I want to be a DBA....and not the trouble shooter....I run out of bullets too fast 😀

did 2.5 hours from home this morning 😀

vital job had to go live before the general populace started work today!

The had the usual half hour sleep on the bus on...

my bad 😉

I read sharon's post as Kev's 😀

--Shaun (damn I need to pay attention)

jcrawf02 (8/4/2008)

---

He has to be laid-back, it's the dialysis...

I drive 2 miles to the bus station, then sleep for 30 mins to work through the traffic on the bus 😀

20 miles a week extra 5 hours sleep bonus...

Guys think deeper, that question is not "what is 2^31" but "why does this fail"

Its about data type limitations. The correct answer is not given in the error message

the...