Hi..I have the same requirement pls can u eloberate ur solution.I have list with 3 grids ,the text box should repeat on every page..

Thank you so much ..what if my table has more than 32,767 rows????????

i have tried bt no use:((

THANK YOU ALL:)

SWATH (9/22/2012)

---

I HAVE below TABLE with colum names proposer,approver,designation

PROPOSER APPROVER DESIGNATION

----------------------------------

kiran...

Can I use below function instead of DelimitedSplit8K() function

CREATE FUNCTION SPLIT

(

@RowData nvarchar(2000),

@SplitOn nvarchar(5)

)

RETURNS @RtnValue table

(

...

Hi Lowell

thank you

I am quite new to SQL SERVER.I didn't understand your solution for this. my question is where can i find delimitedsplit8k()

function?and how can i use it? could...

santa326 (9/1/2012)

---

Hi,

I have column in a table which needs to be ordered in an ascending order.

DECLARE@NumberTable TABLE( ItemNumber VARCHAR(50))

INSERT@NumberTable

SELECT'ABC-1702-XYZ' ItemNumber UNION ALL

SELECT'ABC-1727-XYZ'UNION ALL

SELECT'ABC-1729-XYZ'UNION ALL

SELECT'ABC-895-XYZ'UNION ALL

SELECT'ABC-2119-XYZ'UNION ALL

SELECT'ABC-1746-XYZ'UNION ALL

SELECT'ABC-900-XYZ'UNION...

select * from @NumberTable

ORDER BY CAST(REPLACE(SUBSTRING(ItemNumber,CHARINDEX('-',ItemNumber)+1,

CHARINDEX('-',REVERSE(ItemNumber))),'-',' ') AS INT)

we can do without using master.dbo.DelimitedSplit8K()

SELECT A.employeeid,A.employeename,B.categoryname,C.categoryname FROM

...