Hi,

I have stored image as binary data type and i want to generate as html content for report purpose.

thanks you for the quick reply.

I have done the colspan i want to do rowspan?

Hi,

Unable to paste sample table format here.

I want to generate html like below

--------------------------|

No | name | Department |

--------------------------|

1 |Ram ...

Hi All,

Thanks for your replies.

I want dynamic code.

Because every time I ll pass the different number columns so I can't hard coded. Kindly help me in this

Hi Centuries,

Thanks for your reply.

At present we r using the same method.

Please give us the solution to get data in dynamically.

Dear Jeff,

Thanks for solution.

I need one more modification.

Now we prepared the schedule for monthly basis. if i want to generate the schedule in quarterly basis.

Example: 1

No of months:5

Period : Monthly

Start...

Dear Jeff Moden,

Thank u so much for your solution. i have shared this with my team they also surprised for your solution. Really thank you so much. :Wow:

Hi All,

I find the difference.

declare @t as table (i numeric(5,0),j int)

insert into @t

values (null,null),(NULL,1),(NULL,NULL),(NULL,3)

select * from @t

select sum(i),sum(j) from @t

select sum(ISNULL(i,0)),sum(ISNULL(j,0)) from @t

select ISNULL(sum(i),0),ISNULL(sum(j),0) from @t

If table has no records...

Thank U so much Bro...