it's actually pretty easy; you were almost there

SELECT u.username, SUM(h.hour)

FROM users u

JOIN hours h ON (u.username = h.username)

WHERE (h.entrydate BETWEEN getdate() -30 AND getdate()) OR h.entrydate is...

need some more information... can you post the actual data structure of the table?

do you want to keep the last 200 records per identifier, or just the last 200...

i'm venturing a guess here, but i've had trouble with issues where  the table being called contains oracle blob fields.

the oracle 8/9 drivers, as well as the microsoft MSDBORA drivers will...

an update statement, without a WHERE statement, would affect every row for the field affected;

ie:

UPDATE YOURTABLE  SET MYCOLUMN='20202'

UPDATE YOURTABLE  SET MYCOLUMN='20202' WHERE STATE='NY'

typically, you never want to do this(update without...

you should not have to do a reboot, I believe simply stopping and starting the SQL service is all that is required. when the service starts, all the @@variables and...

this might help: each of the characters can be used in a replace or something; SELECT char(169) returns ©

for example.

Remi isn't it true that if one of the columns is aliased, like SELECT CUSTNO as CustomerNumber, an insert into a view will fail?

just create a c# project and paste the code; no need to ask the question here.

if it's not obvious, it's going to sort the array and print them line by...

here's a function that you can use in VB6, with minor adaptions.

with 250 GIG database, you'll need to make sure your savepath has enough space.

I'm assuming you have the filename...

you'll notice that this is really a way to store multiple values in a single data field....it kind of goes against the grain of a relational database...one field=one value and...

while I had the macro going for changing the data to a sql, here's the way to interpret STATUS2:

SELECT name as DBNAME,STATUS2,

CASE WHEN (STATUS2 &     16384)...

expanding on what David Web Posted, There's a SQL at the to help interpret what is on/off.

typical results:

assuming you know it is ok to kicke them out without ill effects, kill their connections with this procedure: put it in master;

usage is simply sp_kill dbname

typical results:

checksum() is just a function that returns a value...i like to think of it as being like MIN or MAX functions;

you said there is nothing that makes the data unique...so...

maybe it's just a typo, or the FK automatically assumes the PK of the referenced table but I thought itshould it be this:

CREATE TABLE dbo.Departments (

DeptID INT IDENTITY NOT NULL PRIMARY...