Hi, i am writing some queries for a payroll section of a database. An
employee has a field in their table which states their
StandardWorkingHours, typically 8 hours per day.
I also have a second table called HoursWorked, and consists of the

I have a table
username   Roles
Seema        Admin
Seema        AppAdmin

The following gives me the error u.username is invalid in seklect list
because it is not contained in either an aggregate function or the group by
clause
SELECT  u.Username, u.Email, ar.RoleName, uc.LastActivityDtm,

Hi, i have two queries with the following data:
Hours worked query:
EmployeeID_FK
HoursWorked

I require a query from a login audit table that will select the latest
entry only for each user. The data I want to see consists of three
fields:
1. username

I was just reading the following from MS regarding performance:
http://www.microsoft.com/technet/prodtechnol/sql/2005/physdbstor.mspx
In this link MS recommends the following:
"The number of data files within a single filegroup should equal to the

I want to rebuild index on all the tables on my database with the exception
of 7 tables. how can I do that?
Thanks

I posted some trigger code yesterday that somebody was kind enough to
fix, but further testing has thrown up another problem with the code.
What I want to do is add a subnet into Table B for every IP that gets
inserted into Table A, if that subnet does not already exist. If I add

I have 2 tables: one with real time data, and another is lookup
Table Data
col1 date
col2 amount

My application is to get some data from SQL/OLAP server.
When I try to open OleDbConnection using connection string:
"Provider=MSOLAP;Data Source=servername;Initial Catalog=dbname;"
I get message:

I would like to know on the xml column if there is a schema associated.
What query must i use ?
Franck

We have a client/server application that has been running fine at 30+
customer sites, except for 1 location.
The client application is written in Visual Basic 6 and the database server
is SQL Server 2000 Standard 32 bit.

Using SQL Server 2000.  I have a trigger (update,insert) that copies
the current record to a change log table.  I want to delete the
trigger, but when I try to do that, Enterprise Manager hangs up and I
have to end the process.  Do I have to take the database offline

I've got two DTSX packages in one project.
When I make one the one showing in the main screen, then hit the run
button, it runs the other one.  Every time.
How do I make it run the one I want?

Is there any clever techniques to get data to sort appropriately by ignoring
words like "The", "A", and "An" in titles.
I.e. the data might be:
Serpico