select * from dbo.CARI_MUHASEBE_KARSILASTIRMA<\/p>\n
<\/p>\n
<\/p>\n
<\/p>\n
<\/p>\n
CREATE VIEW dbo.CARI_MUHASEBE_KARSILASTIRMA WITH Encryption<\/p>\n
AS<\/p>\n
SELECT TOP 100 PERCENT<\/p>\n
cari_kod AS [Cari Kodu]<\/p>\n
,ISNULL(cari_unvan1,”) AS [Cari \u00dcnvan\u0131]<\/p>\n
,cari_muh_kod AS [Cari Muhasebe Kodu]<\/p>\n
,CASE WHEN muh_hesap_kod IS NULL THEN ‘Yok’ELSE ‘Var’END AS [Muhasebe Hesap Kodu]<\/p>\n
,ISNULL(muh_hesap_isim1,”) AS [Muhasebe Hesap \u00dcnvan\u0131]<\/p>\n
,ISNULL(SUM(dbo.fn_CariHesapAnaDovizBakiye(”,0,cari_kod,”,”,NULL,NULL,NULL,0)),”) AS [Cari Bakiye]<\/p>\n
,ISNULL(SUM(dbo.fn_muhbakiye(muh_hesap_kod, dbo.fn_GetAktifFirma(), dbo.fn_GetAktifMaliYil(), 0)),”) AS [Muhasebe Bakiye]<\/p>\n
FROM dbo.CARI_HESAPLAR WITH(NOLOCK)<\/p>\n
FULL OUTER JOIN dbo.MUHASEBE_HESAP_PLANI WITH(NOLOCK)<\/p>\n
ON (muh_hesap_kod=cari_muh_kod)<\/p>\n
WHERE cari_muh_kod<>”<\/p>\n
GROUP BY cari_kod, cari_unvan1, cari_muh_kod, muh_hesap_kod, muh_hesap_isim1<\/p>\n
GO<\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
select * from dbo.CARI_MUHASEBE_KARSILASTIRMA CREATE VIEW dbo.CARI_MUHASEBE_KARSILASTIRMA WITH Encryption AS SELECT TOP 100 PERCENT cari_kod AS [Cari Kodu] ,ISNULL(cari_unvan1,”) AS [Cari \u00dcnvan\u0131] ,cari_muh_kod AS [Cari Muhasebe Kodu] ,CASE WHEN muh_hesap_kod IS NULL THEN ‘Yok’ELSE ‘Var’END AS [Muhasebe Hesap Kodu] ,ISNULL(muh_hesap_isim1,”) AS [Muhasebe Hesap \u00dcnvan\u0131] ,ISNULL(SUM(dbo.fn_CariHesapAnaDovizBakiye(”,0,cari_kod,”,”,NULL,NULL,NULL,0)),”) AS [Cari Bakiye] ,ISNULL(SUM(dbo.fn_muhbakiye(muh_hesap_kod, dbo.fn_GetAktifFirma(), dbo.fn_GetAktifMaliYil(), […]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"class_list":["post-1565","post","type-post","status-publish","format-standard","hentry","category-sql-server-tsql"],"_links":{"self":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/1565","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/comments?post=1565"}],"version-history":[{"count":1,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/1565\/revisions"}],"predecessor-version":[{"id":1566,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/1565\/revisions\/1566"}],"wp:attachment":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media?parent=1565"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/categories?post=1565"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/tags?post=1565"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}