To rename the table :

exec sp_rename 'CurrentName', 'NewName', 'OBJECT'

No I missed that one Jeff. Thanx for the correction.

Hmm this can be a problem

.ActiveConnection = strDBConnectionString

You could try setting ActiveConnection to an adodb.connection object and close that object before accessing the params to see if it works.

As for...

Did you try closing the connection before trying to access the parameters? I vaguely remember that you hav to CLOSE something (either the cn or rs but I'm pretty...

Try something like this.

Select dtDates.*, dtDates.Monday + dtDates.Tuesday + ... + dtDates.Sunday) as Total from

(SELECT

E.PAYTYPE

, SUM(CASE datepart(dw,E.TimeDate) WHEN 2 THEN E.Hours ELSE 0 END) as Monday

, SUM(CASE datepart(dw,E.TimeDate) WHEN...

Forget about one year... how about now for any other programmer and one week for you?? This is way too complicated for no reason.

BTW I think the sp's text...

Yes they both work both my version will not cause the sp to recompile. This can be a great time saver if the proc is not performing well... ...

You can do something like this :

TRUNCATE TABLE TableB

Insert into TableB (Col1, Col2, Col3...) (Select Col1, Col2, Col3 from TableA)

This should do it :

select @person_id = person_id from personaldetails where email = @usn

Do you want to update UPR00200 or UPR00100 cause this

BEGIN

update UPR00100

will update table one instead of 2.

Try this :

If Update(?)....

begin

Update UPR set UPR.Update_Ind = 1 from Inserted Ins inner join dbo.UPR00100 UPR on Ins.EmployID = UPR.EmployID and Ins.ADRSCODE = UPR.ADRSCODE

WHERE (Ins.Adress1 UPR.Adress1 or Ins.Address2...

try this :

NoteCount/OrderCount * 1.0

Sorry I spoke too soon... what I meant to say is that I would make another table with the choices (maybe with a priority column) to allow for unlimited numbers...

The only fast way to do this is to use the query builder of enterprise manager. If you have more than 1 table, it will automatically put the tablename...

You just can't... you must use the subquery as the variable.

If you need to use that variable more than once, may I suggest you create a derived table and join...