🚀 go-pugleaf

Hi,

   I have been looking for a way to create an automatic counter in
order to increase a value within a select statement (don't want to
create a cursor and loop through)

   I am trying something like:

   SELECT getnextvalue() AS record_id, first_name, second_name FROM
names

   I know MSSQL supports for the function newid() - hence allowing
for:

   SELECT newid() AS record_id, first_name, second_name FROM names

   The problem is that newid() creates a UID and this I can not use. 
If MSSQL does not provide a built in function to obtain the next
available system id (as a counter), is there then a way to invoke a
stored procedure from the SELECT statement such as:

   SELECT sp_mycounter() AS record_id, first_name, second_name FROM
names

   or 

   SELECT (execute sp_mycounter()) AS record_id, first_name,
second_name FROM names

   Thank you.