Hi. I have this code and please help me how to add it to sql view, or where should i put the Declare ... Set part in Phpmaker?
DECLARE @taikhoanghinocochitiet nvarchar(50);
SET @taikhoanghinocochitiet = '112112'
SELECT
dbo.tbl_nks_Phieuthu.tkghinochitiet AS tkghinocochitiet,
'TKNO' AS phieu,
dbo.tbl_nks_Phieuthu.id,
dbo.tbl_nks_Phieuthu.idtaikhoannganhang,
CONVERT ( DATE, dbo.tbl_nks_Phieuthu.thoigian ) AS ngaythuchi,
CONVERT ( DATE, dbo.tbl_nks_Phieuthu.ngayhachtoan ) AS ngayhachtoan,
dbo.tbl_nks_Phieuthu.sotienhachtoan AS sotienhachtoan,
dbo.tbl_nks_Phieuthu.tkghino AS taikhoan,
dbo.tbl_nks_Phieuthu.nguoinop AS nguoinopguoinhan,
dbo.tbl_nks_Phieuthu.noidung,
dbo.tbl_nks_Phieuthu.isgdcn,
dbo.tbl_nks_Phieuthu.doichieusaoke,
dbo.tbl_nks_Phieuthu.ischeck,
dbo.tbl_nks_Phieuthu.isdauky,
dbo.tbl_nks_Phieuthu.lock
FROM
dbo.tbl_nks_Phieuthu
WHERE
( dbo.tbl_nks_Phieuthu.ngayhachtoan >= ( SELECT tbl_nks_ngaybaocao.tungay FROM tbl_nks_ngaybaocao WHERE tbl_nks_ngaybaocao.id= 1 ) )
AND ( dbo.tbl_nks_Phieuthu.ngayhachtoan <= ( SELECT tbl_nks_ngaybaocao.denngay FROM tbl_nks_ngaybaocao WHERE tbl_nks_ngaybaocao.id= 1 ) )
AND ( dbo.tbl_nks_Phieuthu.tkghinochitiet = @taikhoanghinocochitiet )