Jeff - Your links worked also and i will definitely give that a try now that IO know I should be able to do the restore.

You also may be onto...

Thank you Sue that worked.

This is certainly one way to drive users away from SQL 2016, make it hard to use the updates.

It might help if I just include what I am trying to achieve. I am trying to restore a copy of our DB from our cloud vendor and when I...

Chris

I knew there was something about that damned statement that bothered me but I could not see it (i.e.  forest for the tress). I was soo hung up on the...

That's it. Its difficult to modify DDL and get everything. I'd rather post the original/unaltered but can't do it.

There is an ACCT table and just like the CHILD_TABLE if you...

I used the Script to New Window feature in version of SQL Mgt Studio we have access to in the vendors cloud to quickly generate the DDL. I changed only...

John Roberts- Not sure about the errors, I don't get these when I use any of the code I've included. The 2 CREATE TABLE statements and the DELETE all work.

Thanks

John

Assuming I understand correctly you are in agreement with me in that assuming the setup of the 2 tables I've shown the included DELETE should never find anything to delete...

Just wanted to let everyone know who has taken the time to reply that I figured it out with everyone help. What had me hung up with PIVOT was the...

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 5 years, 1 month 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 5 years, 2 months ago by  YSLGuru.
• This reply was modified 5 years, 2 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...