Have you tried setting up a connection to that DSN using either SSIS, or directly in the query using OpenRowset?

I must be missing something. SQL functions can't execute stored procedures. Are you talking about some other kind of function?

The only thing I can suggest is using VBA Office Automation to create a Word object, open the document in RAM, and read it programatically. I know that can...

Personally, I'd create a separate login, make sure it is part of the domain groups that you want to test against, and not part of any other domain groups, add...

Is the attempted login originating from the server, or from a remote computer?

Since I don't yet have a copy of Excel 2007, I'm kind of guessing here, but it looks to me like it might be a question of being unable to...

Indexes on smaller tables often won't defragment, because fragmentation doesn't matter in them. I don't remember the threshhold, but I think it's something like 10k rows before index fragmentation...

Considering my own background, I'm gonna have to go with "new DBAs who don't know even simple basics are frighteningly common". Not long ago, I was one of those....

Temp tables are faster in some cases, views are faster in others. It depends on a lot of factors.

Give us a sample of each, and some of the tables...

Try something like this:

;with CTE (Row, Ord_Type, Ord_No, Item_No, Line_Seq_No, CD_TP) as

(select row_number() over

(partition by ord_type, ord_no, item_no, line_seq_no

order by cd_tp),

ord_type, ord_no, item_no, line_seq_no, cd_tp

from OrderRebate)

delete from CTE

where cd_tp =...

You don't have to use Distinct in the select after Except. Just adds more processing, doesn't actually change the results.

Since you're adding the value to a table when you double-click it, you could have the query for the list box have a "where not in" and select values from...

I'm not sure what you're asking/telling us. I see the sample code and what it does, but are you expecting something from us on this?

Without actual table structure, I can't provide a full solution, but it seems to me you could pivot the columns per student-test into rows (1 row per question, per student,...

Just make sure that the original query will return rows from the test data, and that it gives you the kind of results you want to see.