Jeff: Gis a Job then mate!:)

ROFL! I would shoot these people before they could damage the ecconomy! I might not be able to spell but maths like that I was...

Yeah Jeff - I'm just so cynical these days.

Though to be fair in an interview I would not expect anyone to know the exact syntax required to address the question...

Just had to laugh at this question 😉

I applaud your answers though, some of the questions in the forum seem just too 'homeworky' in nature.

--Shaun McGuile

Date data 101;

Date data should always be stored as datetime type in the database (YYYYMMDDHHmmss) and then converted to the correct format at the user interface/reporting function for user interaction/display...

Good idea Gail, I'm not gonna get in the way of battling giants!:D

What will be the prize?

and

What will the loser have to do in forfeiture?

and

Will everyone win as the knowledge will be most useful?

Regards

Shaun

As neither is 'wrong', they both work then its a matter of personal choice/practice.

Just be consistent and be prepared to do translation when porting your SQL to other databases if...

Jeff you rascal 😀

!= is th inequality in C# get used to it as CLR programming takes off!:hehe:

I can see this developing into a change the software to suit they way you work vs change how you work to suit the software debate, it is this that...

Although I agree wholeheartedly with you James I do not see many typical corporate types agreeing to publish 'their business advantage' back to the community/competition.

Open source does not agree...

I worked for 7 years for a company where business support applications were custom built in-house.

Employing 1 then 2 full time software developers.

We had a sister company which bought in...

Jeff,

thanks for the clarity.

--

Shaun

Just a thought;

Is it that each insert is implicitly wrapped in a transaction thus multiple requests will be qued and not simultaneous?

Thus does -

INSERT INTO mytable ([id]) SELECT ((SELECT TOP 1...

Michael M: your latter suggestion is a possibilty.

Wrapping it up in a single transaction i.e. get the value update it and then use it via an insert trigger would surely...