We used to have a old e-learning system that does this. This is on a unix with a propriety DB. We moved to a new SQLSERVER 2005 based system. ...

me either!.

I have to make interesting calculations!:

1. STDEV per question.

2. Get top/bottom 25%: with a a catch:

did overall top 25%...

I checked the books online! it calculates on numeric fields only!.

How to apply to string expressions!

That works!.

I am debating on overheads this query will put on: Our production is hosted and cannot run the query analyzer here.

My SQL is:

select col1, col2 ..... colNtextThatIsXML

From table1

Inner Join table 2 ...

Inner Join table 3 ...

Inner Join table 4 ...

From the colNtextThatIsXML, I just need one element ???

I did the...

I cannot have a separate table for this as I am using this piece of info as part of several table joins.

Did not know that XML code vanished!.

Attached sample data.

That is a good suggestion. I converted the inner select/processing to a function and am calling this function in my select statement: no cursor required

The inner processing is a select with conditions.

Is this possible..

You are welcome. 🙂

What is the error?

This is in production for over an year. I've put this up here after several months of being "in production".

Is it possible to revoke all permissions at db level and grant only application level access. The application in turn has to change to accordingly this ?? I would...

The application administrator just realized that there are users who access the DB by linking tables and have modified data. The administrator does not realize that we might not be...

The vendor apps has a client piece that installs a DSN on each client. This DSN uses windows authentication. I explained that this like giving a copy of the...

It has the roles of:

dbDataReader and dbDataWriter