here is my whole procedure 😉

:hehe:

CREATE PROC sp_Display

@NumberId INT,

@AlphabetID INT

AS

DECLARE @Loop1 INT, @Loop2 INT,@Loop3 INT, @Loop4 INT, @NTimesUsed INT, @ATimesUsed INT,@AlphaValue CHAR(1), @alphaid INT, @NumID INT, @NumberValue INT

SET @NumberValue =...

yes yes, i am still here :D, check looking at all the solutions, i used this peace of code in my SP and it seems to be working just the...

Hey Hey, SSC Veteran

I finally got it working, Thanks SSC Veteran,

The Problem was That I never had any values for the NumberTimesUsed Column :hehe::hehe:

But Once It has This...

yeah it does, but its way to complicated and its not really what I am looking for, There must be an easier way of doing this, I just cant think...

karthikeyan, I need to create a view outer that? is there no easier way :hehe:

My code Is On the first page,

And I dont think that list will get updated if...

sorry sorry, 😀 my mind is in 2 places here

Text ...

SSC Veteran

No its still not right, this has been bugging for the whole morning,:)

Your returned result

numberValue numberTimesUsed

----------- ---------------

1 ...

Hey Hey TenCent, Nope Not right. 😀

NumberValue NumberTimesUsed

----------- ---------------

4 0

3 ...

I gave it a try and it does not seem 2 work,

RESULT

Amt numbervalue

----------- -----------

1 ...

karthikeyan

I will Give that a try now, but is it just me or is there no loops?

Hey, I need the table because one(1) is not the only value in the table, And the User Can only choose a number from the table else it gives an...