Post reply

Unique IO Colum in a view

  • August 14, 2006 at 3:28 pm

    #91243

    Hi

    I have a case in which I need to create a unique identifier in each record in a view. This could be like a line number. The client is a data analysis client that needs a unique identifier for each record

    The sources for the view are 3 other views.

    Any good T-SQL inputs will be appriciated.

    Thanks

    Bo

  • August 14, 2006 at 3:40 pm

    #654967

    You could include the NewID() function in the resultset to add a GUID column or if using SQL 2005, use the new ranking functions to add the equivalent of a unique line number to each row.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply