Setting a variable with select inside coalesce

sql variables select sql-server-2000 coalesce
dmr picture dmr · Aug 26, 2010 · Viewed 7.8k times · Source

How do I fix up this part of my stored procedure?

The select will either return 1, 0, or null. If the select returns 1 or 0, I want @override to be set to that value. If it returns null, then I want @override to be set to 1.

Something is wrong with my syntax; I am told "incorrect syntax near 'select'" and "incorrect sytax near ')'".

Here is the sql:

set @override = (coalesce(select override from groupPreferences g inner join
preferences p on g.preferenceId = p.preferenceId where groupId = 13
and description = 'myDescription'), 1))

Answer

bodee picture bodee · Aug 26, 2010 
set @override = (coalesce((select override from groupPreferences g inner join
preferences p on g.preferenceId = p.preferenceId where groupId = 13
and description = 'myDescription'), 1))

Related questions

Declare a variable in Oracle SQL to use in a query

Hi I am trying to declare a variable to use in Oracle SQL select query as such: DECLARE myDate DATE; BEGIN SELECT Source as "Source", DT as "Date", Status as "Status", COALESCE("Count", 0) as "Count" FROM (Huge SubQuery that includes …

Read More
pyodbc - How to perform a select statement using a variable for a parameter

I'm trying to iterate through all the rows in a table named Throughput, but for a specific DeviceName (which I have stored in data['DeviceName']. I've tried the following, but it doesn't work: for row in cursor.execute("select * from …

Read More
How to declare variable and use it in the same Oracle SQL script?

I want to write reusable code and need to declare some variables at the beginning and reuse them in the script, such as: DEFINE stupidvar = 'stupidvarcontent'; SELECT stupiddata FROM stupidtable WHERE stupidcolumn = &stupidvar; How can I declare a variable …

Read More