Thanks Mack

Well, I was really hoping someone had a suggestion for me here. What I ended up doing was creating an outer table, and, for rows that had vertically spanning...

You and me both. A little change can actually make the SSRS output worse. Thanks for the feedback.

So I am still facing this issue. I have made some major changes, and now the report is one stand-alone report, with no use of sub-reports.

As before, when I...

I'm of the same thinking, but that's not what I'm seeing. There are definite differences between the output rendered in RB3, RS, and by print. So far I...

So it turns out that each of these solutions is missing something, it's either the fraction part sometimes comes out incorrect, because it wasn't adjusted as I was doing in...

I saw that you had made an extremely compact version. Haven't had time to check it out yet, but it looks pretty good at a glance.

Thanks for all the...

Oops, the s_difference+1 is incorrect. That should be been just s_difference. The minus is correct.

I had also forgotten to adjust the seconds. When the earlier date has a larger fractional part than the later date, as well as adding the fractional part to...

Ok, that's interesting. I didn't see the first of these, and so I sent another version, thinking I'd forgotten, somehow, to click Post. Then I realized I had...

I forgot to mention that the first part of my case statement checks to see if the nsFraction is negative. This can happen even though the overall first date...

Actually, I did forget to mention that my case was also taking care of the case where the fraction of the first date is larger than the fraction of the...

That's great!!! Thanks. I had to make a slight change because if the nsFraction part is small, when it is cast to varchar, it should have leading zeroes...

Sorry about that. Below, you can see that I have a source and a destination table, with names changed to protect the innocent. The source table has two...

Ok, so this isn't enough for what I need. Here's what I'm actually trying to do. I am writing a SQL script as a conversion process from an...