Thanks Gail, Not the answer I wanted, but the one I expected. Serves him right for developing in a test database

I had to work with an audit log like that and it was a nightmare!

What happens if the text field contains your delimiter value

what happens if the structure of the...

@patrick-2,

It was not my intention to rubbish stack exchange, I use it regularly for non SQL related activities. My point was that a lot of the people...

Well said Jeff,

@joe, it would be lovely to live in your SQL bubble where all RDMS is built and managed by people with 20 years experience, a masters...

different domains, I don't want the hassle of getting changes made to DNS and NATS settings; the company a bit neadethal when it comes to automation. (how come so many...

I thought I just did

Without a physical record of the which orders were assigned from which batches, you have to calculate the allocations right from the beginning of the...

Do you need the data at the granularity of empID. Maybe get a data feed at a higher level of aggregation or generate another reporting table, but that is...

I think that is the first time a DML has made me salivate;

I'm off home now to Select * from Bar

:sick:

If you only have a few (lets say a couple of dozen at most) and the combinations are static (i.e. you know them in advance) you could use a conditional...

Firstly, do you understand the solution you have been given?

Secondly, Nasty nasty had coded values! - what happens if the list of codes changes; can you break them out to...

Looking at the table structure, you are going to need all the columns except amount to create a unique primary key unless you can verify that employee IDs are not...

@sean, @136rony

Sean you are a * for trying to help, Rony, It is hard when english is not your first language.

There is a subtle difference between FIFO and...

Two databases separated by a common language!

If you can write T-SQL then you will be able to use 80% of your knowlege in PL/SQL but there are things (like dates)...

+1 for Spaggeties observation.

The actual value of an identity column should be irrelevant as it should never be presented to the business - it only ensures uniqueness and referential integrity.

The...

Another Solution:

Add a calculated column to the results set: Split the date into the month name and year and convert the monthname to a zero-led 2 digit number and append...