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:
Re: Error when using WHILE Function in selecting on sQL server script
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"
Re: Error when using WHILE Function in selecting on sQL server script
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..
Re: Error when using WHILE Function in selecting on sQL server script
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.