Thank you so much Jacob. That is giving out the expected results.

Thanks a lot for your help.

Orlando Colamatteo (4/22/2015)

---

+1 to the idea of removing Access from the equation if possible and having the data provider write to SQL Server. If that is not possible then look...

Sean Lange (4/22/2015)

---

tlp6327 (4/22/2015)

---

I have got 4 MS Access Database Files, which have got 3 Tables each, means Total 12 Tables which gets updated with new data every evening, by...

gward 98556 (4/14/2015)

---

For very simple calculations like your example, it's normally fine to simply do the whole calculation in the SELECT part of the query, accepting that there is a...

andrew.courneya 63072 (4/13/2015)

---

You can also do simple wraps/nests right in the source query. Think of it as an action on the data in the table that you've wrapped (in this...

gward 98556 (4/13/2015)

---

I sometimes use OUTER APPLY to avoid repeating a formula instead of using a CTE, but I'm not sure which method is more efficient. For example:

SELECT

Column_1,

Column_2,

Column_3,

10*Column_1 AS Column_4,

OA.Column_5,

Column_1*OA.Column_5...

@ Moderators

I made a reply to the above post, few hours ago. But that post seems to have become invisible now !

Can you please make that post visible, or I...

matak (4/12/2015)

---

Hi,

You cant reference a column alias in the same select statement it was created.

You will either need to do Column1*10*column2 as Column6

or wrap it in a cte first

with cte...