Hi,

Interesting topic 🙂

Does anyone else think it's slightly obtuse to spend time creating naming standards for tables and then alias them in code with something so meaning less as a...

Hi,

I used to be an analytical chemist so I have some experience in this area. All software we used for analyzing pharmaceuticals had to pass stringent validation testing before being...

Hi,

How would this have worked when paying tax on those earnings. Do all US citizens in employment have to submit a tax return or can a company do that on...

Hi,

The natural world gives us a heads-up to the reality of specialization.

Animals and plants that are highly specialized i.e. optimized to take advantage of a narrow environmental niche, appear to...

Jeremy,

You are correct, if that is the case then the solution i provided would not work. Saying that as far as i can see from the data provided and the...

Hi,

You might give this a try.

I had the idea that if you created a table with an incremental rowid and a clustered index on the machine and date you could...

LOL, point me in the direction of a shovel!

I'm actually really excited about this, it's the first time i've written a fully transactional db in SQL Server. You're correct in...

Hi,

Thanks very much for the replies.

Steve, there's defintely going to be a great deal of testing done on this particularly to make sure we've got sufficient bandwidth.

I do like...

Hi,

It's not a major thing but you've misspelled InstructorSurname in the instructor table. It's one of those things that will ensure much scratching of heads when you do spell it...

Hi,

Point them in the direction of the companies fraud investigation policy that clearly states all requests must be in submitted via e-mail with a counter signed hardcopy by whomever the...

Hi,

This may sound a bit mad but does anyone know if you could use a parabolic mirror to generate electricty?

I watched an experiment once which was designed to show how...

Hi,

My favourite happened when working as an Information Analyst in a small dept. We had 2 rows of desks with 3 people on each side facing each other. My neighbour...

Hi,

Sorry for the lateness of reply.

Matt: I tried the where clause. Interestingly - to me at least - if you try this in a view it will automatically re-write it...

The arrival of old age; it's turned up a damn sight quicker 😛

K.

Hi,

Yes i did spot that however this is for loading data into a reporting system and is done after close of business so ultimate speed is not essential. More importantly...