Unable to use a working query in a SQL Server View: 'IS' not recognized '>' not recognized -


i have query running if used directly string query:

select bi.customer_code [customer code],        bi.add_name customer,        si.account_code [account code],        bid.bill_no [bill #],        bi.bill_date [bill date],        bi.cashier_no [cashier #],        c.location,        bid.service_code [service code],        si.name service,        bid.fees [service fee],        bid.requested_qty [requested quantity],        bid.requested_qty * 10 [knowledge fee],        bid.requested_qty * 10 [innovation fee],        bid.item_tot + bid.requested_qty * 20 total,        bid.requested_qty * bid.fees [total w/o gov. fee],        iif(bi.remarks null, '', iif(len(bi.remarks) > 100, concat(left(bi.remarks, 100), '...'), bi.remarks)) [remarks] dbo.bill_info bi     inner join dbo.bill_info_detail bid         on bi.bill_no = bid.bill_no            , bi.cashier_no = bid.cashier_no            , bi.pay_mode = bid.pay_mode     inner join dbo.cashier c         on bi.cashier_no = c.cashier_no     inner join dbo.service_info si         on bid.service_code = si.service_code (bi.pay_mode = '3')       , (bi.input_status = '1')       , (month(bi.bill_date) = month(getdate()))       , (year(bi.bill_date) = year(getdate()))       , (bi.account_code in ( 'adp', 'asp' ))       , (bid.service_code not in ( 314, 1636, 1637, 1538 )) order [customer code],          [bill date]

but once try use in view, these errors:

error in list of function arguments: 'is' not recognized. error in list of function arguments: '>' not recognized. unable parse query text.

if remove last column iif, works fine. why query not accepted in view?

version: microsoft sql server 2017 (rc1) - 14.0.800.90 (x64) jul 11 2017 07:03:16 copyright (c) 2017 microsoft corporation. rights reserved. express edition (64-bit) on windows 10 enterprise insider preview 10.0 (build 16257: ) (hypervisor)

using ssms create view using designer:

view designer, ssms

edit: updated query show better joins posted in wrong query using better one

with @sepupic's comment help, able create view through query instead of designer. view cannot designed anymore error still there i'm able call view , data , success me.


Comments

Post a Comment

Popular posts from this blog

ubuntu - PHP script to find files of certain extensions in a directory, returns populated array when run in browser, but empty array when run from terminal -

i running os ububtu 16.04. ultimate goal able run php script cron job every minute. here php script located @ /var/www/html/tests/test/index.php : <?php $directorypath = $_server['document_root']."/tests/test/data/"; echo "directorypath: $directorypath<br><br>";//check $imagefilepathsarray = glob($directorypath . "*.{png,gif}", glob_brace); echo "<br><br>imagefilepathsarray: "; print_r($imagefilepathsarray);//check ?> when open php script in browser visiting url my-ip-address/tests/test/index.php , get: directorypath: /var/www/html/tests/test/data/ imagefilepathsarray:array( [0] => /var/www/html/tests/test/data/pic.png [1] => /var/www/html/tests/test/data/pic.gif ) before writing cron job in crontab file, need check if can run anywhere using terminal . opened ubuntu terminal @ /home/ location, , executed in terminal: sudo php /var/www/html/tests/test/index.php i got following out...
Read more

php - How can i create a user dashboard -

today have questions you, want create user dashboard site, include (obviously), users data, example -email -username -and others stuff how can information, , print them in html page? if can, how can these information via php sessions? shuld use session? example, if user login, , start new session ( session_start() ), how can data print in dashboard? should use php "project"? in advice, have day , thank time!
Read more

javascript - How to detect toggling of the fullscreen-toolbar in jQuery Mobile? -

i have jquery mobile page fixed full-screen toolbar, data-tap-toggle enabled. straight under toolbar have positioned banner should slide upwards when toolbar hiding , slide downward when toolbar showing. jquery mobile toggles toolbar applying , removing ui-fixed-hidden class - sadly, can't find in documentation of toolbar widget toggle , hide or show event that. how can detect when toolbar toggled, reposition banner? .banner { position: fixed; background-color: darkseagreen; top: 46px; min-height: 48px; width: 100%; text-align: center; line-height: 48px; } <!doctype html> <html> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=no"> <link rel="stylesheet" href="https://code.jquery.com/mobile/1.4.5/jquery.mobile-1.4.5.css"> <script src="https://code.jquery.com/jquery-1....
Read more