SQL Query Executor - SqlQueryExecuteApp

ALTER TABLE [pos].[CustomerGroups] ADD CONSTRAINT [DF_pos_CustomerGroups_RecordId] DEFAULT NEWSEQUENTIALID() FOR [RecordId];

ALTER TABLE inventory.PurchaseRequisites ADD RequisiteReferenceId UNIQUEIDENTIFIER NULLGO

ALTER TABLE restaurant.OutletWiseOrderTypesADD CONSTRAINT FK_OutletWiseOrderTypes_OrderTypesFOREIGN KEY (OrderTypeId)REFERENCES restaurant.OrderTypes(Id);

ALTER TABLE core.Issues ADD PurchaseId UNIQUEIDENTIFIER NULLGO

update core.PrintTemplates set TransactionId = 'F5007D08-61ED-410D-8639-EA8AE6AA3972' where Name ='Abbreviated';

alter table restaurant.OrderTickets Add CancelledDate DateTime null;

ALTER TABLE [inventory].[PurchaseOrders]ADD [SupplierLocationId] UNIQUEIDENTIFIER NULL;

CREATE TABLE [pos].[CustomerGroups]( [RecordId] UNIQUEIDENTIFIER NOT NULL, [Id] UNIQUEIDENTIFIER NOT NULL, [Name] VARCHAR(255) NOT NULL, [IsActive] [bit] NULL, [Tracker] VARCHAR(255) NULL, [RecordStatus] TINYINT NOT NULL, [Tag] VARCHAR(255) NULL, [CompanyId] UNIQUEIDENTIFIER NULL, [BranchId] UNIQUEIDENTIFIER NULL, [CreatedBy] UNIQUEIDENTIFIER NOT NULL, [CreatedDate] DATETIME NOT NULL, [CreatedRemarks] VARCHAR(255) NULL, [DeletedBy] UNIQUEIDENTIFIER NULL, [DeletedDate] DATETIME NULL);

alter table payroll.Advances add CreatedRemarks nvarchar(max) null;

ALTER TABLE [restaurant].[FreeSchemes] ADD CONSTRAINT [DF_restaurant_FreeSchemes_RecordStatus] DEFAULT 1 FOR [RecordStatus]GO

alter table payroll.HeadingSetUps add CreatedRemarks nvarchar(max) null;

ALTER TABLE core.CustomerCreditPayments ADD CustomerName NVARCHAR(255) NULL, CustomerPan NVARCHAR(50) NULL, CustomerPhone NVARCHAR(50) NULL;

ALTER TABLE [pos].[DeliveryBoyAreaAllocations] ADD CONSTRAINT [PK_pos_DeliverBoyAreaAllocations_Id] PRIMARY KEY([Id])

CREATE TABLE [MasterModule].[MultiDBAddForms]( [RecordId] UNIQUEIDENTIFIER NOT NULL, [Id] UNIQUEIDENTIFIER NOT NULL, [DBName] VARCHAR(MAX) NOT NULL, [ServerName] VARCHAR(MAX) NOT NULL, [UserName] VARCHAR(MAX) NOT NULL, [Password] VARCHAR(MAX) NOT NULL, [Tracker] VARCHAR(255) NULL, [RecordStatus] TINYINT NOT NULL, [Tag] VARCHAR(255) NULL, [CompanyId] UNIQUEIDENTIFIER NOT NULL, [BranchId] UNIQUEIDENTIFIER NOT NULL, [CreatedBy] UNIQUEIDENTIFIER NOT NULL, [CreatedDate] DATETIME NOT NULL, [CreatedRemarks] VARCHAR(255) NULL, [DeletedBy] UNIQUEIDENTIFIER NULL, [DeletedDate] DATETIME NULL)GO ALTER TABLE [MasterModule].[MultiDBAddForms] ADD CONSTRAINT [PK_MasterModule_MultiDBAddForms_Id] PRIMARY KEY([Id])GO ALTER TABLE [MasterModule].[MultiDBAddForms] ADD CONSTRAINT [DF_MasterModule_MultiDBAddForms_RecordId] DEFAULT NEWSEQUENTIALID() FOR [RecordId]GO ALTER TABLE [MasterModule].[MultiDBAddForms] ADD CONSTRAINT [DF_MasterModule_MultiDBAddForms_RecordStatus] DEFAULT 1 FOR [RecordStatus]GO

