Sean Lange (9/9/2011)

---

ash0550 (9/9/2011)

---

I want to retrive data from a table dynamically.

Say it contains 3 rows name,age and gender

I want to retrieve name and gender through age.

Instead of using Select...

Thanks it worked

Jeremy-475548 (6/21/2011)

---

could be done mathematically too:

Declare @number int, @acc int

select @number = 219, @acc = 0

while 1=1

Begin

set @acc = @acc + @number % 10 ; set @number...

thank u

Its dam easy when u do that in Java or C. But I dont even get...

oops thats a bit stupid one. I didnt check the brackets properly.

Actually I am trying to design a query that would allocate the number of hours per month based on...

Could you tell me where did you do that multiplication I mean the Query

opc.three (6/16/2011)

---

It may not be "working" because only you can see your screen. Please provide sample DDL and DML as well as your expected...

As...

Ninja's_RGR'us (6/16/2011)

---

ash0550 (6/16/2011)

---

select BillOfMaterialsID,

case when BillOfMaterialsID <= 100 then 'Cheap'

When BillofMaterialsID between 101 and 500 then 'Medium'

When BillofMaterialsID between 501 and 1000 then 'HIGH'

When BillofMaterialsID between 1001...

select BillOfMaterialsID,

case when BillOfMaterialsID <= 100 then 'Cheap'

When BillofMaterialsID between 101 and 500 then 'Medium'

When BillofMaterialsID between 501 and 1000 then 'HIGH'

When BillofMaterialsID between 1001 and 3000...

Nope it is not working

Anyways thanks

oh thanks for that.

I got it too before I specified a comma so it was not showing up

Anyways thanks again

Thanks for...

wagnerbianchijr (6/9/2011)

---

SELECT UPPER('name') as Name

GO

=> http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=47718%5B/quote%5D

yup thannks

it worked