But we are using 2005 🙂

Hi Friend,

I got the solution...

DECLARE @FileName varchar(255)

DECLARE @ExecCmd VARCHAR(255)

DECLARE @y INT

DECLARE @x INT

DECLARE @FileContents VARCHAR(8000)

CREATE TABLE #tempXML(PK INT NOT NULL IDENTITY(1,1), ThisLine VARCHAR(255))

SET @FileName = '"\\1.128.1.14\school\mlecontent\LMS\Contents\995_Module_LESSON I\imsmanifest.xml"'

SET @ExecCmd = 'type...

Thanks gail for ypur help

Thanks Jack,

But I don't want to do it manually... So i need query which alters the SP in

all different servers at once..

Thank you friend

ok sorry

yes...you are right

In my examples there are two groups

Group1: Java,Perl

Group2: Java,PHP

If an Candidate has both java and perl knowledge and then he has the full knowledge of Group1 then he is...

Friend ,

Thanks for your Query,I tried and compare with the other possibilities that i have mentioned in post, but yours taking more reads than other possibilities.

Please check it once

he should have at least skills of one group...

Moe is winne because he has the skills PHP and java which belongs to Group 2

ALTER PROC PagingAndSorting

(

@SortColumnNVARCHAR(255),

@SortDirectionNVARCHAR(4) = 'asc' ,

@rowsPerPageINT = 10,

@pageNumINT = 1

)

AS

BEGIN

DECLARE @To AS INT ,@From AS INT

SET @To = @pageNum*@rowsPerPage

SET @From = @To-@rowsPerPage+1;

WITH OrdTab AS(

SELECT Id,Code,Description,Price,Lot,Uom,

ROW_NUMBER()...

Thanx Saurabh for ur reply

but i may contain this text also

@text='CAST(@Id nvarchar(100))

CAST ((@pageNo * PageSize - 1) NVARCHAR(100))

CAST (''&Parameter'' NVARCHAR(100))'

when i apply...

Thanx saurabh.dwivedy

The code is dynamic...

Occurence of CAST is not Known..... it may occur 100 times or 0 times

and the Variables inside the cast also not known...

and the code is...

HI davidandrews13

its different me for also

when i execute select * from [User] it displays 16153rows in right bottom corner of Result Grid

If go through the Table properties

its...