;WITH CTE AS( SELECT *, ROW_NUMBER() OVER (PARTITION BY [Key] ORDER BY Id) AS RN FROM restaurant.GeneralSettings WHERE [Key] LIKE '%kpt%')DELETE FROM CTEWHERE RN > 1;

UPDATE vdSET vd.VoucherDate = v.VoucherDateFROM account.VoucherDetails vdINNER JOIN account.Vouchers v ON vd.VoucherId = v.Id;

ALTER TABLE restaurant.MenusADD ComboStyle INT NULL;

alter TABLE [restaurant].[UserAccesses]add [BlockId] [uniqueidentifier] NULL;

UPDATE vdSET vd.RefId = v.RefIdFROM account.VoucherDetails vdINNER JOIN account.Vouchers v ON vd.VoucherId = v.Id;

alter table restaurant.BillOrderItems add SchemeDiscountPercent DECIMAL (16,8) NULL;

ALTER TABLE [pos].[CustomerGroups] ADD CONSTRAINT [DF_pos_CustomerGroups_RecordStatus] DEFAULT 1 FOR [RecordStatus];

ALTER TABLE restaurant.Bookings ADD CustomerName NVARCHAR(255) NULL, CustomerPan NVARCHAR(50) NULL, CustomerContactNumber NVARCHAR(50) NULL;

ALTER TABLE [restaurant].[FreeSchemeFreeItems] ADD CONSTRAINT [DF_restaurant_FreeSchemeFreeItems_RecordStatus] DEFAULT 1 FOR [RecordStatus]

alter TRIGGER frontoffice.trg_chk_stay_date_fromON frontoffice.fo_resv_reservation_assign_guest_roomsAFTER INSERT, UPDATEASBEGIN SET NOCOUNT ON; IF EXISTS ( SELECT 1 FROM inserted i INNER JOIN frontoffice.fo_resv_guest_reservation_detail g ON i.resv_guest_id = g.resv_guest_id INNER JOIN frontoffice.fo_resv_reservation_master m ON g.resv_id = m.reservation_id WHERE CAST(i.stay_date_from AS DATE) < CAST(m.resv_arr_date AS DATE) ) BEGIN RAISERROR('stay_date_from cannot be earlier than the reservation arrival date (resv_arr_date).', 16, 1); ROLLBACK TRANSACTION; RETURN; ENDENDGO alter TRIGGER frontoffice.trg_chk_post_dateON frontoffice.fo_postingAFTER INSERT, UPDATEASBEGIN SET NOCOUNT ON; IF EXISTS ( SELECT 1 FROM inserted i INNER JOIN frontoffice.fo_folio_master f ON i.post_folio_id = f.folio_id INNER JOIN frontoffice.fo_resv_reservation_master m ON f.folio_resv_id = m.reservation_id WHERE CAST(i.post_date AS DATE) < CAST(m.resv_arr_date AS DATE) ) BEGIN RAISERROR('post_date cannot be earlier than the reservation arrival date (resv_arr_date).', 16, 1); ROLLBACK TRANSACTION; RETURN; ENDENDGO

alter table restaurant.OrderTicketItems add HasAddOn bit null;

UPDATE pos.ChalanDetailSKUsSET ProductId = ISNULL(ItemId, '00000000-0000-0000-0000-000000000000');

alter table core.ledgermappings add BranchId uniqueidentifier null;

alter table payroll.HeadingTypes add CreatedRemarks nvarchar(max) null;

UPDATE core.ItemsSET Quantity = 0WHERE Quantity IS NULL;

alter table restaurant.express add IsVoided bit null;

ALTER TABLE [restaurant].[FreeSchemeItems] ADD CONSTRAINT [DF_restaurant_FreeSchemeItems_RecordId] DEFAULT NEWSEQUENTIALID() FOR [RecordId]

update system.Pagesset Icon=''where Name ='receive';

alter table restaurant.expressdetails add MenuName nvarchar(max) null;

