VeraCrypt[/url] is based on TrueCrypt. I was planning on moving to it at some point in the near future the flash drive I keep on my key-chain.

Something like: -

UPDATE a

SET ProductAmt = ISNULL(a.ProductAmt + CASE WHEN a.pos <> 1 THEN NULL

...

With no index, as in the sample data, here's a couple more options to add to your own, Ed's and Luis' :w00t:

SELECT a.num

FROM #letters a

CROSS APPLY...

If you remove the CHAR function and the +64, you'll see it produces a set of numbers between...

mattech06 (3/24/2015)

---

Changing that back to TOP 1 brings back all nulls for LastVisitDate and Desc apart from one row.

I can see why I had the wrong LastVisitDesc using MAX as...

Thanks.

First, just to get the admin out of the way, I meant that I could do with the...

SSRS Newbie (3/24/2015)

---

Hi Cadavre,

I appreciate your response. This is exactly what I need but the future dates to show the same schedule Wednesday, Thursday and Friday. How can this be...

mattech06 (3/24/2015)

---

That's almost correct thanks! I get the expected row count and correct LastVisitDate but the LastVisitDesc is wrong.

I've tried it without MAX for LastVisitDesc and putting it into...

Please note that I included some extra logic in there to stop your case statement from affecting rows that are "future". Could probably be cleaned up if someone wants...

Something like this?

SELECT j.DT_ID,

j.JobStatus /*O-Open, S-Shipped, I-Invoiced*/,

j.ExpectedDate 'Requested Delivery Date',

...

That is doing the same thing as what has already been suggested, pretty much. ...

coool_sweet (3/24/2015)

---

one of my stored proc is taking long time to run.

ihave used IN in my query which i replace with join ,

and i am also using union all.

what should...

Did you try searching? I'd have thought that a quick Google search would've answered this question for you far quicker than waiting on a forum.

https://msdn.microsoft.com/en-us/library/ms174397.aspx

SELECT file_id,

...

Like Sean, I could do with more of a "code" explanation. I knocked up your post in to sample data, ready to play with: -

-- CREATE sample "__tt_Freight_Product"

IF object_id('tempdb..#__tt_Freight_Product')...

So that suggests that this is the condition you want on the apply

SELECT DISTINCT

p.dbPatID,

p.dbpatfirstname,

...