Nested insert SQL query

Question

I am using MS sql as a database. I want to write an nested query for that. My query is:

INSERT INTO [Node-churn](total_amount_in)  values=
       (SELECT sum(cast(amount as float)) 
        FROM [CDR-IN] 
        WHERE [Node-churn].subscriber=[CDR-IN].callee) 
WHERE degree <6

I got error for running this query. What would be the correct query for this problem?

P.S: Node-churn=(subscribers,degree), CDR-IN=(caller,callee,amount)

Gordon Linoff · Accepted Answer · 2014-02-24 12:27:29Z

1

This is sort of what the select statement would be:

insert into [Node-churn](total_amount_in)
    select sum(cast(amount as float))
    from [CDR-IN]
    where [Node-churn].subscriber = [CDR-IN].callee and degree < 6;

But I think you want an update:

update [Node-churn]
    set total_amount_in = (select sum(cast(amount as float))
                           from [CRD-IN]
                           where [Node-churn].subscriber = [CDR-IN].callee
                          )
    where degree < 6;

answered Feb 24, 2014 at 12:27

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

morepaolo · Accepted Answer · 2014-02-24 12:30:05Z

0

I'm not sure if you can use WHERE in an insert query. Maybe it's a typo, and the correct syntax is

INSERT INTO [Node-churn](total_amount_in)  values= 
   (SELECT sum(cast(amount as float)) 
    FROM [CDR-IN] 
    WHERE [Node-churn].subscriber=[CDR-IN].callee and degree <6
)

answered Feb 24, 2014 at 12:30

morepaolo

6313 silver badges9 bronze badges

Collectives™ on Stack Overflow

Nested insert SQL query

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related