Is sa a domain/local account (on a windows machine)??

He didn't tell if he wanted to load the table from scratch or on a needed basis for further input... we'll have to wait and see

I think something like this will do :

Select T.id, ISNULL(dta.TA, 0) as TA, ISNULL(dtb.TB, 0) as TB from table1 T left outer join

(Select ida, count(*) as TA from table1A...

Please do no cross-post, we monitor all boards.

Finish the thread here :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=213562

Hehe, you should post the story here... that's gonna make someone laugh .

Tech Tales

Insert into dbo.Table4 (OfficeID, DeptID, SectionID)

values (2234,654,23426)

(actually use parameters passed to a proc to do the insert).

What else could I say?! : "get help somewhere else because I ain't giving to you no more". Programming is just not something you can learn all by yourself...

You should ALWAYS (99.9999%) use SP.

Here's an exemple :

CREATE PROCEDURE [dbo].[AjouterDB] @DbName as varchar(50), @CNStr as varchar(300), @FkServer as int

AS

SET NOCOUNT ON

insert into dbo.Databases (DbName, CnStr, FkServer) values (@DbName,...

I had spent over 4 hours with her (not to mention did 99.9% of the work) just to realize that everything had to go down the drain and start over....

Because there's always one CURRENT production ('08/24/2005 13:47', Prunes) in this case. The self inner join would always miss the current production setting as there's nothing > than itself...

Just for further referrences, what wasn't clear about that question?

Is he at least in the ddl_admin group?

Aren't you using a stored proc to insert the new data?

In the services console, you can change the run as setting to a new account... or making sure you have the right password there too??

That information is kept in the Scope_Identity() function.

You can send back the information with an output parameter (preffered) or the return >>

Select @NewId = SCOPE_IDENTITY()

Not suffering here... was a fun morning because of that so called setup .