Viewing 10 posts - 1 through 10 (of 10 total)
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..
January 6, 2016 at 11:12 pm
Thank you so much ..what if my table has more than 32,767 rows????????
December 12, 2012 at 6:12 am
SWATH (9/22/2012)
PROPOSER APPROVER DESIGNATION
----------------------------------
kiran...
September 22, 2012 at 3:36 am
Can I use below function instead of DelimitedSplit8K() function
CREATE FUNCTION SPLIT
(
@RowData nvarchar(2000),
@SplitOn nvarchar(5)
)
RETURNS @RtnValue table
(
...
September 6, 2012 at 6:14 am
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...
September 6, 2012 at 1:00 am
santa326 (9/1/2012)
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...
September 5, 2012 at 6:47 am
select * from @NumberTable
ORDER BY CAST(REPLACE(SUBSTRING(ItemNumber,CHARINDEX('-',ItemNumber)+1,
CHARINDEX('-',REVERSE(ItemNumber))),'-',' ') AS INT)
September 5, 2012 at 6:42 am
we can do without using master.dbo.DelimitedSplit8K()
SELECT A.employeeid,A.employeename,B.categoryname,C.categoryname FROM
...
September 5, 2012 at 4:43 am
Viewing 10 posts - 1 through 10 (of 10 total)