Ashok Ramachandrappa

Sorting a alphanumeric data, A sample data is as below When i sort the data it looks like below I have modified the ORDER BY clause as shown below, and it returned the results in the proper order. (Note: The ID column is defined as varchar(20). So, I did the following to fix this issue: If ID is numeric, add 21 '0's in front of the ID value and get the last 20 characters If ID is not numeric, add 21 ‘’s at the end of the ID value and get the first 20 characters

SP_helptext issue has been resolved . CREATE PROCEDURE [dbo].[sp_helptext2] (@ProcName NVARCHAR(256)) AS BEGIN   DECLARE @PROC_TABLE TABLE (X1  NVARCHAR(MAX))   DECLARE @Proc NVARCHAR(MAX)   DECLARE @Procedure NVARCHAR(MAX)   DECLARE @ProcLines TABLE (PLID INT IDENTITY(1,1), Line NVARCHAR(MAX))   SELECT @Procedure = 'SELECT DEFINITION FROM '+db_name()+'.SYS.SQL_MODULES WHERE OBJECT_ID = OBJECT_ID('''+@ProcName+''')'   insert into @PROC_TABLE (X1)         exec  (@Procedure)   SELECT @Proc=X1 from @PROC_TABLE   WHILE CHARINDEX(CHAR(13)+CHAR(10),@Proc) > 0   BEGIN         INSERT @ProcLines         SELECT LEFT(@Proc,CHARINDEX(CHAR(13)+CHAR(10),@Proc)-1)         SELECT @Proc = SUBSTRING(@Proc,CHARINDEX(CHAR(13)+CHAR(10),@Proc)+2,LEN(@Proc))   END  --* inserts last line  insert @ProcLines  select @Proc ;  --edited here. (whe...