Hi,

I tried but its not working. Since I have two tables, I am confused on how to pivot them. I have attached the data base scripts as requested by you....

Hi Lutz,

Thanks a lot for your idea. I will create a computed column using my first character of my value.

Hi,

The values comes from the database, so i will not be able to hardcore them.

Is there any way to get the desired output?

Hi Chris,

Thanks for your workaround.

Your code has helped me to solve my problem with few changes.

Hi Chris,

I cannot create rows for the missing dates or change the date as its not a permitted- one. the data comes from another system and adding or changing spoils...

Hi Lutz,

Thanks for your reply.

When I ran your Query, i'm getting the rank value as 1 for all the values.

Below is the query that I used.

With T(PostalCode, Cnt, Ranking) ...

Hi,

Thanks for your suggestion. OFFSET FETCH Clause supports only 2012 and later. I want to perform this operation in earlier versions of SQL too...

hi,

i tried sending the report to gmail and it worked fine. I did not find any data mislocated but i am not able to have the table colors and formattings....

Hi,

i am sending this HTML output as a web report to email. The query that i use to send email is as follows

exec msdb.dbo.sp_send_dbmail

@profile_name = 'SmarterMail',

@recipients =

Hi LutzM,

Here is the XML Output for .

The HTML output of the query is

The table def is

NameOwnerTypeCreated_datetime

training_reportdbouser table53:55.5

Column_nameTypeComputedLengthPrecScaleNullableTrimTrailingBlanksFixedLenNullInSourceCollation

EMPLOYEE_NAMEvarcharno50 ...

Hi LutzM

Here is the XML output of the query

select

EMPLOYEE_NAME,

Sum(case when [PASTDUE>60<90] is null then '0' else [PASTDUE>60<90] end),

Sum(case when [PASTDUE>90<120] is null then '0' else [PASTDUE>90<120] end),

Sum(case when...

Hi Lutz,

previously i had the coding without HTML Tag and i had the same output. below is my HTML tag

declare @query nvarchar(max)

set @query =

'<style type = ''text/css''>' +

'table...