Noel,

Who asked you? KIDDING!

CHEERS!

even better.... I forgot about ROLLUP

--data

declare @t table (Yr int, Branch int, TRec int)

insert @t

select 2004, 1, 1000

union all select...

A little "bug" in SQL 2000 for INSERTED/DELETED tables is that you must join it with the source table, otherwise you only return 1 row or an error depending the...

--I don't know if this fits what you are looking for but I will post anyhow, because I never see anyone use compute

declare @t table (Yr int, Branch int, TRec...

You're using a "Text File (Source)" object?

Double check the file name and properties. It should not make a difference unless there's been more changed other than the the .dbf...

you have to use adodb

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_set-set_4qic.asp

only thing I could think of is if the connection references the server "(local)" and the database doesn't exist on the workstation you are opening the package from.

There are few ways to do this, and if you search the forum, you'll find quite a few responses.

You need to make an executable out of the vb...

That was mentioned above

looks good, but you forgot to group by nbr.

how about a new admin taking over for a careless admin

--OR!!

declare @affected tinyint

SET @affected = 1

SET ROWCOUNT 1

WHILE @affected > 0

BEGIN

DELETE employee

FROMemployee

INNER JOIN

(

SELECT id, name, salary

FROM employee

GROUP BY id, name,salary

HAVING COUNT(1)>1

) dupes

ONdupes.id = employee.id

ANDdupes.name = employee.name

ANDdupes.salary =...

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ua-uz_82n9.asp

MSDN.com is your friend....

--okay this mind teaser made an impression on me.

--I just made an efficiency edit I learned from another thread

SELECT DISTINCT t1.nbr, t1.dt, t2.dt, DATEDIFF(d, t1.dt, t2.dt) + 1...