--KICEM
select * from KANIX_Subscription..Subscriber  where Subscriber_Id =20200113000001
--update Subscriber set  Subscriber_Name='Nyati Group', Login_Name='Nyati Group',	Login_Password='Nyati@1234$',	Mobile='9999999999', 
--Email='info@nyatigroup.com', Mobile_Verified	=0,Email_Verified=0
--where Subscriber_Id =20200123000001  

select * from Kanix_ICEM..Subscription where Subscriber_Id =20200113000001

update Kanix_ICEM..Subscription set To_Date ='2020-04-13'  where Subscriber_Id =20200113000001 and Subscription_Id = 1

insert into Subscription 
values(148,	'2020-02-26',20200123000001,1,'2020-02-26','2020-04-26','--',0.00,'',0.00,7999.00,'','Cash',0,0)


--Vikram developer  Email: rishikesh@vgg.co.in Contact: 95271 22900


use KANIX_Subscription
Go

select * from KANIX_Subscription..Subscriber  where GUID =  507 and Subscriber_Id =20200709000003
select * from  KANIX_Subscription..Subscription  where Subscriber_Id =20200709000003

INSERT INTO KANIX_Subscription..Subscriber (Subscriber_Name, Login_Name, Login_Password, Mobile, Email, Mobile_Verified, Email_Verified, Subscriber_Id, Status, GUID)
VALUES        ('Prerna Keluskar', 'acc.prerna@GKAssociates', 'acc.prerna@123$', '9822045919', 'Vpchandwani@gmail.com', 1, 1, 20200731000001,0,507) 

INSERT INTO KANIX_Subscription..Subscriber (Subscriber_Name, Login_Name, Login_Password, Mobile, Email, Mobile_Verified, Email_Verified, Subscriber_Id, Status, GUID)
VALUES        ('Reena Manglani', 'acc.reena@GKAssociates', 'acc.reena@123$', '9822045919', 'Vpchandwani@gmail.com', 1, 1, 20200731000002,0,507) 

INSERT INTO KANIX_Subscription..Subscriber (Subscriber_Name, Login_Name, Login_Password, Mobile, Email, Mobile_Verified, Email_Verified, Subscriber_Id, Status, GUID)
VALUES        ('Sandeep Gaikwad', 'acc.sandeep@GKAssociates', 'acc.sandeep@123$', '9822045919', 'Vpchandwani@gmail.com', 1, 1, 20200731000003,0,507) 

INSERT INTO KANIX_Subscription..Subscriber (Subscriber_Name, Login_Name, Login_Password, Mobile, Email, Mobile_Verified, Email_Verified, Subscriber_Id, Status, GUID)
VALUES        ('Sangeeta Motwani', 'acc.sangeeta@GKAssociates', 'acc.sangeeta@123$', '9822045919', 'Vpchandwani@gmail.com', 1, 1, 20200731000004,0,507) 

INSERT INTO KANIX_Subscription..Subscriber (Subscriber_Name, Login_Name, Login_Password, Mobile, Email, Mobile_Verified, Email_Verified, Subscriber_Id, Status, GUID)
VALUES        ('Manoj Rajguru', 'acc.manoj@GKAssociates', 'acc.manoj@123$', '9822045919', 'Vpchandwani@gmail.com', 1, 1, 20200731000005,0,507) 

INSERT INTO KANIX_Subscription..Subscriber (Subscriber_Name, Login_Name, Login_Password, Mobile, Email, Mobile_Verified, Email_Verified, Subscriber_Id, Status, GUID)
VALUES        ('Meghna Fulsunder', 'acc.meghna@GKAssociates', 'acc.meghna@123$', '9822045919', 'Vpchandwani@gmail.com', 1, 1, 20200731000006,0,507) 

INSERT INTO KANIX_Subscription..Subscriber (Subscriber_Name, Login_Name, Login_Password, Mobile, Email, Mobile_Verified, Email_Verified, Subscriber_Id, Status, GUID)
VALUES        ('Rinky Kukreja', 'acc.rinky@GKAssociates', 'acc.rinky@123$', '9822045919', 'Vpchandwani@gmail.com', 1, 1, 20200731000007,0,507) 

insert into KANIX_Subscription..Subscription values (20200731000001, 304, '2020-07-31', 0)
insert into KANIX_Subscription..Subscription values (20200731000002, 304, '2020-07-31', 0)
insert into KANIX_Subscription..Subscription values (20200731000003, 304, '2020-07-31', 0)
insert into KANIX_Subscription..Subscription values (20200731000004, 304, '2020-07-31', 0)
insert into KANIX_Subscription..Subscription values (20200731000005, 304, '2020-07-31', 0)
insert into KANIX_Subscription..Subscription values (20200731000006, 304, '2020-07-31', 0)
insert into KANIX_Subscription..Subscription values (20200731000007, 304, '2020-07-31', 0)

--KICEM

use KANIX_Subscription
Go

select * from KANIX_Subscription..Subscriber  where  Subscriber_Id =20210203000002 -- Subscriber_Name= '%kumb%' --
select * from  KANIX_Subscription..Subscription  where Subscriber_Id =20210203000002

INSERT INTO KANIX_Subscription..Subscriber (Subscriber_Id,Subscriber_Name, Login_Name, Login_Password, Mobile, Email, Mobile_Verified, Email_Verified,  Status)
VALUES        (20210203000002,'Nilesh Namdev Patil', 'nilesh.patil', 'nilesh@123$', '8390999614', 'nileshpatil7801@gmail.com', 1, 1, 0) 

insert into KANIX_Subscription..Subscription
values (20210203000002,	301,'2021-02-03',0)
go
use Kanix_ICEM
GO

select top 5 * from Kanix_ICEM..Subscription --where Subscriber_Id =20210203000002
order by 1 desc

--update Kanix_ICEM..Subscription set To_Date ='2020-04-13'  where Subscriber_Id =20200113000001 and Subscription_Id = 1

insert into Kanix_ICEM..Subscription 
values(190,	'2021-02-03',20210203000002,1,'2021-02-03','2021-08-02','--',0.00,'',0.00,7999.00,'','Cash',0,0)