shahmed
Participant
Member since ‎03-06-2017

User Statistics

  • 83 Posts
  • 3 Solutions
  • 14 Kudos given
  • 5 Kudos received

User Activity

Being the core of a prosperous venture, it heavily hinges upon inventory management to be handled effectively. And this goal can be easy to achieve using effective management that encompasses three crucial aspects: Expenses reduction through optim...
With businesses that continue to grow and automation of processes is taking place, it is important to take a deep dive to gain insights into customer’s behaviour and its performance that can have a significant impact on the outcome on the business. S...
Hi Folks, I am trying to run the below query, which will provide my by-year opening, ins, outs, and closing stock. Once the user inputs the year 2020, it should provide the opening, ins, outs, and closing stock of 2020, then continue until the end ...
Hi Experts, I have this query which I running fine and pulling correct info. /* SELECT FROM [dbo].[OACP] T0 */ DECLARE @Year AS VARCHAR(4) /* WHERE */ SET @Year = /* T0.YEAR */ '[%0]' DECLARE @DateStart DATE DECLARE @DateEnd DATE S...
Hi everyone, I have this query running fine but what i am trying to achieve here is year as my filter instead of hardcoded year like this Year(T1.Docdate) = 2023. how can I do make this query work in a way that user gets an option to insert a yea...