I used to utilize this feature a lot in 2000 but have never used it in 2005. Can anyone give me step-by-step instructions for doing so please? I need to step into the SP on the server from a VB.net WinForms app on my client computer in Visual Studio 2008 Professional edition.
Currently the breakpoints in the SQL stored procedure are hollow circles with the message "the breakpoint will not be currently hit" "no symbols have been loaded for this document".
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below:
PERCENT_RANK() function will returns the percentage value of rank of the values among its group.
PERCENT_RANK() function value always in be…