LOGO SQL FATURAYA BAGLI IRSALIYELERIN ESITLIK KONTROLLERI

SELECT *
,CASE WHEN T.FTARIH=T.ITARIH THEN 'ESIT' ELSE 'ESIT DEGIL' END AS TARIHESITMI
,CASE WHEN T.FTUTAR=T.ITUTAR THEN 'ESIT' ELSE 'ESIT DEGIL' END AS TUTARESITMI
,CASE WHEN T.FISYERI=T.IISYERI THEN 'ESIT' ELSE 'ESIT DEGIL' END AS ISYERIESITMI
,CASE WHEN T.FAMBAR=T.IAMBAR THEN 'ESIT' ELSE 'ESIT DEGIL' END AS AMBARESITMI
 FROM(
SELECT I.FICHENO FFISNO,I.DATE_ FTARIH,I.NETTOTAL FTUTAR,I.BRANCH FISYERI,I.SOURCEINDEX FAMBAR,
S.FICHENO IFISNO,S.DATE_ ITARIH,S.NETTOTAL ITUTAR,S.BRANCH IISYERI,S.SOURCEINDEX IAMBAR
FROM LG_104_01_INVOICE I WITH(NOLOCK)
LEFT JOIN LG_104_01_STFICHE S ON S.INVOICEREF=I.LOGICALREF WHERE S.TRCODE=1 AND I.TRCODE=1
) AS T

LOGO İRSALİYELERİN TARİHİNİ FATURA TARİHLERİNE EŞİTLEME

--STLINE TARİHİ EŞİTLE
UPDATE INVDATEUPDT SET STLDATE=INVDATE FROM
(
SELECT     STL.DATE_ AS STLDATE,
          INV.DATE_ AS INVDATE
FROM     LG_201_01_STLINE AS STL
LEFT OUTER JOIN
LG_201_01_INVOICE AS INV ON INV.LOGICALREF=STL.INVOICEREF
WHERE     STL.INVOICEREF<>0 AND STL.DATE_<>INV.DATE_
)AS INVDATEUPDT
----------------------------------------------
--IRSALYE TARİHİ EŞİTLE
UPDATE STFICHEDATEUPD SET STFDATE=INVDATE FROM
(
SELECT     INV.DATE_ AS INVDATE,
          STF.DATE_ AS STFDATE
FROM     LG_201_01_INVOICE AS INV
LEFT OUTER JOIN
LG_201_01_STFICHE AS STF ON INV.LOGICALREF=STF.INVOICEREF
WHERE     STF.INVOICEREF<>0 AND STF.DATE_<>INV.DATE_
) AS STFICHEDATEUPD
*/

LOGO AMORTİSMAN HESAPLAMA İŞLEMLERİ

önce dbden ilgili yıl ve aydaki hesaplamalar silinir
delete from LG_101_FAYEAR WHERE YEAR_ in (2019) AND CALCMON in (3)

duran varlık yönetimi-işlemler-toplu amortisman değerleme/hesaplama
2019 ve 3üncü ay

daha sonra dosya öndeğerleme duran varlık hareketlerinden ilgili yıl ve ayı seç muhasebe masraf değerlerini bağlantıdan okuya bas ve tamama bas.

Daha sonra genel muhasebe - işlemler - muhasebeleştirme - sabit kıymet amortisman ve değerleme işlemleri ilgili yıl ve tamam bas

SQL SERVER TUNING TARAFINDAN OLUSTURULAN INDEXLERI BULMA

SELECT * FROM (
SELECT i.[name] as index_name,
    substring(column_names, 1, len(column_names)-1) as [columns],
    case when i.[type] = 1 then 'Clustered index'
        when i.[type] = 2 then 'Nonclustered unique index'
        when i.[type] = 3 then 'XML index'
        when i.[type] = 4 then 'Spatial index'
        when i.[type] = 5 then 'Clustered columnstore index'
        when i.[type] = 6 then 'Nonclustered columnstore index'
        when i.[type] = 7 then 'Nonclustered hash index'
        end as index_type,
    case when i.is_unique = 1 then 'Unique'
        else 'Not unique' end as [unique],
    schema_name(t.schema_id) + '.' + t.[name] as table_view,
    case when t.[type] = 'U' then 'Table'
        when t.[type] = 'V' then 'View'
        end as [object_type]
from sys.objects t
    inner join sys.indexes i
        on t.object_id = i.object_id
    cross apply (select col.[name] + ', '
                    from sys.index_columns ic
                        inner join sys.columns col
                            on ic.object_id = col.object_id
                            and ic.column_id = col.column_id
                    where ic.object_id = t.object_id
                        and ic.index_id = i.index_id
                            order by col.column_id
                            for xml path ('') ) D (column_names)
where t.is_ms_shipped <> 1
and index_id > 0
 )
AS T WHERE T.index_name LIKE '_DTA%'

--silmek isdersen DROP INDEX index_name;

SQL SERVER TEK HUCREDE VIRGULLU DATAYI ROWA CEVIRME

create FUNCTION [dbo].[SM_SPLIT]( 
@delimited NVARCHAR(MAX), 
@delimiter NVARCHAR(100) 
) RETURNS @table TABLE (id INT IDENTITY(1,1), [value] NVARCHAR(MAX)) 
AS 
BEGIN 
DECLARE @xml XML 
SET @xml = N'<t>' + REPLACE(@delimited,@delimiter,'</t><t>') + '</t>' 
INSERT INTO @table([value]) 
SELECT r.value('.','Nvarchar(MAX)') as item 
FROM @xml.nodes('/t') as records(r) 
RETURN 
END 

select * from dbo.SM_SPLIT(REPLACE('0, 111, 121, 131, 141, 211, 221, 231, 241, 251, 261, 271, 281, 212, 222, 232, 242, 252, 262, 272',' ',''),',')  

LOGO KURULU SERVERIN ŞİFRESİ DEĞİŞTİĞİNDE LOGODA SERVİS BAŞLAMAMA HATASI ÇÖZÜMÜ

start run comexp.msc /32
Administrative Tools -> Component Services -> My computer -> DCOM
bunu bul {00CDA438-213D-47A3-AF3E-13DB9290D2A0}
sağ tık identity de mevcut admini kaydet şifresiyle


SC DELETE "LOGO_TIGER3ENTERPRISE_Service_17500_300794_2_57"


SC CREATE "LOGO_TIGER3ENTERPRISE_Service_17500_300794_2_57" binpath="D:\LOGO\TIGER3ENTERPRISE\LOGO_TIGER3ENTERPRISE_Service.exe"

 SERVİS YİNEDE ÇALIŞMAZSA VERSİON GUNCELLE OLARAK 2 defa TEKRAR KUR