Hi and welcome to the forums. In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form...

Not sure what you mean here. But if this is a value that...

I don't understand the logic here. Can you try to explain what you are trying to do?

The new post can be found here. http://www.sqlservercentral.com/Forums/Topic1763852-169-1.aspx

richieperkins (2/24/2016)

---

Dear Forum Members

I am new to SQL done the first administrator course but as a platform support engineer and not a DBA I do find some of the more...

hlsc1983 (2/24/2016)

---

k this is what i have been doing so far to record marks of students. i have a marks_master table like this:

marks_id int,

subject_id ...

Sergiy (2/23/2016)

---

The answer is plainly wrong.

Did anyone of you guys who think "3" is a correct answer actually run the script in a batch?

The question repeats the word "batch" so...

ZZartin (2/23/2016)

---

hlsc1983 (2/23/2016)

---

K now i am getting it. Thank u . But one doubt.

please elaborate how the trigger is to be used and what it's supposed to look...

Eric M Russell (2/23/2016)

---

Regardless of how or where the T-SQL is stored at rest, it must be decrypted before SQL Server can compile and execute it. Any user with SYSADMIN...

Alan.B (2/23/2016)

---

I don't know if anyone is aware of this but I noticed Dwain Camps hadn't posted anything in awhile so I checked his blog (dwaincsql.com), simple-talk, twitter, linkedin... then...

hlsc1983 (2/23/2016)

---

yes, all subjects do not have the same pass and full marks for theory and practical grades.

For example, Java subject has 100 and 40 as full marks and pass...

hlsc1983 (2/23/2016)

---

k what will be the records for the grades table? like this?

ID Name

1 THET

2 THPA

3 PRET

4 PRPA

and what about the...

hlsc1983 (2/23/2016)

---

THET: theory end term grade

THPA: theory progressive assessment grade

PRET: practical end term grade

PRPA: practical progressive assessment grade

here is a sample of a record in the table:

java ...

It would if you were using a case sensitive collation. But...

Luis Cazares (2/23/2016)

---

Sean Lange (2/23/2016)

---

Ed Wagner (2/23/2016)

---

That...