select RBR,XLOC,CRE

FROM

(

select RBR,Attribute,Value from Test

) tbl

pivot(min(value) for Attribute in (XLOC,CRE)) as pvt

UNION

select RBR,XLOC,CRE

FROM

(

select RBR,Attribute,Value from Test

) tbl

pivot(max(value) for Attribute in (XLOC,CRE)) as pvt

Should be like this:

SELECT StudentSubiect.StudentID

AVG (Grade)

FROM StudentSubiect

INNER JOIN Student

on

StudentSubiect.StudentID=Student.StudentID

GROUP BY StudentSubiect.StudentID

I guess you are confused with Group...

Thanks all for your replies

I have written a small article explaining this and leaving to the developer on the decision of their type of data and transaction pattern as Gail...

Thanks Gail, I just created a DDL trigger on Create_table/alter_table

Fair enough,

I will come up with some scripts for pinpointing the issue

It says that there is a...

Thanks Hugo for explaining that

When looking at low-level implementation details, yes.

Functionally, no. There are lots of functional differences between unique and nonunique indexes. So you will want to continue defining indexes are unique when...

Is there a way to know if the update of a CTE, which is based on multiple tables, will not only be successful but the results will also be as...

Yes that makes sense.

Thank you

I will correct my post

True, but it will be useful if you have simple recovery model for your db.

and put...

Thanks Gail, for correcting me. I just tested that.

So what I see that for non-unique nonclustered index, clustered index keys becomes the part of nonclustered index keys.

However for unique non-clustered...

Hi All,

I took some time to write a detail article on this, which might be useful for all for our reference

https://sqlmayank.wordpress.com/

Yes, May be Gail can answer this

Yes that was a silly question.

I was in confusion with NonClustered Indexes rebuild when clustered indexes are rebuild