SQL Query Executor - SqlQueryExecuteApp

ALTER TABLE inventory.PurchaseRequisites ADD RequisiteReferenceId UNIQUEIDENTIFIER NULLGO

ALTER TABLE core.Issues ADD PurchaseId UNIQUEIDENTIFIER NULLGO

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

update system.Pagesset Icon=''where Name='account posting';

alter table restaurant.OrderTickets Add CancelledDate DateTime null;

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

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;

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

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 restaurant.Bookings ADD CustomerName NVARCHAR(255) NULL, CustomerPan NVARCHAR(50) NULL, CustomerContactNumber NVARCHAR(50) NULL;

alter table restaurant.OrderTicketItems add HasAddOn bit null;

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

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;

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

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 core.ItemsADD CONSTRAINT DF_Items_QuantityDEFAULT (0) FOR Quantity;

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

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

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

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

ALTER TABLE restaurant.OrderTicketItems ADD ParentOrderItemId UNIQUEIDENTIFIER NULL, IsAddOn BIT NULL;

UPDATE system.PagesSET Icon = ''WHERE name = 'PrinterSetup';

update system.Pages set Icon='' where Id='5729C670-58E1-46E6-921A-63666EEDB221';

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

update system.Pagesset Icon=''where Name='purchase receipt';

alter table core.ItemSKUs add BoxNo varchar(225) null;

alter table [core].[Items] add ProductGroupId uniqueidentifier NULL;

alter table [core].[Items] add ShortDescription nvarchar(max) NULL;

alter TABLE [restaurant].[RoleWiseDiscounts]add [BookingReport] [bit] NULL;

alter table core.customers add CountryName varchar(max) null;

alter table core.customers add Guide varchar(max) null;

alter table restaurant.Express add VoidRemarks varchar(255) null;

CREATE TABLE core.CrossoverCompanyInfos( Id UNIQUEIDENTIFIER NOT NULL PRIMARY KEY, Name NVARCHAR(255) NOT NULL, Address NVARCHAR(500) NULL, Phone NVARCHAR(50) NULL, SupportEmail NVARCHAR(255) NULL, Website NVARCHAR(255) NULL, TutorialLink NVARCHAR(255) NULL);

alter table restaurant.RoleWiseDiscounts Add ItemvsMenuReport bit null;

ALTER TABLE restaurant.Tables ADD IsApprovalRequired BIT NULL;