 |
|
|
|
Next: Select Text Vertically
|
| Author |
Message |
External
Since: Oct 17, 2008
Posts: 3
|
(Msg. 1) Posted: Fri Oct 17, 2008 3:24 am
Post subject: Boolean expressions evaluation
Archived from groups: microsoft>public>sqlserver>mseq (more info?)
|
|
|
Good morning all.
I come from MSAccess, I'm trying to run this sql as a view in SQL Server 2005:
SELECT Qty, (Qty > 10000) AS HighQty
FROM TD_DocRows
I'd exprect to see something like:
10 0
230 0
15250 1 ...
but I receive an error: incorrect syntax near '>'
Can anyone help about the correct syntax?
Thank you,
Matteo |
|
| Back to top |
|
 | |
External
Since: Oct 17, 2008
Posts: 3
|
(Msg. 2) Posted: Fri Oct 17, 2008 5:01 am
Post subject: RE: Boolean expressions evaluation [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
> Good morning all.
> I come from MSAccess, I'm trying to run this sql as a view in SQL Server 2005:
> SELECT Qty, (Qty > 10000) AS HighQty
> FROM TD_DocRows
>
> I'd exprect to see something like:
> 10 0
> 230 0
> 15250 1 ...
>
> but I receive an error: incorrect syntax near '>'
>
> Can anyone help about the correct syntax?
>
> Thank you,
> Matteo
>
Is this the correct syntax?
CASE WHEN Qty > 10000 THEN 1 ELSE 0 END AS HighQty
Thanks,
Matteo |
|
| Back to top |
|
| |
External
Since: Jan 10, 2008
Posts: 608
|
(Msg. 3) Posted: Fri Oct 17, 2008 2:42 pm
Post subject: Re: Boolean expressions evaluation [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Matteo,
Yes, that looks right. When you run it does it give you the expected
results?
RLF
"Potone" wrote in message
>> Good morning all.
>> I come from MSAccess, I'm trying to run this sql as a view in SQL Server
>> 2005:
>> SELECT Qty, (Qty > 10000) AS HighQty
>> FROM TD_DocRows
>>
>> I'd exprect to see something like:
>> 10 0
>> 230 0
>> 15250 1 ...
>>
>> but I receive an error: incorrect syntax near '>'
>>
>> Can anyone help about the correct syntax?
>>
>> Thank you,
>> Matteo
>>
> Is this the correct syntax?
> CASE WHEN Qty > 10000 THEN 1 ELSE 0 END AS HighQty
>
> Thanks,
> Matteo >> Stay informed about: Boolean expressions evaluation |
|
| Back to top |
|
| |
External
Since: Oct 17, 2008
Posts: 3
|
(Msg. 4) Posted: Sat Oct 18, 2008 5:24 am
Post subject: Re: Boolean expressions evaluation [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Yes, using 'CASE' I obtain the results I expected.
Matteo
"Russell Fields" wrote:
> Matteo,
>
> Yes, that looks right. When you run it does it give you the expected
> results?
>
> RLF
>
> "Potone" wrote in message
>
> >> Good morning all.
> >> I come from MSAccess, I'm trying to run this sql as a view in SQL Server
> >> 2005:
> >> SELECT Qty, (Qty > 10000) AS HighQty
> >> FROM TD_DocRows
> >>
> >> I'd exprect to see something like:
> >> 10 0
> >> 230 0
> >> 15250 1 ...
> >>
> >> but I receive an error: incorrect syntax near '>'
> >>
> >> Can anyone help about the correct syntax?
> >>
> >> Thank you,
> >> Matteo
> >>
> > Is this the correct syntax?
> > CASE WHEN Qty > 10000 THEN 1 ELSE 0 END AS HighQty
> >
> > Thanks,
> > Matteo
>
>
> >> Stay informed about: Boolean expressions evaluation |
|
| Back to top |
|
| |
| Related Topics: | index on a view - Hello, I have a table (TAB) and A View with alias (VIEW) Table cod varchar 3 descr carchar 60 my view cod alias COd1 descr alias DES Now i need a index on view with key COD1 I can't create it. Can..
Creating an alias - I have an alias that can get very long because it maintains a information of where it came from. Is there a way to alias an alias? My first thought was: Declare @T1 varchar(128) Set T1 = 'MyAlias' .... Inner Join Table1 as @T1 This of course does no...
Formatting numeric fields in select-clause - This is propably a very simple question, but I can´t seem to find the answer to it in the documentation. I want to format a numeric field so the result is right justified and zero-filled. ex select 1 will give the result 01 How do I manage this..
Simple Query problem - Sample table as follows Order ID Stock Code Status --------- ------- ------- 203 STK1 3 203 STK2 2 203 STK4 3 204 STK1 3 204 STK5 3 205 ..
query assistance -return most recent date - I have a table that has two fields, pkg_num, which is a number, and del_date_time, which is a date-time. The table can contain duplicate pkg_num values, as long as the del_date_time values are different for any given number. I need a query that will... |
|
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum
|
|
|
|
|
|
|
FAQ
Search
Profile
Private Messages
Log in
