SELECT IA.ITM_ID AS "Question Number",

CAST(IA.IAT_DATA AS VARCHAR(25)) AS Subject,

SUM(LOII.LII_MARKS) * 1.0 / COUNT(*) AS "Av No of correct answers",

CASE IA.IAT_DATA

    WHEN 'Financial Reporting' THEN 1

    WHEN 'Performance Management'...

Good point... but it will work with 2000, it will work for 2k5.  Then when they need to upgrade to 2k10, they'll just have to move that variable ot the...

Create a job that fires each proc that needs to be ran.  Then fire all the jobs sequentially, DOS will not wait for their execution to continue (he I understand...

Ya they do work, test the solution and if it doesn't work, then post the required result from that sample data and we'll get back to you.

Ya, that's a question that would be best answered by the vendor.

Access is my favourite for speed of developpment.

VB X is my favourite for control of all the data access which I can't have in Access.  Depends on what is the...

Thanx for the info, have a good day too .

So that we don't all have to google it :

AARP?

What do you need exactly... update the table once, then forget about it.  Have a select to return that number permanently.  Then do you have access to a front end...

Thanx for the info.

Somehow the Senior Systems Engineer/Database Administrator just took a whole new life of its own .

CPM??  Are you talking about a typewritter or a computer ???

Max files per DB (from BOL) : 32767

Can you post the exact code he sent you?

Come on you can't be that old???

I was thinking expert in the terms of someone who had either conducted a lot of interviews or had interviewed a lot of times!!

I ran out of space at file 1069...  But I guess this is just enough of what you need to know :

USE Master

GO

CREATE DATABASE MaxLogCnt

GO

DECLARE @i AS INT

DECLARE @sql...