Thanks Dwain,

that 0.5 is the amount of leave an employee can take in a day either its half day or a full day.

i will take a try on this solution...

you can do it by using PIVOT table, but you need to sure what value of type 1 and type 2 you want to show as per group 1.

for more...

hi Dwain,

as per you solution its working fine, but when the no. of leaves are more then 12 its giving wrong data.

here i am giving sample input and output

CREATE TABLE...

Thank you very much dwain for your kind support.

with all due respect to CELKO going forward i will follow complete process.

Thanks,

Ghanshyam

Thanks for your reply, by using this also i am not getting the desired result its throwing error.

i used this

="Page " + CStr(Globals!PageNumber) + " of " + CStr(Globals!TotalPages)

it is...

Thank guys for your reply's

here are the details

we are deleting based on join because in base table , incremental records needs to be deleted.so we are using base table join...

Thanks daniel for your reply,

you are correct i was having row grouping in my report that's why details tag was coming, after removing grouping its disappears 🙂

thanks..

The above thing you have mentioned i don't have anything, and made a lot of changes so its difficult for me to undo it, isn't there any process that i...

thanks guys for ur reply.

select registerNo,CourseID,ExtMark from table where Extmark=96 order by RegisterNo

follow these links to get a clear idea of working of indexes

http://www.simple-talk.com/sql/learn-sql-server/sql-server-index-basics/

http://www.sqlteam.com/article/sql-server-indexes-the-basics

i think u need to convert SC.col1 as decimal. it might be an integer column

would you please post your desire output what you want,with your proper DDL

I think instead of making us guess its would better to post your DDL with some sample data and your desired output. 🙂

Hi as per the information provided by you, just a simple update will make all the values as null

update table set email=null

but not sure what exactly your requirement is,...