Thank you SO much. These are indeed the results in the structure I need them. I'm going to research that syntax and see if I can teach  myself why it...

I apologize. I'm using SQL Server 2017 Standard Edition.

I have a similar problem to the original post, but I've to mimic the solutions provided here and still can't get what I need to achieve. I would really love...

That sounds like a really viable option! I'll give it a shot and report back on the results. Thanks so much, Phil!

It is not yet, but that's what I'm trying to get to. If I can just get my Dev & QA environments to be sync'd to my PROD again, I'm...

Phil, I added the @RowCount and @ErrorRowCount variables and set a derived column to add the two together and mapped it to my error table destination, but it's not working....

I think I may actually understand! I will give that a shot and check back in. Thanks so much!

I applied the scrip to the error output from the flat file...

Phil Parkin (8/3/2016)

---

lduvall (8/3/2016)

---

Would you share your code? I'd love any help. What I have now will already return me the entire line that failed but I have not parsed...

Would you share your code? I'd love any help. What I have now will already return me the entire line that failed but I have not parsed it into the...

Thanks for your help!

I'm trying to do this, and I'm concerned about the cost. I'm at the step where I'm creating the Windows 2008r2 server. In the pricing tier, it has Standard D1...

It is very timely that you posted this article. I just got dinged by my dba and told to remove all my INSERT INTO # and change them to SELECT...

Thanks so much everyone! I got it working using Lowell's script. Your help is very much appreciated!

I've reached out to the "wing" of the company that might tell me if they have disabled my predecessor's account & could temporarily re-instate it so that I could assign...