Error when using WHILE Function in selecting on sQL server script

hi guys i have this code,,

Code:

---

declare @n int
set @n = 1
SELECT    TOP 100 PERCENT ID, purchase_id, supp_add_mat_id, mat_code, asset_no, qty, require_by, require_date, require_desc, status, pr_detail_asset,
                      scheduled,
                while @n <= 31
                begin
                        CASE WHEN datepart(day, require_date) = @n THEN qty ELSE '0' END AS @n
                set @n = @n+1
                end
FROM        dbo.t_pr_details

---

but the code is error coz i use the While function when selecting a data,,
plz help..:confused:

Quote:

---

Originally Posted by ryanframes

...
but the code is error coz i use the While function when selecting a data,,
plz help..:confused:

---

Then remove (get rid of) this "While function"

Quote:

---

Originally Posted by VictorN

Then remove (get rid of) this "While function"

---

no i want to use WHILE function when selecting a record set..
but when i use it, it always shows error..

Quote:

---

Originally Posted by ryanframes

no i want to use WHILE function when selecting a record set..

---

Where in the docs did you see WHILE loop within the SQL SELECT ... FROM query?

Quote:

---

Originally Posted by ryanframes

but when i use it, it always shows error..

---

It only means that either it is not allowed at all or you are using it wrong.