One more question. There is the possibility that two or more POs to a single supplier can be cut on the same day. I'd like to exclude any additional POs that...

That is wonderful. I knew I was missing something. The PARTITION makes sense once you see it on the screen. It works like a charm. The DATEDIFF really helps in...

So simple. Thanks so much, works like a charm.

Ok, so let's throw this out the window and get to the real point of what I want to accomplish. I have a review date field. It is in table...

Thanks to everyone. These really helped. I think I have what I need.

That's perfect. Thanks so much. I can mold this into a CTE and combine into my other six tables to complete the report. Thanks again.

Thanks Phil. You got me on the right path. This is what I'm going to try out.

DECLARE @SD

February 5, 2017 at 10:34 am

#1926766

That works Drew. So if I need to expand this for more items and there are additional UOMs for them (PLT, BX, etc.), I assume I will need to add...

Fantastic. I wasn't aware of the EXCEPT feature.

Turns out it's in the syntax. By adding this: @query_result_no_padding= 1,

to the job step, I have the results limited to just the data character count and no trailing...

Lowell (6/7/2016)

is the datatype of the source CHAR/NCHAR and not varchar/nvarchar?

exporting char values maintains their defined length.

you'd probably...