Using my DUMMYTABLE as the example which I just edited because I realized that the last 4 inserts did not use a value of 4 for hEntity

What I'm trying to...

• This reply was modified 6 years, 6 months ago by YSLGuru.

Let me ask you this then. Is there another/better way to handle transposing rows into columns as of SQL 2014  or higher or is PIVOT still the way to go...

I didn't really think that was necessary since I'm asking a generic question about transposing with Pivot and I also don;t yet have access to the DB where this info...

• This reply was modified 6 years, 7 months ago by YSLGuru.
• This reply was modified 6 years, 7 months ago by YSLGuru.

Thanks to all of you who have taken the time to share your thoughts on this. To be clear this code is not something I have any control over, its...

SSSR is just a terrible report designer in how it works. I can not for the life of me understand why they opted for the table/matrix/tablix style of design instead...

Thanks. I have Visual Studio setup to work with RDLC files but I'm hoping to find some way to easily or semi easily move between RDLC and RDL because there's...

Scott - unfortunately this is hosted and we don;t have the ability to modify the DB structure without risking breaking support for the software that uses the DB so I'm...

UPDATE:

It was no simple matter to put together everything necessary to make this work but I did and sure enough it did work. We still don't have an exact time...

I'm just as puzzled by this as well but the only code I did not include was the creation of the #TRANSDETAIL_TEMP temp table and the 100 plus inserts into...

Thanks to everyone that chimed in to help.  I finally figured out the missing piece.  Hindsight is always easier then foresight so this now may sound obvious but what was...

Thank you for taking the time to post this but they still don;t help.  The second link doesn't work.  The first does work but the directions seem to start after...

Ok thanks for the input Steve.  The one good bit about this is that when performance goes to SHFT it will be ne the Vendor to explain to our CFO/CEO...