StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>Here is everything. First part is what I created to test. Second part is what you need</p> <pre><code>DECLARE @Info TABLE ( NoBoxes int, Carrier varchar(50), ProcessDateTime DateTime, Errored int, Voided int, TrackingNumber varchar(100) ) Insert into @Info (NoBoxes, Carrier, ProcessDateTime, Errored, Voided, TrackingNumber) Values ( 2, 'UPS', '2013-05-22 8:14', 0, 0, '1Z1234567891234567') Insert into @Info (NoBoxes, Carrier, ProcessDateTime, Errored, Voided, TrackingNumber) Values ( NULL, 'UPS', NULL, 0, 1, '1Z1234567891234567') Insert into @Info (NoBoxes, Carrier, ProcessDateTime, Errored, Voided, TrackingNumber) Values ( 5, 'UPS', '2013-05-22 8:22', 1, 0, NULL) Insert into @Info (NoBoxes, Carrier, ProcessDateTime, Errored, Voided, TrackingNumber) Values ( 7, 'UPS', '2013-05-22 8:14', 0, 0, '1Z9876543210987654') Insert into @Info (NoBoxes, Carrier, ProcessDateTime, Errored, Voided, TrackingNumber) Values ( 1, 'UPS', '2013-05-22 8:22', 0, 0, '1Z1472583691472583') Insert into @Info (NoBoxes, Carrier, ProcessDateTime, Errored, Voided, TrackingNumber) Values ( 1, 'FedEx', '2013-05-22 8:14', 0, 0, 'xxxxxxxxxxxxxxxx') Insert into @Info (NoBoxes, Carrier, ProcessDateTime, Errored, Voided, TrackingNumber) Values ( 8, 'FedEx', '2013-05-22 8:22', 0, 0, 'yyyyyyyyyyyyyyyy') Insert into @Info (NoBoxes, Carrier, ProcessDateTime, Errored, Voided, TrackingNumber) Values ( 3, 'USPS', '2013-05-22 8:14', 0, 0, 'zzzzzzzzzzzzzzzz') Insert into @Info (NoBoxes, Carrier, ProcessDateTime, Errored, Voided, TrackingNumber) Values ( 4, 'USPS', '2013-05-22 8:22', 0, 0, 'aaaaaaaaaaaaaaaa') Insert into @Info (NoBoxes, Carrier, ProcessDateTime, Errored, Voided, TrackingNumber) Values ( 7, 'UPS', '2013-05-22 8:14', 0, 0, '1Z9638527411012396') Insert into @Info (NoBoxes, Carrier, ProcessDateTime, Errored, Voided, TrackingNumber) Values ( 9, 'UPS', '2013-05-22 8:22', 0, 0, '1Z4561591981655445') ; </code></pre> <p>I would definitely use a CTE</p> <pre><code>WITH FIRSTCTE (TrackingNumber) AS ( Select TrackingNumber From @Info Where Carrier = 'UPS' And Errored = 0 Group By TrackingNumber ) select * FROM FIRSTCTE as C INNER JOIN @Info as I ON I.TrackingNumber = C.TrackingNumber WHERE DATEADD(D, 0, DATEDIFF(D, 0, I.ProcessDateTime)) = '2013-05-22' </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload