Ttyjfyk

Is it fair for a professor to grade us on the possession of past papers?

Should I discuss the type of campaign with my players?

What to do with chalk when deepwater soloing?

Using et al. for a last / senior author rather than for a first author

How do pianists reach extremely loud dynamics?

Check which numbers satisfy the condition [A*B*C = A! + B! + C!]

Why do people hide their license plates in the EU?

How widely used is the term Treppenwitz? Is it something that most Germans know?

Seeking colloquialism for “just because”

How to react to hostile behavior from a senior developer?

Denied boarding although I have proper visa and documentation. To whom should I make a complaint?

Echoing a tail command produces unexpected output?

In predicate logic, does existential quantification (∃) include universal quantification (∀), i.e. can 'some' imply 'all'?

Error "illegal generic type for instanceof" when using local classes

Bete Noir -- no dairy

Can a non-EU citizen traveling with me come with me through the EU passport line?

Using audio cues to encourage good posture

What's the meaning of 間時肆拾貳 at a car parking sign

What causes the vertical darker bands in my photo?

Extract all GPU name, model and GPU ram

When were vectors invented?

Why was the term "discrete" used in discrete logarithm?

Why light coming from distant stars is not discreet?

Coloring maths inside a tcolorbox

Why am I getting the error “non-boolean type specified in a context where a condition is expected” for this request?

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

5

I am getting this error :
"Error 102 : non-boolean type specified in a context where a condition is expected"

for this request :

DECLARE @num_dossiers TABLE (num_dossier INT,indice NVARCHAR(3))
insert into @num_dossiers
select num_dossier,indice from dossier where num_sec=57

delete from constitue where (num_dossier,indice) in select (num_dossier,indice) from @num_dossiers 

The request triggering the error is the last one :

delete from constitue where (num_dossier,indice) in select (num_dossier,indice) from @num_dossiers 

What could be the cause of this error ?

sql-server sql-server-2008

share|improve this question

asked 11 hours ago

mounaimmounaim

3213723

add a comment | 

5

I am getting this error :
"Error 102 : non-boolean type specified in a context where a condition is expected"

for this request :

DECLARE @num_dossiers TABLE (num_dossier INT,indice NVARCHAR(3))
insert into @num_dossiers
select num_dossier,indice from dossier where num_sec=57

delete from constitue where (num_dossier,indice) in select (num_dossier,indice) from @num_dossiers 

The request triggering the error is the last one :

delete from constitue where (num_dossier,indice) in select (num_dossier,indice) from @num_dossiers 

What could be the cause of this error ?

sql-server sql-server-2008

share|improve this question

asked 11 hours ago

mounaimmounaim

3213723

add a comment | 

I am getting this error :
"Error 102 : non-boolean type specified in a context where a condition is expected"

for this request :

DECLARE @num_dossiers TABLE (num_dossier INT,indice NVARCHAR(3))
insert into @num_dossiers
select num_dossier,indice from dossier where num_sec=57

delete from constitue where (num_dossier,indice) in select (num_dossier,indice) from @num_dossiers 

The request triggering the error is the last one :

delete from constitue where (num_dossier,indice) in select (num_dossier,indice) from @num_dossiers 

What could be the cause of this error ?

sql-server sql-server-2008

share|improve this question

asked 11 hours ago

mounaimmounaim

3213723

DECLARE @num_dossiers TABLE (num_dossier INT,indice NVARCHAR(3))
insert into @num_dossiers
select num_dossier,indice from dossier where num_sec=57

delete from constitue where (num_dossier,indice) in select (num_dossier,indice) from @num_dossiers 

delete from constitue where (num_dossier,indice) in select (num_dossier,indice) from @num_dossiers 

share|improve this question

asked 11 hours ago

mounaimmounaim

3213723

share|improve this question

asked 11 hours ago

mounaimmounaim

3213723

asked 11 hours ago

mounaimmounaim

3213723

asked 11 hours ago

mounaimmounaim

3213723

1 Answer
1

active

oldest

votes

13

SQL Server doesn't support a multi-column IN clause (unlike Oracle).

delete 
from constitue 
where (num_dossier,indice) in select (num_dossier,indice) from @num_dossiers 

This can be rewritten as a EXISTS:

DELETE c
FROM constitue c
WHERE EXISTS 
 (SELECT 1 FROM @num_dossiers nd WHERE n.num_dossier = c.num_dossier AND n.indice = c.indice);

share|improve this answer

answered 11 hours ago

Mark SinkinsonMark Sinkinson

8,01633049

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  this was helpful, Thank you sir :) Any idea on why SQL Server does not support this kind of IN syntax? the Oracle style seems more intuitive
  
  – mounaim
  11 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You can express support for this (currently unplanned) prospect here: feedback.azure.com/forums/908035-sql-server/suggestions/…
  
  – Peter Vandivier
  9 hours ago
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "182"
;
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',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
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');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f234938%2fwhy-am-i-getting-the-error-non-boolean-type-specified-in-a-context-where-a-cond%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

13

SQL Server doesn't support a multi-column IN clause (unlike Oracle).

delete 
from constitue 
where (num_dossier,indice) in select (num_dossier,indice) from @num_dossiers 

This can be rewritten as a EXISTS:

DELETE c
FROM constitue c
WHERE EXISTS 
 (SELECT 1 FROM @num_dossiers nd WHERE n.num_dossier = c.num_dossier AND n.indice = c.indice);

share|improve this answer

answered 11 hours ago

Mark SinkinsonMark Sinkinson

8,01633049

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  this was helpful, Thank you sir :) Any idea on why SQL Server does not support this kind of IN syntax? the Oracle style seems more intuitive
  
  – mounaim
  11 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You can express support for this (currently unplanned) prospect here: feedback.azure.com/forums/908035-sql-server/suggestions/…
  
  – Peter Vandivier
  9 hours ago
  

  
  
  
  

add a comment | 

13

SQL Server doesn't support a multi-column IN clause (unlike Oracle).

delete 
from constitue 
where (num_dossier,indice) in select (num_dossier,indice) from @num_dossiers 

This can be rewritten as a EXISTS:

DELETE c
FROM constitue c
WHERE EXISTS 
 (SELECT 1 FROM @num_dossiers nd WHERE n.num_dossier = c.num_dossier AND n.indice = c.indice);

share|improve this answer

answered 11 hours ago

Mark SinkinsonMark Sinkinson

8,01633049

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  this was helpful, Thank you sir :) Any idea on why SQL Server does not support this kind of IN syntax? the Oracle style seems more intuitive
  
  – mounaim
  11 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You can express support for this (currently unplanned) prospect here: feedback.azure.com/forums/908035-sql-server/suggestions/…
  
  – Peter Vandivier
  9 hours ago
  

  
  
  
  

add a comment | 

SQL Server doesn't support a multi-column IN clause (unlike Oracle).

delete 
from constitue 
where (num_dossier,indice) in select (num_dossier,indice) from @num_dossiers 

This can be rewritten as a EXISTS:

DELETE c
FROM constitue c
WHERE EXISTS 
 (SELECT 1 FROM @num_dossiers nd WHERE n.num_dossier = c.num_dossier AND n.indice = c.indice);

share|improve this answer

answered 11 hours ago

Mark SinkinsonMark Sinkinson

8,01633049

delete 
from constitue 
where (num_dossier,indice) in select (num_dossier,indice) from @num_dossiers 

DELETE c
FROM constitue c
WHERE EXISTS 
 (SELECT 1 FROM @num_dossiers nd WHERE n.num_dossier = c.num_dossier AND n.indice = c.indice);

share|improve this answer

answered 11 hours ago

Mark SinkinsonMark Sinkinson

8,01633049

answered 11 hours ago

Mark SinkinsonMark Sinkinson

8,01633049

answered 11 hours ago

Mark SinkinsonMark Sinkinson

8,01633049