Lee W, MVP
asked on
Partial SQL Data copied from one table to another
I have a table with a ton of fields and I need to pull out a select few and insert the data into another existing table.
Specifically:
Location
-------
field1
field2
field3
Client
ContractAmt
ContractDate
field7
field8
Contracts
--------
ContractType (this is going to be 21 for all records
Client (set to Client from Table1)
ContractStartDate (needs to be set to ContractDate -1 year)
ExpireDate (set to ContractDate from Table1)
ContractAmt (set to ContractAmt from Table1)
Tried this:
INSERT INTO Contracts (ContractType, Client, ContractStartDate, ExpireDate, ContractAmt) VALUES (SELECT 21, Client, DATEADD('yy', -1, ContractDate), ContractDate, ContractAmt FROM Location)
but I get
Msg 1023, Level 15, State 1, Line 2
Invalid parameter 1 specified for dateadd.
Specifically:
Location
-------
field1
field2
field3
Client
ContractAmt
ContractDate
field7
field8
Contracts
--------
ContractType (this is going to be 21 for all records
Client (set to Client from Table1)
ContractStartDate (needs to be set to ContractDate -1 year)
ExpireDate (set to ContractDate from Table1)
ContractAmt (set to ContractAmt from Table1)
Tried this:
INSERT INTO Contracts (ContractType, Client, ContractStartDate, ExpireDate, ContractAmt) VALUES (SELECT 21, Client, DATEADD('yy', -1, ContractDate), ContractDate, ContractAmt FROM Location)
but I get
Msg 1023, Level 15, State 1, Line 2
Invalid parameter 1 specified for dateadd.
ASKER
Nope,
Msg 1023, Level 15, State 1, Line 4
Invalid parameter 1 specified for dateadd.
Msg 1023, Level 15, State 1, Line 4
Invalid parameter 1 specified for dateadd.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I've requested that this question be closed as follows:
Accepted answer: 0 points for pratima_mcs's comment #a39977381
for the following reason:
Thanks, that did the trick!
Accepted answer: 0 points for pratima_mcs's comment #a39977381
for the following reason:
Thanks, that did the trick!
it helps you right? then why 0 points ?
thats fine. I just want to understand whether he needs more help in that.
ASKER
Sorry - that was a screwup on my part - your assistance was greatly appreciated (It was a late project for me so probably didn't have my head on straight...)
INSERT INTO Contracts
(ContractType, Client, ContractStartDate, ExpireDate, ContractAmt)
SELECT 21, Client, DATEADD('yy', -1, ContractDate), ContractDate, ContractAmt FROM Location