-
July 23rd, 2012, 12:44 AM
#1
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..
Last edited by ryanframes; July 23rd, 2012 at 12:57 AM.
-
July 23rd, 2012, 05:31 AM
#2
Re: Error when using WHILE Function in selecting on sQL server script
Originally Posted by ryanframes
...
but the code is error coz i use the While function when selecting a data,,
plz help..
Then remove (get rid of) this "While function"
Victor Nijegorodov
-
July 23rd, 2012, 08:06 PM
#3
Re: Error when using WHILE Function in selecting on sQL server script
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..
-
July 24th, 2012, 12:55 AM
#4
Re: Error when using WHILE Function in selecting on sQL server script
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?
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.
Victor Nijegorodov
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|