By golly, does this look correct?

UpdateIARTS..PWDPermitConversionData2

Set

ConversionStatusPrev1 = Case When (Select 1 From PermitsInserted p2 Where p2.PWDPermitConversionDataID = p.PWDPermitConversionDataID And p2.RecordIndicator = 1) = 1 Then 1 Else Null End,

ConversionStatusPrev2 =...

lmu92 (4/16/2010)

gregory.anderson (4/16/2010)

It might be required to catch the [PWDPermitConversionDataID] values and the column that failed for the rows holding bad values (using the OUTPUT clause applied to the error...

It might be required to catch the [PWDPermitConversionDataID] values and the column that failed for the rows holding bad values (using the OUTPUT clause applied to the error checking statement...

I've been racking my brain on the very last step of this "previous" permit section...with just a yes or no, is it even possible to update the ConversionStatusPrevX fields with...

It's simply bad coding habit together with lazyness anda good portion of luck...

The reason why the code doesn't fail is that there are no duplicate column names used. So, to...

That example of the cross apply stuff makes it look so easy. Once the article mentioned it was just like a method in programming, it kind of clicked for me.

If...

Oh, by the way, I let my old version run and finish while I/we've been working on the new set-based solution...the only version finished in 11 hours, plus 18 hours,...

Well, you were closing to making it unique. The combination of PermitNumber and PWDPermitTypeID would...

The update of the conversionstatus statement isn't working how I want because it updates ALL of the records even though only 557000 of the 680000 are getting inserted (because of...

Again, WOW!

When I got to work this morning, MY version was still running and SSMS said the run time was at 18 hours, and that started at half-way through the...

Thanks WayneS for the links...pretty straight-forward once I know what they do...

I just created duplicate PWDPermit, PWDPermitConversionData, and PWDPermitConversionErrors tables so that I could compare the results. Just ran the...

Side-tracked by production issues right now, I'll let you guys know when I get back to this....

lmu92 (4/14/2010)

here's part 1. It should cover everything except the handling of (@PermitType = 'M')

I expect you have a test environment so you can verify if it will return the...

lmu92 (4/14/2010)

Well, this way of...

I did this because the previous conversion to get to the mainframe/VSAM version caused some bad data to be created. There are records...