Way for moving stored procedure from Firebird to SQL Server -

-

i have working sp on firebird , can'not find way translate code ms sql server sp

here code:

i have 1 table data from. 1 fields called "iznos" data summary , 1 field recognite diference summary category 

create or alter procedure some_procedure (         b_date date,         e_date date)    returns(         dat date,         value1 decimal(18,2),         value2 decimal(18,2),         value3 (18,2))      begin              select gk.date       gk                gk.date between :b_date , :e_date       group 1       :dat             begin           /* value 1 */           select sum(iznos) gk gk.category=1 , gk.datum=:dat           :value1;           /* value 2 */           select sum(iznos) gk gk.category=2 , gk.datum=:dat           :value2;           /* value 3 */           select sum(iznos) gk gk.category=3 , gk.datum=:dat           :value3;           suspend;       end   end

you can solve using pivot:

select datum, [1] value1, [2] value2, [3] value3 (     select datum, category, iznos      gk      datum between @b_date , @e_date  ) src pivot (     sum(src.iznos)     src.category in ([1], [2], [3]) ) pvt

this doesn't have exact same effect firebird stored procedure though, because returning row each row in gk. if want have exact same result, may have join gk above query.

if intend use stored procedure in select (which possible in firebird, not in sql server), need convert table-valued user-defined function.

you create view instead. in case where clause need removed.

small example in tsql:

create table #example (    datum date,    category int,    val int );  insert #example(datum, category, val) values     ('2015-07-24', 1, 1),     ('2015-07-24', 2, 1),     ('2015-07-24', 3, 1),     ('2015-07-24', 1, 1),     ('2015-07-24', 2, 1),     ('2015-07-25', 3, 1);  select datum, [1] value1, [2] value2, [3] value3 (     select datum, category, val      #example  ) src pivot (     sum(src.val)     src.category in ([1], [2], [3]) ) pvt;  drop table #example;

Comments

Post a Comment

Popular posts from this blog

python - pip install -U PySide error -

-
does know how avoid following error when running pip install -u pyside per official website instructions here: https://pypi.python.org/pypi/pyside/#installing-pyside-on-a-mac-os-x-system note have done brew install qt successfully. you using pip version 7.0.3, version 7.1.2 available. should consider upgrading via 'pip install --upgrade pip' command. collecting pyside using cached pyside-1.2.4.tar.gz installing collected packages: pyside running setup.py install pyside complete output command /applications/anaconda/bin/python -c "import setuptools, tokenize;__file__='/private/var/folders/dy/ttgqhqqx3g9bsbsnqnxsk2z80000gq/t/pip-build-cpxemt/pyside/setup.py';exec(compile(getattr(tokenize, 'open', open)(__file__).read().replace('\r\n', '\n'), __file__, 'exec'))" install --record /var/folders/dy/ttgqhqqx3g9bsbsnqnxsk2z80000gq/t/pip-0r7hri-record/install-record.txt --single-version-externally-managed --compile: ...
Read more

arrays - C++ error: a brace-enclosed initializer is not allowed here before ‘{’ token -

-
simple question: i'm trying initialize array within c++ class declaration: using namespace std; #include <string> class myclass{ public: string myarray[] = {"a","b","c"}; }; and i'm getting error: error: brace-enclosed initializer not allowed here before ‘{’ token no, without complied c++11 compiler, cannot initialize member array in declaration. have initialize array member in constructor. , don't use open array if know number of elements initialize array.
Read more

apache - setting document root in antoher partition on ubuntu -

-
i place apache document root inside partition of ubuntu hard drive, keep getting forbidden message, when place home directory woking find, how be? group or owner affected ? here mysite.conf , apache2.conf when place document root in home folder (working) #site-available/mysite.conf documentroot /home/jono/www #/etc/apache2/apache2.conf <directory /home/jono/www/> options indexes followsymlinks allowoverride none require granted </directory> bu when change document root partition keep getting forbidden messasge #site-available/mysite.conf documentroot /media/jono/website_data/www #/etc/apache2/apache2.conf <directory /media/jono/website_data/www/> options indexes followsymlinks allowoverride none require granted </directory> is owner/group access affected ? or there problem ? at last it's working, have grant access www:data accesing whole directory @mark-b, using chown -r www-data:www-data whole directory is...
Read more