Thank you for the input.

A term or semester is not really important or needed right now, since each grade will be associated also with a curricular unit/discipline and also i...

it's a relationship between units (classes) and a plan study.

a plan study describes the course path through the 1st, 2nd, 3rd year, ...

and, you're right at the end, i...

the model is just a simplicafication, but

on table A you can have things like:

on table B you can have things like:

on table AB you can...

I think the length column even be removed, still don't know exactly why why it helps being there.

If i edit the part WHERE n.length = 1) for WHERE...

why you consider it odd ? i was reading a text on anti - pattern representations, that's from where i took the "idea" of this representation.

does it help this way ?

declare @employee table

(

emp_name varchar(25),

emp_id int,

dept_no int,

emp_sal int

)

insert @employee (emp_name, emp_id, dept_no, emp_sal)

select 'Ranit', 1001, 10, 10000

union

select 'Rahul', 1002, 20, 10500

union

select 'Rajat', 1003, 30, 10000

union

select 'Ravi',...

So, what should i do when i see this kind of advices, should i just ignore it ?

Thank you, this is already defined in the table value functions 🙂

Perfect Mr. Scott.

Indeed, the same day of week has to be the same, mandatory.

PS: When you say "So, adding 6 mos gives a date of '2014-11-05', which becomes '2014-11-11', since...

i was searching for a solution for this new problem and found it ... it was about merging datetime intervals into a bigger one, it seemed simple when i started...

Thank you Sean, i was indeed browsing that section later, but didn't went deep to 2009 )

I got another doubt, i don't know if its best to say it it...

pretty neat function you did Dwain )), plenty of new sql strategy to learn and understand, thank you. By the way, you a small syntax error @ CREATE FUNCTION [dbo].[GenerateCalenda1].

Sean Lange (11/5/2013)

---

a20213 (11/5/2013)

---

in this case, yes, but my goal is to make it calculate for any kind of date and delta future (1 month, 2 month, ... 1 and...

in this case, yes, but my goal is to make it calculate for any kind of date and delta future (1 month, 2 month, ... 1 and 1/2 years).

i want May 6th because its the first tuesday of May, like today is the first tuesday of November, its the most "logical" day, just i have a feeling that...