How can I take values From a table which is output of a function in a stored procedure

This is a statement inside a stored procedure which gives a table output which contains date dt:

SELECT [Dt] 
  FROM dbo.fnGetDatesforWeekDays(@dafromDate, @datoDate, @WKDAYS) AS DAT

How can I take those date values one by one开发者_StackOverflow社区?

If you need to process them one by one you'll need to use a cursor and loop through the cursor:

DECLARE @Dt DATETIME

DECLARE date_cursor CURSOR
FOR
SELECT [Dt]  
  FROM dbo.fnGetDatesforWeekDays(@dafromDate, @datoDate, @WKDAYS) AS DAT 

OPEN date_cursor

FETCH NEXT FROM date_cursor INTO @Dt

WHILE @@FETCH_STATUS <> -1
BEGIN
--do your processing here

FETCH NEXT FROM date_cursor INTO @Dt

END

CLOSE date_cursor

DEALLOCATE date_cursor

Just do whatever you want to do with each of those dates where the comment is and you're good to go.

Yes, you can (cursor, loop, ..) .. but you shouldn't. Please post what are you trying to accomplish and most likely there is a better, set based solution.