Is all of your data actually text? This is a very strange requirement to say the least.

SQLRNNR (2/14/2014)

---

Sean Lange (2/14/2014)

---

SQLRNNR (2/14/2014)

---

I have seen that kluge query method work much faster and I have seen it be slower. It all depends. It would be well...

SQLRNNR (2/14/2014)

---

I have seen that kluge query method work much faster and I have seen it be slower. It all depends. It would be well worth testing and...

TheGreenShepherd (2/14/2014)

---

We have the following code (dumbed down):

SELECT Customer.CustomerId, Location.Description

FROM Customer

LEFT JOIN Location ON Customer.LocationId = Location.LocationId

It's a left join here because LocationId may be NULL in the Customer...

born2achieve (2/14/2014)

---

Hi Sean,

Thanks for your reply.

If the value is null then get the column form the pivot which is date and get the "daysinlate" data from table compaany based on...

if you execute the ready made query which is my first code block it will execute fine and after 2013-08-11 the recordscount values will null on the output.

my requirement...

So do you have this figured out now or do you still need some help?

This issue is incredibly to solve. You would have had an answer several hours ago if you would have read the part in my first post about posting ddl, sample...

I assume they meant output.

dhananjay.nagarkar (2/14/2014)

---

Dear friends,

I needed a urgent help on a critical task, for a field named "[ORC Position Duration (months)]"- I need to Calculate number of days from the...

Easy to miss with poor formatting. 😉

crazy_new (2/12/2014)

---

Hi, Could anyone please assist me with the following:

SELECT InvNo,InDate,CaseNo,ClientRef,Curr,InvFullAmount,InvOutstAmount From DebtTran

FROM DebtTran

WHERE NameNo = (SELECT TOP 1 (NameNo) FROM DebtTran).

How would this be written in MS Access.

Thanks...

Luis Cazares (2/13/2014)

---

Sean Lange (2/13/2014)

---

So the little one decided to share the flu with both mommy and daddy. I am so glad we teach our children to share. I am...

So the little one decided to share the flu with both mommy and daddy. I am so glad we teach our children to share. I am about a day behind...

Concurrency could be an issue with this proc also. They dynamic sql does a SELECT INTO without checking if the table exists. If there are two people running this proc...