Search:

Hi I had the code indented, but when it posts, it goes back to align left?

Thanks, and sorry for the non indentations, I'm new to this. My SQL server won't allow (Alt+ F5) to debug.



"CREATE FUNCTION fn_year(
@year int
)
RETURNS money
as
begin

I'm trying to create a function in sql but its not working, which accepts a parameter of @year int
returns a data type of "money"
use the @year to return the amount from Ref_table where the @year...

The issue is with iCount > 5 , I just need to understand how can I get it to show if the sLT is less than 5 and if its over 5 than limits to show 5 names as maximum

Can anyone please help me with a Do while Not loop.
I'm very new to programming:

I need to check and print a list, and limit it to 5 names.

Do While Not rsP.EOF And iCount > 5
sLT =...