Ankur Vaish

Formula calculating calendar weeks (2015 vs 2016)

To be able to do weekly comparison report Year-to-Year with this weeknumbering it is necessary to create custom fields for the opportunity that calculates the Year and Week number for a given close date. Here is one solution using three custom formula fields. Field: Global Sales Report Weekday Description: Day 1 =…

Salesforce

Answered Jul 19, 2021 · 1.2K Views Read answer →

Trying to center button on the page

In order to align a button in the center. you need to use the Absolute Center class in slds positioned. For more information: https://www.lightningdesignsystem.com/utilities/alignment/ Here is How you can align lightning-button in Salesforce LWC? Sample Code: HTML:

Salesforce

Answered Jul 19, 2021 · 2.1K Views Read answer →

How do I list or search all the column names in my database in the SQL server?

You can use following query to list all columns or search columns across tables in a database. USE AdventureWorks GO SELECT t.name AS table_name, SCHEMA_NAME(schema_id) AS schema_name, c.name AS column_name FROM sys.tables AS t INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID WHERE c.name LIKE '%EmployeeID%'…

SQL Server

Answered Jul 12, 2021 · 1.5K Views Read answer →

How to get Rows to Columns (SQL Server)?

There are a couple ways that you can get sql server rows to columns. You can use PIVOT or you can also use an aggregate function along with a CASE expression, but in order to return multiple rows for each Type you'll need to create a unique value that you can GROUP BY. I'd recommend using a windowing function like…

SQL Server

Answered Jul 12, 2021 · 1.3K Views Read answer →

How to Detect sql server lock table or row?

You can try this to detect sql server lock table : SELECT db_name(rsc_dbid) AS 'DATABASE_NAME', case rsc_type when 1 then 'null' when 2 then 'DATABASE' WHEN 3 THEN 'FILE' WHEN 4 THEN 'INDEX' WHEN 5 THEN 'TABLE' WHEN 6 THEN 'PAGE' WHEN 7 THEN 'KEY' WHEN 8 THEN 'EXTEND' WHEN 9 THEN 'RID ( ROW ID)' WHEN 10 THEN…

Salesforce

Answered Jul 12, 2021 · 2.9K Views Read answer →

How to return the value from a query with SP_EXECUTESQL in a stored procedure?

You could use a table variable to hold the outcomes of the dynamic SQL call until you are ready to exit the stored procedure. Just before returning from the stored procedure, select the data from the table variable to get SQL server sp_executesql resolve. DROP PROCEDURE IF EXISTS dbo.MyProc; GO CREATE PROCEDURE…

Salesforce

Answered Jul 12, 2021 · 2.2K Views Read answer →

Is there any limit for IN results in SQL Server IN clause?

It depends. Seriously. That’s why the docs can’t be specific about where you will notice degradation in your environment. The solution is to just stop doing this (and worrying about it) and use a table-valued parameter. If you have the values in C# in such a way that you can build a comma-separated list as a string to…

Salesforce

Answered Jul 12, 2021 · 1.4K Views Read answer →

PapaParse - How to ensure Chunks processed in sequence. Apex response need to fire the next processing sequence

For that, you should have a queue for the data: dataInsertQueue = []; And papaparse should put those records in the queue: this.dataInsertQueue.push(results.data); this.pumpQueue(); Where pumpQueue() checks if there's any pending work and not already busy: pendingUpload = false; pumpQueue() { if(!pendingUpload &&…

Salesforce

Answered Jul 12, 2021 · 1.6K Views Read answer →

How to resolve the error, SQL Server INNER JOIN multi-part identifier could not be bound [closed]

To resolve this error: Use simple ALIAS select * from [SQ05].[mov].[dbo].[item_movement] AS imo inner join [SQ05].[mov].[dbo].[item_master] AS ima on imo.[item_id] = ima.[item_id]

Salesforce

Answered Jul 10, 2021 · 2.7K Views Read answer →

How to use the “required” attribute with a “radio” input field

SQL Server

Answered Jun 21, 2021 · 1.3K Views Read answer →

How to fix SQL Server error 18456? I am seeing a message “Login failed for user - Error 18456 - Severity 14, State 38”.

State codes and their meaning. How to Fix SQL server error 18456? Here are the steps you can follow to fix SQL server error 18456:Here are the steps you can follow to fix SQL server error 18456: Step 1: Log In with Remote Desktop Step 2: Run Microsoft SQL Server Management Step 3: Checking the Server Authentication…

SQL Server

Answered Apr 24, 2021 · 1.5K Views Read answer →

How to Copy Database in SQL Server, Wizard vs Backup / Restore Script?

Jobs are not stored in the user database, it is stored in the msdb database. If you wish to copy the exact same jobs from the previous server then, you should think of taking backup of msdb at the previous server and restore them on the new server provided few pre-requisites are met. CDW(Copy database Wizard) can't be…

SQL Server

Answered Apr 24, 2021 · 1.4K Views Read answer →