USE [Dorsa_OPR]

GO

/****** Object:  StoredProcedure [dbo].[testChart]    Script Date: 8/6/2024 11:43:32 AM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

— =============================================

— Author: <Author,,Name>

— Create date: <Create Date,,>

— Description: <Description,,>

— =============================================

ALTER     PROCEDURE [dbo].[testChart]

@userName nvarchar(100) = null,

@orderBy nvarchar(100) = null,

@takePage int = 50,

@skipPage int = 0,

@test1 nvarchar(100) = 2000

AS

BEGIN

DECLARE @Upper INT = 100000;

DECLARE @Lower INT = @test1;

CREATE TABLE #result(Mon NVARCHAR(4000), Amount INT)

insert into #result (Mon, Amount) VALUES(‘مهر’, ROUND(((@Upper – @Lower -1) * RAND() + @Lower), 0))

insert into #result (Mon, Amount) VALUES(‘آبان’, ROUND(((@Upper – @Lower -1) * RAND() + @Lower), 0))

insert into #result (Mon, Amount) VALUES(‘آذر’, ROUND(((@Upper – @Lower -1) * RAND() + @Lower), 0))

insert into #result (Mon, Amount) VALUES(‘دی’, ROUND(((@Upper – @Lower -1) * RAND() + @Lower), 0))

insert into #result (Mon, Amount) VALUES(‘بهمن’, ROUND(((@Upper – @Lower -1) * RAND() + @Lower), 0))

insert into #result (Mon, Amount) VALUES(‘اسفند’, ROUND(((@Upper – @Lower -1) * RAND() + @Lower), 0))

select Mon, Amount from #result

END