Think you forgot to attach the...

TSQL Tryer (2/25/2016)

---

To create the table -

/****** Object: Table [dbo].[test] Script Date: 25/02/2016 16:01:36 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[test](

[CalendarPeriodId] [int] NOT NULL,

[CalendarId] [int]...

Vallu (2/25/2016)

---

Sorry again but I'm able find "Integration services" and "BI" as categories and both were contains queries on SSIS. I was just trying to get a response to my...

This would be a lot better if your sample data was readily consumable (insert statement). Also, the actual execution plan as a file instead of a screen shot would be...

Please don't cross post. http://www.sqlservercentral.com/Forums/Topic1764179-147-1.aspx

Please don't cross post. http://www.sqlservercentral.com/Forums/Topic1764179-147-1.aspx

I don't change either of those typically. Of...

hlsc1983 (2/24/2016)

---

k... i will design the database as per the suggestions here and get back soon for more feedback. do i have to start a new thread or stick to...

hlsc1983 (2/24/2016)

---

i meant to write like this: exam_year int,

The reason why i am using exam_year is because the marksheet that the system must finally print reads something like this:...

Sort of....

hlsc1983 (2/24/2016)

---

k if i insert a gradetypeID column in the table, that means there will be four rows in the table if the subject has all four possible grade types....

hlsc1983 (2/24/2016)

---

i am not a student . i work in the examination cell and i have been trying to develop an application that will replace the current system.

regarding...

hlsc1983 (2/24/2016)

---

Odd means odd semester- I,III, and V semesters

Even means even semester- II, IV and VI semesters.

Regular papers means student appears it for the first time.

Compartmental means the student has...

jakebeliveau (2/24/2016)

---

tindog (2/24/2016)

---

Are you after something like this:

SELECT NT_ID,

100 * Frequency / (SUM(Frequency) OVER ()) PercentageOfTotal

FROM ........

ETA:...

hlsc1983 (2/24/2016)

---

so like this?

Master_marks table with the following columns:

student_id int,

subject_id int,

marks int,

odd_even bit,

reg_comp bit,

exam_year int, '( year is associated with the year of examination and not student)'

gradeID int,

and...