oops! lol

how :)??

is there a way that I can get the result in a table format like its displayed. I have to send the table in the email.

Yeah that is what I am reading now 🙂

It does work!

I am just trying to get my head around it now 😛

never used cross apply before.

Thanks 🙂

I hope this is right

CREATE TABLE [dbo].[LeaveEntry](

[LeaveId] [int] NOT NULL,

[Name] [varchar](50) NOT NULL,

[LeaveTypeName] [varchar](100) NOT NULL,

[StartDate] [datetime] NULL,

[EndDate] [datetime] NULL,

)

INSERT INTO LeaveEntry VALUES

(1, 'A','OUT','2013-08-12 00:00:00.000','2013-08-14 00:00:00.000'),

(2, 'B','LON','2013-08-13 00:00:00.000','2013-08-14 00:00:00.000'),

(3, 'C','OUT','2013-08-15...

cool..

Will update the sample data tomoro as I am finishing work now.

Cheers.

You are right

The sample data is very different.

I just wanted to give a hint ..how the table should look like..its not actual representation of the data..

hope it makes sense? Sorry...

Sorry

CREATE TABLE [dbo].[LeaveEntry](

[LeaveId] [int] IDENTITY(1,1) NOT NULL,

[Name] [varchar](50) NOT NULL,

[LeaveTypeName] [varchar](100) NOT NULL,

[StartDate] [datetime] NULL,

[EndDate] [datetime] NULL,

)

INSERT INTO LeaveEntry VALUES

(1, 'A','OUT','2013-08-29 00:00:00.000','2013-09-29 00:00:00.000'),

(2, 'B','LON','2013-08-29 00:00:00.000','2013-09-29 00:00:00.000'),

(3, 'C','OUT','2013-08-29 00:00:

There you go

Just an example how the data should look like

http://htmledit.squarefree.com/

for the html table

it was a silly typo :s...

@leavetypeid

its cool mate I found an article

http://www.codeproject.com/Articles/20815/Building-Dynamic-SQL-In-a-Stored-Procedure

d