Thanks, sorry for the simple question... now I see the answer...

With this select statement using EXEC how would I get the result back into another variable ??

Thanks for the help...

The field name is 'Jan' that I want a sum for... it is a float field but called Jan

Try to take the space away between the database name and the open brackets ( ... This was one problem I had...

INSERT INTO tblhbest1(UnternehmenID, Handelsobjekt) SELECT UnternehmenID, Handelsobjekt FROM view1

I did it... Thanks Frank for the help... here it is ... the column names were the key...

ALTER PROCEDURE dbo.CreateRTMdb AS

TRUNCATE TABLE kc_RTMb

INSERT INTO kc_RTMb(Period, MKT, SEC, CT,...

by using AS in the select statement, are you not specifing the columns then ??

Thanks for all your help Frank

John

Sorry also this is for frequent use, I plan to have it in a stored procedure...

Already tried that but I get "Insert Error: Column name or number of supplied values does not match table definition." as I am using Sum's ... how do I get...

I have included the source and the dest ... I need to take the first fields and then the MillCompany & Code add a new record with the rest of...