Thank you Sean. I thought so. 🙂

Cheers

Vani

Hi all

Not sure if any one is still having this issue but the one change below seemed to resolve the problem for me.

---

*** NOTE - I did not have to...

Hi all

I tried to do this and research about it but got no where.

anyways what i did was use the SQL Query and Excel to achieve what was needed....

Hi there

can you please clarify - if my understanding is correct -

You would like to group BC1, BC2, BC3, BC4, BC5 as one group

if that is the case...

hi all

here is the idea i finally ended up using -

First priorities the grades

1. Completed / Pass

2. All other grades

Original Data

**********

in the database was split...

Hi Jeff

I have always shared my solution and will post this one as well when i have finalised it. 🙂

PS - I found your tally tables very handy...

Hi all

thank you for your help. I think i have it worked out finally. I included a counter column which helped a lot for now

Cheers

vani

Hi all

Is there a way to check for the existence of a row and then delete another row based on the value of the row checked earlier.

e.g. In the...

Hi Mark

thank you for your prompt response. However, the way to delete the rows is based on a combination of empid, courseid and grade.

With the CTE query am unable...

Hi Jeff

I tried both min and max did not work. anyway this worked, so i thought i will share the links.

Cheers

[font="Tahoma"]Hi all

Thank you for your help. I have managed to work it out finally. I realised the major difference in this query is datatype of Data that...

Hi Anthony

Thanks for your help... I am unable to get it working.

-- Create table

create table trainingData

(emp_id varchar(6),

course_id varchar(50),

result varchar(10))

-- Insert data

Insert into trainingData

Values ('1', 'Course1', 'Pass')

Insert into trainingData

Values ('1',...

Hi Gianluca

Thank you for your help. That was great. I got it going.

cheers

vani

Hi

There is one course that needs to be split into two if it was completed

Before a certain date.

Course Id - physical training if completed before 1/10/2010 needs...

Hi Jeff

Thank you for your help :). I got it working.

I created a table with the client details, joined it with the temp table with the dates...