I'll go with Antares686 suggestion,

thus version II

Select Calc.StudentNr,Calc.ColSum/Calc.FieldCnt From (

Select StudentNr,

(ISNULL((CASE When ST1Q1 = 'N' Then Null ELSE ST1Q1 End),0) +

ISNULL((CASE When ST1Q2 = 'N' Then Null ELSE ST1Q2...

Quite interesting question, suppose one can define a function passing in which record's blob size one want to know.

Sorry should have noticed, but thanks!

Maybe if you implement jraha's example and check that it work as expect in the trigger and then substitute your real code.

Do you have another reference to the article

Could not find the thread on this website, but there was a thread discussiong the merits of cursors versus set based solutions.

If time/resources allow maybe worth while looking at the...

Try

Where Case When @Mode = 'FD_DAILYREGISTER'

Then Case When appt.type = 'A' and appt.practiceid =...

Spongemagnet, the term code injection spring to mind plus add the code from MarkusB!

The shorthand is kind of difficult to read!

jpipes maybe onto something. Can do asynch pre fetch for the next and prev 10 records.

When user click next, check if you have the next buffer. If Yes display and...

Have a look at

http://dbforums.com/arch/71/2002/11/537513

If engineer A is only interested in the results of step II and engineer B is interested in the end results after N steps more on the results of II....

Sounds like your app will have to do some encryption before writing the data to the database to prevent anyone to fiddle.

Don't know about the maths, but agree fully with the "try to enforce strict requirements so developers cannot alter anything in production. ". Reason, that last minute fix/enhancement but give...

BOL = SQL Server Books Online