Hi Brian Kelley,

Thank you so much for your reply! Just Y'day i got this site through googling... and found...

Or is there any T-SQL Query to find on which port a particular instance is running? I checked in sysrpocessed for one SPID it shows which protocol it has used...

Hi Kevin,

xp_cmdshell is diabled in production servers we cannot use this... 🙁

Hi Lester ,

Yes that is what i have done... but as said.. SQL Server stops execution and select query level itself...it is not executing next line itself... Hope...

Hi Kevin,

I need to write SP compatible for SQL 2000 so i cannot use TRY/CATCH ... 🙁

Hi Mitesh and Others...

The rapidshare site is blocked for me... Can someone send me the zip file to

Sakthivel[dotu]Chidambaram[atu]gmail[dotu]com

Hi,

First thanks for your detailed reply...

What shall we do when there is a NULL or a 0 value in any of the Firstyield row? Then...

Thanks Jeff...I will getback to you after reading and understanding and testing this solution...Many Thanks!!

Regards,

Sakthi

If i have only one employee record then below is the output of the query...

http://www.nopaste.com/p/aUDjixI6d/txt

But same employee table if i have 5 records then this is the output

Hi Ian,

       The same logic i had tried already but how can we know that employee was absent for somedays? The query will return only present days...This result i just...

I created another table with 1,2,3,....31 as values for one column and i tried to put left outer join like the below

http://www.nopaste.com/p/a7EK0M81gb/txt

Here cms_date is the table which...

Hi Ram,

        Thanks for expressing your point of view...Let's conclude this way...This Post is a spam for some and good for the rest. So 50-50...

Regards,

Sakthi

Thanks Ron....For Understanding the things and explaining the things...

Hi Andrew,

           I agree with your points. Let it be spam for you. I beleive atleast few 100's will love this...Because we people are away from our homeland and this...

Hi Sugesh,

       My DB is SQL 2000 and in Import/Export i dont have any export to xml option...it has only excel,csv,access....Atleast xml is ok for me....Do i need to something...