Thank u friend. my requirement is I want show batch wise Empnos in grid. this is my Requirement.

yes i want to show a Empnos batch wise .

yes i am not getting.

Please help me.

Regards

Swamy.

yes the rows are dynamic , but image types should be fixed.

yes there are always two image types so many customers.

Hi Try Below query .

Select studentID ,SUM(subjectMark) as TotalMarks FROM (

Select * ,ROW_NUMBER() over(partition by studentID order by subjectMark desc) as rowno

from tstudents)as Data Where Rowno < 5...

Hi Try Below query .

Select studentID ,SUM(subjectMark) as TotalMarks FROM (

Select * ,ROW_NUMBER() over(partition by studentID order by subjectMark desc) as rowno

from tstudents)as Data Where Rowno...

thank u for u r replay

.

my table name tEmployee i write shortly tEmp.ok.

one more thing , my problem solved.

when i am inserting time i passed like nvarchar value

ex:

Insert...

try this query it may works.

Select * , (select max(gps_datetime) as maxdate from gpsdata_history where gps_datetime >'07/13/2008' and gps_datetime<'07/14/2008' and analog2='stepii' and registrationno =data.registrationno ) from ...

Thank u So much . it is working.:cool:

Declare @vc as varchar(max)

Select @vc = COALESCE(@vc + ',','') + EmployeeName from tEmployee

Select @vc

Regards

swamy.

Thank u.

Actually i donot know the rows in the temployee table

Hi

i have a table

tEmployee Column is Employeename

tEmployee

----------

Values

Employeename

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

scottt

Tiger

Huli

abrash

...

....

....

.....

upto end of rows

actually

select 'scott' union all

select 'Tiger' union all

select 'Huli' union...

Thank u.

yes first i am using The function only but to split the clientid

i am using the temp tables but in a function we cant use the temp table...

How to capture error's by using stored...

Thank u ,

How to capture the error's in User Defined Functions in SQL-Server.

Regards

Swamy.

Thank u so much

rbarryyoung

ok it is Working .

Regards

Swamy.