Thanks to the solution :-):-):-).

How can I avoid sending the report if no data is fetched?

I got the solution.

I had to add "'<ALIGNMENT TYPE>' AS 'td/@align'," before each td as highlighted in the code shown below:

DECLARE @tableHTML NVARCHAR(MAX) ;

SET @tableHTML =

N'<H1>Work Order Report</H1>' +

N'<table border="1"...

I need to align td as i require. Like some column with right align and some column with center align ans so on.I tried your solution but doesn't work for...

Thanks a lot for the valuable solution!!!!!!

The multiple tables are present on one server & the reporting table is on a different server. Can I update from one server to another. Both the servers are on...

I have another problem.

I need to do this task on different servers. The query fetches the data from my Production Server & I need to update the Table created...

Thank you Guys for the timely advise.

:-):-):-):-)

Thanks for the help provided. I figured out the problem. There was data type mismatch , hence the issue.

I have another issue:

I want to update only those values from...

Thanks a looooooooooooot!!!!!!!!!! for the timely help. Your code worked like a charm!!!!!!!!:-):-):-):-):-):-)

Thanks a lot for the valuable suggestion:-):-):-)!!!

Thanks a looooooooooooooot!!!!!!!!!!!! the help provided.:-):-):-):-):-):-)

What should be the ideal value for p.pagecount ????

Will dropping the indexes & recreating them once again be of any use?

Hi,

I did create a clustered index which did bring down the fragmentation level but again fragmentation level has started growing as shown below:

DatabaseIdIndexIdFragmentationPercent

72287.5

72478.26

72366.67

72164.29

71162.5

7957.14

72850

7144.44

72943.75

73043.75

72743.75

72543.75

72631.25

I rebuild the indexes using the following script...

Thank you!!!!!!!!!!!!!