Help

• aysegul

  Right there with Babe

  Points: 778

  More actions

  December 19, 2007 at 3:06 am

  #177646

  Hi,

  I need help.

  I try to write a function as below.

  But i doesn't return anything.

  What's the wrong?

  thank you very much for helps.

  ******************************************************

  Create FUNCTION months()

  RETURNS @ay TABLE (ad nvarchar(100),deger int,yil int)

  AS

  BEGIN

  declare @sayi int

  set @sayi=1

  while @sayi>12

  begin

  INSERT INTO @ay

  select dbo.GetMonthName(@sayi),@sayi,Year(GetDate())

  set @sayi=@sayi+1

  end

  RETURN

  END

  ***************************************************************

• Leo Mepham

  Ten Centuries

  Points: 1045

  More actions

  December 19, 2007 at 3:33 am

  #761329

  Your loop is wrong, you set the variable to be one - Then you say 'While variable is GREATER THAN twelve'! :hehe:

  Also, I assume your dbo.GetMonthName function is OK?

  Best wishes - Leo