What do you mean by 'no order'?

If you want your data back in a specific order, you must specify an order by clause. Otherwise it comes back however the...

Or maybe what I've seen on a lot of other forums. The text bix to enter the new post is at the top of the page and all the other...

Try this way indstead. Aside from the divide by zero, it's better for index selection (if you have appropriate indexes)

Select *

from table t

where t.value_a > 10*t.value_b

AND t.value_c...

Or you can use sys.dm_exec_requests and pass the SQL handle to the sys.dm_exec_sql_text function and get the entire sql statement. (DBCC Inputbuffer only displays the first 255 characters)

select * from...

That's not ideal either because, at optimisation, the query optimiser can't evaluate the first half of the or. SQL doesn't have short circuit evaluation

The only way I've managed to deal...

Don't know about the global parameters, I don't think we use them. Our DTS packages are mainly complex data flows.

What we decided to do was to ensure that the people who...

Not sure if this is addressed to me or not, but I'll answer.

No, we're not using SSIS to exec the DTS packages. We imported the DTS packages as legacy objects...

Unable to execute DTS jobs migrated to Version 2005...Arg!!!!!!  The learning curve for SSIS is VERY steep...I have to re-write every DTS package in 2005 before I can migrate

What problems...

Try this. It's not tested, but should work. It depends on the dummy course been the only one that all students take.

SELECT

*

There's nothing else? Foreign key? Flag anywhere?

It's doable, but it's not going to be a nice query. Let me see what I can come up with....

Remove the distinct from the in. x in (1,2,2,2,2,5) and x in (1,2,5) are equivalent.

Make sure you have an index on SKey and FTSKey.

Also, try the query as a left...

What distinguishes a dummy course from a real one?

I can give you a query that will find students with a single course, but if they have multiple, there will have...

I read about this on a blog some months back. Can't remember which one. I'm pretty sure it was one of the SQL dev teams.

SQL Server 2005 is under no...

There's no need to create a DTS package just to run a stored proc. A SQL Agent5 job is more than sufficient.

No need to add additional complexity.

What's your question?