emrahguclu

DECLARE @aramasozcugu nvarchar(max) = 'KPI'

SELECT 
  name, 
  create_date, 
  modify_date
FROM   
  sys.procedures
WHERE 
  Object_definition(object_id) LIKE CONCAT('%',@aramasozcugu,'%')

emrahguclu

SELECT 
	LD.LOGICALREF as ID,
	LD.FIRMNR as FIRMNR,
	LF.NAME as UNVAN, 
	LD.SECURNR as SICILNO
FROM 
	L_CAPIFIRM as LF 
INNER JOIN L_CAPIDIV as LD 
ON LF.NR=LD.FIRMNR
ORDER BY LF.NAME

emrahguclu

SET DATEFORMAT dmy;

DECLARE @FIRMNR int = 1 //firma numaraları L_CAPIFIRM tablosunda mevcut
DECLARE @YIL int = 2022
DECLARE @AY int = 1

SELECT 
	LPER.TTFNO,
	NAME,
	SURNAME,