Please Ignore this. I figured it out.

Based on the information provided,

If the roles are fixed then I would design it in the denormalized manner:

MarkKey (SurrogateKey)

StudentKey (Foreign key to Student)

Marks

HODApprovedDate

PrincipalApprovedDate

UniversityApprovedDate

etc

If roles are configurable then 2 tables

StudentMarkKey...

Thank you again and understood.

Does everything that apply to data warehouse also apply to datamart? We are not really IT and not making a datamart for my company. We make...

Thank you Lempster and Andrew. Really appreciate your help.

I'll start with the books you suggested. I was also looking at the book "The Data Warehouse Toolkit: The Definitive Guide to...

Sachin Nandanwar (6/20/2014)

---

The deadlocks now typically involve inserts and deletes from the filter table and CRUD action against a table that has a foreign key to master table. The deadlocks...

stevenb 63624 (10/31/2013)

---

Having the query engine choose a scan instead of a seek isn't going to be affected by how fragmented your index is. An index, by definition, is the...

stevenb 63624 (10/31/2013)

---

The best advice anyone can give about whether the time spent on the index reorg is normal is to take measurements and see what you normally get. The...

I use CA'a ERwin and I love it.

If you have ready database then maybe try to reverse engineer and generate the scripts by using SSMS "Create scripts" functionality.

anupam.jha (8/26/2013)

---

I need to create around 26000 Views whose scripts are ready.

But, some of the views are dependent on other views. Thus, I am not able to create the Views...

ScottPletcher (8/9/2013)

---

You don't need separate indexes on StartDateTime and EndDateTime, you need them in the same index.

SQL will only be able to do a seek on that index if it's...

Thank you everybody for the reply. Sorry for replying late as I got caught up in something else.

@stefan,

I don't really mind increased storage as long as I get...

Sean Lange (8/7/2013)

---

Why not just split the two conditions? No need for a cte here.

SELECT TOP (500) test.[TestId]

FROM tblTest as test

WHERE test.EndDateTime < @Date OR test.StartDateTime < @Date;

The next question...

raghuldrag (8/7/2013)

---

like above my requirement is these procedure correct ah?

alter procedure save_draft

(

@username varchar(20),

@departure datetime,

@request int,

@error Varchar(100)=null output

)

as

begin

declare @userid varchar(20)

select

raghuldrag (8/7/2013)

---

Hai friends ,

i ve the table like

travel_request

create table travel_request

(

request_id int identity,

user_id varchar(20),

travel_purpose varchar(20)

)

insert into travel_request (user_id,travel_purpose) values ('012','Market Visit')

journey

create table journey

(

request_id int references...