Knowledgebase
Sejour Otomatik lisans açma
Posted by Hüseyin METİN on 03 May 2017 15:27:04

Sejour v20 olanlar için v21 lisansı verme

 


 

INSERT INTO MasterLisans(MusNo, LisansTuru, Program, Tarih, ClientSayisi, Kullanici, Aciklama)
SELECT M.MusNo, 'Y', 121, '05/03/2017', SUM(ClientSayisi), 'ADMIN', 'AutoCreated'
FROM MasterLisans M
LEFT JOIN Musteri M1 ON M1.MusNo = M.MusNo
WHERE Program=120 AND M1.[Status]='O' AND NOT EXISTS(SELECT 1 FROM MasterLisans L WHERE L.MusNo=M.MusNo AND L.Program =121) 
GROUP BY M.MusNo

 

 

(0 vote(s))
This article was helpful
This article was not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
Help Desk Software by Kayako case