CREATE TABLE [inventory].[PurchaseRequisites]( [RecordId] UNIQUEIDENTIFIER NOT NULL, [Id] UNIQUEIDENTIFIER NOT NULL, [RequisiteCode] VARCHAR(MAX) NULL, [RequisiteDate] DATETIME NULL, [RequisiteDateNP] VARCHAR(MAX) NULL, [Remarks] VARCHAR(MAX) NULL, [IsVoid] BIT NULL, [DepartmentId] UNIQUEIDENTIFIER NOT NULL, [Tracker] VARCHAR(255) NULL, [RecordStatus] TINYINT NOT NULL, [Tag] VARCHAR(255) NULL, [CompanyId] UNIQUEIDENTIFIER NOT NULL, [BranchId] UNIQUEIDENTIFIER NOT NULL, [CreatedBy] UNIQUEIDENTIFIER NOT NULL, [CreatedDate] DATETIME NOT NULL, [CreatedRemarks] VARCHAR(255) NULL, [DeletedBy] UNIQUEIDENTIFIER NULL, [DeletedDate] DATETIME NULL)GO ALTER TABLE [inventory].[PurchaseRequisites] ADD CONSTRAINT [PK_inventory_PurchaseRequisites_Id] PRIMARY KEY([Id])GO ALTER TABLE [inventory].[PurchaseRequisites] ADD CONSTRAINT [DF_inventory_PurchaseRequisites_RecordId] DEFAULT NEWSEQUENTIALID() FOR [RecordId]GO ALTER TABLE [inventory].[PurchaseRequisites] ADD CONSTRAINT [DF_inventory_PurchaseRequisites_RecordStatus] DEFAULT 1 FOR [RecordStatus]GO

Alter Table pos.salesinvoices Alter column customername nvarchar(max);

IF NOT EXISTS (SELECT 1 FROM [core].[PaymentModes] WHERE [TempId] = 8)BEGIN INSERT [core].[PaymentModes] ([RecordId], [Id], [Name], [TempId], [Description], [Tracker], [RecordStatus], [Tag], [CreatedBy], [CreatedDate], [DeletedBy], [DeletedDate], [CreatedRemarks]) VALUES (NEWID(), N'2526D549-DF55-47D9-9FE9-697B4C3C849E', N'Prepaid', 8, N'Prepaid', NULL, 1, N'Restaurant', N'00000000-0000-0000-0000-000000000000', CAST(N'2026-05-15T00:00:00.000' AS DateTime), NULL, NULL, NULL)END

ALTER TABLE [core].[Customers]Add AreaId UNIQUEIDENTIFIER NULLGOALTER TABLE [core].[Customers] ADD CONSTRAINT [FK_core_Customers_Areas] FOREIGN KEY([AreaId]) REFERENCES [core].[Areas]([Id])GO

INSERT INTO core.ledgerMappings VALUES (newid(),newid(),N'2526D549-DF55-47D9-9FE9-697B4C3C849E','Prepaid', '7E46C04B-95DD-4449-9325-6B172A259777', 'Prepaid A/C', 13, 'Sales', 8, 'Restaurant', null,null,1,null ,'00000000-0000-0000-0000-000000000000','2022-12-19 18:18:12.687', null, null, null, null, 0, null );

insert into account.accountgroups VALUES (N'14d91b43-6f24-48a3-ac07-79489ff12640', N'bc33972e-d091-4c44-9cbe-02f10915585e', 34, N'ad0698de-f9ec-4b10-8e6a-072707f1c332', N'Salary Payable', N'Salary Payable', 214000000, 100000, N'LIABILITIES -> CURRENT LIABILITIES', 1, NULL, NULL, 1, NULL, N'00000000-0000-0000-0000-000000000000', CAST(N'2026-01-27T11:23:39.703' AS DateTime), NULL, NULL, 7, N'L000001000004', 1, NULL)

SET DATEFORMAT ymd INSERT INTO core.AuditLogTypes (RecordId, Id, Name, TempId, Tracker, RecordStatus, Tag, CreatedBy, CreatedDate, DeletedBy, DeletedDate, CreatedRemarks) VALUES('7e56c463-5b42-4625-8780-2d7a8fe3f28a', 'e9b4e84f-cd80-4074-842c-ed8d20e76257', 'RoomRate', 32, NULL, 1, 'frontoffice', '00000000-0000-0000-0000-000000000000', CONVERT(DATETIME, '2026-05-27 17:30:04.990', 121), NULL, NULL, NULL)GO

