Set from select results constraint

up vote
1
down vote

favorite

Can I set parameter with more than 1 results from view?

Declare @input varchar(1000)

SET @input = (select order from orderlist_view)

Error I received is: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

edited Nov 19 at 4:49

asked Nov 19 at 4:02

NewPy

474

3

You can't - you can use a table variable or a temp table - depends where you are trying to use it.
– Dale Burrell
Nov 19 at 4:05

add a comment |

up vote
1
down vote

favorite

Can I set parameter with more than 1 results from view?

Declare @input varchar(1000)

SET @input = (select order from orderlist_view)

Error I received is: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

edited Nov 19 at 4:49

asked Nov 19 at 4:02

NewPy

474

3

You can't - you can use a table variable or a temp table - depends where you are trying to use it.
– Dale Burrell
Nov 19 at 4:05

add a comment |

up vote
1
down vote

favorite

Can I set parameter with more than 1 results from view?

Declare @input varchar(1000)

SET @input = (select order from orderlist_view)

Error I received is: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

edited Nov 19 at 4:49

asked Nov 19 at 4:02

NewPy

474

Can I set parameter with more than 1 results from view?

Declare @input varchar(1000)

SET @input = (select order from orderlist_view)

Error I received is: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

sql-server

edited Nov 19 at 4:49

asked Nov 19 at 4:02

NewPy

474

edited Nov 19 at 4:49

asked Nov 19 at 4:02

NewPy

474

edited Nov 19 at 4:49

asked Nov 19 at 4:02

NewPy

474

asked Nov 19 at 4:02

NewPy

474

asked Nov 19 at 4:02

NewPy

474

3

You can't - you can use a table variable or a temp table - depends where you are trying to use it.
– Dale Burrell
Nov 19 at 4:05

add a comment |

3

You can't - you can use a table variable or a temp table - depends where you are trying to use it.
– Dale Burrell
Nov 19 at 4:05

You can't - you can use a table variable or a temp table - depends where you are trying to use it.
– Dale Burrell
Nov 19 at 4:05

add a comment |

2 Answers
2

active

oldest

votes

up vote
0
down vote

You can accomplish this with XML:

Declare @input varchar(1000)





select @input = stuff((select distinct ',' + quotename(order)

            from orderlist_view

            for xml path(''), type).value('.', 'nvarchar(max)'),1,1,'')

Would this work?

answered Nov 19 at 9:05

Birel

15410

add a comment |

up vote
0
down vote

You can declare a table instead, and do the following task:

declare @table table(column_name varchar(1000))

insert @table

select order from orderlist_view

-- print the declared table variable

select * from @table.

answered Nov 19 at 11:22

SJC

add a comment |

Your Answer

StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53368150%2fset-from-select-results-constraint%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

2 Answers
2

active

oldest

votes

2 Answers
2

active

oldest

votes

up vote
0
down vote

You can accomplish this with XML:

Declare @input varchar(1000)





select @input = stuff((select distinct ',' + quotename(order)

            from orderlist_view

            for xml path(''), type).value('.', 'nvarchar(max)'),1,1,'')

Would this work?

answered Nov 19 at 9:05

Birel

15410

add a comment |

up vote
0
down vote

You can accomplish this with XML:

Declare @input varchar(1000)





select @input = stuff((select distinct ',' + quotename(order)

            from orderlist_view

            for xml path(''), type).value('.', 'nvarchar(max)'),1,1,'')

Would this work?

answered Nov 19 at 9:05

Birel

15410

add a comment |

up vote
0
down vote

You can accomplish this with XML:

Declare @input varchar(1000)





select @input = stuff((select distinct ',' + quotename(order)

            from orderlist_view

            for xml path(''), type).value('.', 'nvarchar(max)'),1,1,'')

Would this work?

answered Nov 19 at 9:05

Birel

15410

You can accomplish this with XML:

Declare @input varchar(1000)





select @input = stuff((select distinct ',' + quotename(order)

            from orderlist_view

            for xml path(''), type).value('.', 'nvarchar(max)'),1,1,'')

Would this work?

answered Nov 19 at 9:05

Birel

15410

answered Nov 19 at 9:05

Birel

15410

answered Nov 19 at 9:05

Birel

15410

answered Nov 19 at 9:05

Birel

15410

add a comment |

up vote
0
down vote

You can declare a table instead, and do the following task:

declare @table table(column_name varchar(1000))

insert @table

select order from orderlist_view

-- print the declared table variable

select * from @table.

answered Nov 19 at 11:22

SJC

add a comment |

up vote
0
down vote

You can declare a table instead, and do the following task:

declare @table table(column_name varchar(1000))

insert @table

select order from orderlist_view

-- print the declared table variable

select * from @table.

answered Nov 19 at 11:22

SJC

add a comment |

up vote
0
down vote

You can declare a table instead, and do the following task:

declare @table table(column_name varchar(1000))

insert @table

select order from orderlist_view

-- print the declared table variable

select * from @table.

answered Nov 19 at 11:22

SJC

You can declare a table instead, and do the following task:

declare @table table(column_name varchar(1000))

insert @table

select order from orderlist_view

-- print the declared table variable

select * from @table.

answered Nov 19 at 11:22

SJC

answered Nov 19 at 11:22

SJC

answered Nov 19 at 11:22

SJC

answered Nov 19 at 11:22

SJC

add a comment |

draft saved

draft discarded

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Nsryjdtyk