Viewing 15 posts - 1 through 15 (of 121 total)
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...
December 18, 2012 at 11:06 pm
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...
December 18, 2012 at 11:35 am
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...
December 18, 2012 at 5:07 am
Thank you very much dwain for your kind support.
with all due respect to CELKO going forward i will follow complete process.
Thanks,
Ghanshyam
December 17, 2012 at 7:44 am
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...
July 13, 2012 at 4:19 am
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...
June 28, 2012 at 11:43 pm
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..
May 15, 2012 at 7:36 am
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...
December 23, 2011 at 12:01 am
thanks guys for ur reply.
November 29, 2011 at 6:02 am
select registerNo,CourseID,ExtMark from table where Extmark=96 order by RegisterNo
November 27, 2011 at 9:51 pm
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
November 21, 2011 at 10:09 pm
i think u need to convert SC.col1 as decimal. it might be an integer column
November 3, 2011 at 4:25 am
would you please post your desire output what you want,with your proper DDL
October 27, 2011 at 10:42 am
I think instead of making us guess its would better to post your DDL with some sample data and your desired output.
October 27, 2011 at 10:25 am
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,...
October 27, 2011 at 10:22 am
Viewing 15 posts - 1 through 15 (of 121 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy