Seems reasonable to me. I might add that, if I cannot reproduce the problem, I would either go back to the user who originally reported the problem or (if...

Did you really...

Frankly, I am not much of believer in RI in a datawarehouse. I know that many people swear by it, but since there aren't any interactive users with write...

Like this:

Select Top 1 * From (

Select Top 5

Emp_ID,Emp_Name,Emp_Salary

From Employee

Order By Emp_Salary

) Order By Emp_Salary DESC

Please review the link the Michael Earl posted above and supply more information.

Could you tell...

Actually Abhijit's can be fixed pretty easily:

SELECT OBJECT_NAME(object_id), Rows FROM sys.partitions WHERE index_id < 2

Is this homework? If so, can you be explict about what kind of help your school's policy allows us to give you?

You are going to have to provide us with more information. Please post a sample script and CLR code that can demonstrate the problem.

See this link for some guidelines...

Jonathan Kehayias (7/20/2008)

---

rbarryyoung (7/20/2008)

---

The problem is that there is virtually nothing worthwhile that you can do in SQLCLR that isn't either unsafe, unsupported, impossible or just better done in T-SQL...

Well, certificates are what MS is trying to push everyone towards. However, that is even more complicated and confusing, IMHO.

The problem is that there is virtually nothing worthwhile that you can do in SQLCLR that isn't either unsafe, unsupported, impossible or just better done in T-SQL to begin with....

We cannot see the XML. Either post it as an attachment or use the simple-talk prettifier here http://extras.sqlservercentral.com/prettifier/prettifier.aspx

Glad I could help.

Actually, this only works on tables with a clustered index, and not all tables have...