الـجـروب الـخـاص بـالـمـنـتـدي Silkroad4arab Facebook | Official Group 

table :USE [SRO_VT_LOG]
GO

/****** Object: Table [dbo].[Rate] Script Date: 02/03/2014 00:16:41 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Rate](
[Rate] [int] NULL
) ON [PRIMARY]

GO

procdures
Declare @Rate2 int
if(@JobID = '59717')
begin
SET @Rate2 = (SELECT TOP 1 * FROM dbo.rate2 ORDER BY NEWID())
end
IF (@Rate2 = '1')
begin
exec SRO_VT_SHARD_X.dbo._ADD_ITEM_EXTERN @charname,'ITEM_ETC_ARCHEMY_MAGICSTONE_ASTRAL_10', 1,0
End
Else
if @Rate2 = '2'
begin
exec SRO_VT_SHARD_X.dbo._ADD_ITEM_EXTERN @charname,'ITEM_ETC_ARCHEMY_MAGICSTONE_ASTRAL_11', 1,0
End
Else
if @Rate2 = '3'
begin
exec SRO_VT_SHARD_X.dbo._ADD_ITEM_EXTERN @charname,'ITEM_ETC_ARCHEMY_MAGICSTONE_ASTRAL_12', 1,0
End
Else
if @Rate2 = '4'
begin
exec SRO_VT_SHARD_X.dbo._ADD_ITEM_EXTERN @charname,'ITEM_ETC_ARCHEMY_MAGICSTONE_ASTRAL_13', 1,0
End

bos ya kber koll al anta 3yzo ank t3ml table w t3ml procdures fe al addtimedjob aw addlogitem as u like w t7ded fe al procdures ano howa y5ter select top 1 from al table fhmny for example :
SET @Rate3 = (SELECT TOP 1 * FROM SRO_VT_LOG.dbo.lottery ORDER BY NEWID())