I want to get records fron the db based on the following criteria:
TableA.FieldA, TableB.FieldA FROM TableA
LEFT OUTER JOIN TableB etc.
WHERE (TableB.FieldX =xyz or in case there in no records in TableB so these

We have a student software application that houses its' data in a SQL server
database named DASL.  A second database, DASLrd, was setup that contains
Views to data in the DASL database.  Both databases are on the same server.
When I extract data from a table via an ODBC connect ...

We have plans to change our BI environment. At this moment we have SQL
server 2000 with Impromptu.
First of all we are going to use Reporting Services for producing
reports instead of Impromptu.

What is the best way to log all the activities/connections from the users?
I know that all the information I need is stored in sysprocesses table, but
I am not sure how often should I pool table info not to miss any activities?
Is a good idea to write a trigger and in this way to ...

I’m trying to find orphaned records that resulted when a new table was
created to normalize data but unnecessary records were added in the process.
I have 2 related tables, let's call them tblA and tblB, that I need to
compare.

How can I get only 1 row at a time without using where x=unique condition?
Thanks
Felix

LS, I have created a Analysis services database for for analytical reports.
Everyday information is newly stored in the source database. To keep the
Cubes up to date the Analysis services databases should be processed daily.
I understood that I can use an SQL-server agent for this ...