UPDATE pos.QuotationDetailsSET ProductId = ISNULL(ItemId, '00000000-0000-0000-0000-000000000000');

ALTER FUNCTION [inventory].[FnGetStockValueUsingFIFO]( @productId UNIQUEIDENTIFIER, @unitId UNIQUEIDENTIFIER, @qty DECIMAL(38, 5), @fromDate DATETIME, @toDate DATETIME, @fiscalYearId UNIQUEIDENTIFIER, @branchId UNIQUEIDENTIFIER, @departmentId UNIQUEIDENTIFIER, @valueAsOnDate BIT = 0, @movementType INT, @isCallFromReport BIT = 0, @stockQuantity DECIMAL(38, 5) = 0)RETURNS DECIMAL(38, 5)ASBEGIN DECLARE @svAmount DECIMAL(38, 8) = 0; DECLARE @fStartDate DATETIME; DECLARE @offsetOut DECIMAL(38, 8) = 0; IF (@qty IS NULL OR @qty <= 0) RETURN 0; SET @fStartDate = (SELECT StartDate FROM core.FiscalYears WHERE Id = @fiscalYearId); /* total OUT already issued up to @toDate */ SELECT @offsetOut = ISNULL(SUM(st.Quantity), 0) FROM core.StockTransactions st WHERE st.RecordStatus = 1 AND st.FiscalYearId = @fiscalYearId AND (st.TransactionBranchId = @branchId OR @branchId = '00000000-0000-0000-0000-000000000000') AND (st.DepartmentId = @departmentId OR @departmentId = '00000000-0000-0000-0000-000000000000') AND st.ItemId = @productId AND st.UnitId = @unitId AND st.MovementType = 2 AND st.TransactionDate >= @fStartDate AND st.TransactionDate <= @toDate; /* if valuing an OUT row inside a report, exclude "this" qty from offset */ IF (@movementType = 2 AND @isCallFromReport = 1) SET @offsetOut = @offsetOut - @qty; IF (@offsetOut < 0) SET @offsetOut = 0; ;WITH InLots AS ( SELECT st.Id, st.TransactionDate, CAST(st.Quantity AS DECIMAL(38, 8)) AS InQty, CAST(ISNULL(st.Rate, 0) AS DECIMAL(38, 8)) AS Rate, SUM(CAST(st.Quantity AS DECIMAL(38, 8))) OVER (ORDER BY st.TransactionDate, st.Id ROWS UNBOUNDED PRECEDING) AS CumInQty, SUM(CAST(st.Quantity AS DECIMAL(38, 8))) OVER (ORDER BY st.TransactionDate, st.Id ROWS UNBOUNDED PRECEDING) - CAST(st.Quantity AS DECIMAL(38, 8)) AS PrevCumInQty FROM core.StockTransactions st WHERE st.RecordStatus = 1 AND st.FiscalYearId = @fiscalYearId AND (st.TransactionBranchId = @branchId OR @branchId = '00000000-0000-0000-0000-000000000000') AND (st.DepartmentId = @departmentId OR @departmentId = '00000000-0000-0000-0000-000000000000') AND st.ItemId = @productId AND st.UnitId = @unitId AND st.MovementType = 1 AND st.TransactionDate >= @fStartDate AND st.TransactionDate <= @toDate AND st.Quantity > 0 ), Priced AS ( SELECT Rate, TakeQty = CASE WHEN (@offsetOut + @qty) <= PrevCumInQty THEN CAST(0 AS DECIMAL(38, 8)) WHEN @offsetOut >= CumInQty THEN CAST(0 AS DECIMAL(38, 8)) ELSE (CASE WHEN CumInQty < (@offsetOut + @qty) THEN CumInQty ELSE (@offsetOut + @qty) END) - (CASE WHEN PrevCumInQty > @offsetOut THEN PrevCumInQty ELSE @offsetOut END) END FROM InLots ) SELECT @svAmount = ISNULL(SUM(TakeQty * Rate), 0) FROM Priced WHERE TakeQty > 0; RETURN CAST(ISNULL(@svAmount, 0) AS DECIMAL(38, 5));END

update core.Items set Quantity = '0.00';

UPDATE system.PagesSET Icon = CASE -- Reports WHEN Name LIKE '%Report%' OR Name LIKE '%Summary%' OR Name LIKE '%Statement%' OR Name LIKE '%Balance%' OR Name LIKE '%Profit%' OR Name LIKE '%Loss%' THEN '' -- Settings / Configuration WHEN Name LIKE '%Setting%' OR Name LIKE '%Configuration%' OR Name LIKE '%Setup%' OR Name LIKE '%Rule%' OR Name LIKE '%Numbering%' THEN '' -- Inventory / Stock WHEN Name LIKE '%Stock%' OR Name LIKE '%Inventory%' OR Name LIKE '%Consume%' OR Name LIKE '%Purchase%' THEN '' -- Sales / Billing WHEN Name LIKE '%Sales%' OR Name LIKE '%Invoice%' OR Name LIKE '%Bill%' OR Name LIKE '%Settlement%' THEN '' -- Customer / Guest WHEN Name LIKE '%Customer%' OR Name LIKE '%Guest%' OR Name LIKE '%Client%' THEN '' -- HR / Employee WHEN Name LIKE '%Employee%' OR Name LIKE '%Staff%' OR Name LIKE '%Attendance%' OR Name LIKE '%Leave%' THEN '' -- Finance / Accounting WHEN Name LIKE '%Ledger%' OR Name LIKE '%Account%' OR Name LIKE '%Voucher%' OR Name LIKE '%Tax%' OR Name LIKE '%Bank%' THEN '' -- Rooms / Hotel WHEN Name LIKE '%Room%' OR Name LIKE '%Reservation%' OR Name LIKE '%HK_%' THEN '' -- Menu / Restaurant WHEN Name LIKE '%Menu%' OR Name LIKE '%Kitchen%' OR Name LIKE '%Outlet%' THEN '' -- System / Admin WHEN Name LIKE '%User%' OR Name LIKE '%Role%' OR Name LIKE '%Access%' OR Name LIKE '%Permission%' THEN '' -- Default fallback ELSE '' ENDWHERE Icon IS NULL;

ALTER TABLE [frontoffice].[fo_g_guest] ADD [Pradesh] VARCHAR(100) NULL, [Zone] VARCHAR(100) NULL, [District] VARCHAR(100) NULL, [Palika] VARCHAR(100) NULL, [WardNo] INT NULLGO

ALTER TABLE core.itemsADD ShowInEcom BIT NOT NULL CONSTRAINT DF_Items_ShowInEcom DEFAULT (1);

Update system.Pagesset Icon=''where Name='Unit';Update system.Pagesset Icon=''where Name='Table';

ALTER TABLE [pos].[DeliveryBoyAreaAllocations] ADD CONSTRAINT [FK_pos_DeliveryBoyAreaAllocations_DeliveryBoys] FOREIGN KEY([DeliveryBoyId]) REFERENCES [pos].[DeliveryBoys]([Id])

ALTER TABLE core.ItemsADD CONSTRAINT DF_Items_QuantityDEFAULT (0) FOR Quantity;

alter table pos.deliveryboys add RefId uniqueidentifier null;

ALTER TABLE [pos].[CustomerGroups] ADD CONSTRAINT [PK_pos_CustomerGroups_Id] PRIMARY KEY([Id]);

ALTER TABLE [restaurant].[FreeSchemes] ADD CONSTRAINT [DF_restaurant_FreeSchemes_RecordId] DEFAULT NEWSEQUENTIALID() FOR [RecordId]

ALTER TABLE frontoffice.fo_resv_room_typesADD ArrivalDate DATETIME NULL, DepartureDate DATETIME NULL;

update system.Pagesset Icon=''where Name ='requisite';

ALTER TABLE [restaurant].[express]ADD [PaymentModeName] NVARCHAR(50) NOT NULL DEFAULT ('');GO