+2
Hi I am facing issues with the list view. Business requirement is to have a Serial no- sequence no based on the no of rows of data to be diplayed in list view.
I tried to use the expression along with th elist count it did not work.
I am looking for an output like this. Im going get list on the list No Add/Edit/Delete option. Please help if any one of you came across similar requirement.
+16
Hi
You need to create stored procedure to do that,
Here it is:
SELECT TOP (1000) Sequence = ROW_NUMBER() OVER (ORDER BY [CountryID]), [UserName], [CountryID]
FROM [dbo].[Vendors] ORDER BY Sequence;
wish it helps :)
Regards,
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.