Dear Jeff,

Sorry for the late response, the solution you provided worked great. Thanks a lot :-):-)

Thanks GilaMonster 🙂

Hi Perry,

Yes, we have. Kindly tell me what should i do ?

Hi,

The recovery model is FULL

@ Koen Verbeeck - The output will display the details so that each weekday has a column.

Below is the sql i've managed to come out with.

select Sunday,...

Thank you so much Mark 🙂

I have made use of your code 🙂

chornung,

would be easy for us to suggest if you provide us some test data along with table structure.

Hi Nevyn,

Thanks for the guidance.

//Was that meant to be "inner join EMaster a on a.sid = b.salesofficerid"??

Yes. Thanks for pointing it out 🙂 . I've corrected it

Hi,

Thanks Jeff.

Below is the script + data

create table Tenure

(

sno int identity(1,1),

EName varchar(20),

DOJ datetime default getdate()

)

Note: there is no column avaliable mentioning date of resignation or office. So the...

Hi rjohal-500813,

Thanks for the reply. Forget to mention one thing; the tenure of a person ends when the next person joins the office.

Check the data below:

snoENameDOJ

1axx2008-03-08 18:05:23.783

24ew2009-03-08...

Hi Lynn Pettis,

Thanks for the response. 🙂

I'll try it.

Bhuvnesh, thanks for the response. 🙂

the snippet you provided shows the amount sans tax in a separate row, but i need the tax to be shown in a separate row.

Hi DanielG-259128 and wschampheleer,

Thank you for so much of info and advice 🙂

Sree

Hi Arun,

Thanks for the snippet it works 🙂

Hi sav-457805,

Thanks for the code. But, the SNo forms to be a sequential across all the CCID. 🙂

Wow :Wow: really amazed by the overwhelming response from the Gurus. 🙂

Lutz, 80 % is mentioned juz for a limit to check against. :-). Thanks for the care u...