twin.devil (7/4/2016)

---

If the Scenario is to get the increment load (Insert only mode) then you can use the below.

If your Source data is a SQL SERVER, then you can use...

Get me? (2/26/2016)

---

You have an OR condition. It's saying return rows that match OR where CONSIGNEE_DUNS is null.

(CONSIGNEE_DUNS LIKE '%' + @conduns + '%') OR (CONSIGNEE_DUNS IS NULL) OR...

Hugo Kornelis (2/26/2016)

---

pwalter83 (2/26/2016)

---

Hi,

In the report I have created, there is an option for the user to enter optional free text for searching. The problem is the report displays matching...

Get me? (2/18/2016)

---

SSRS doesn't really have a native timespan type. You can achieve your goal using custom functions though. I came up with this so far.

Function StrToTimeSpan(a As...

ben.brugman (12/8/2015)

---

pwalter83 (12/8/2015)

Upon assigning the datetime datatype to SQL, the issue still is not resolved as now if the value in EXCEL is 885:39:35 it is displayed as '1900-02-05 21:39:35'...

Sean Lange (12/8/2015)

---

pwalter83 (12/8/2015)

---

Sean Lange (12/8/2015)

---

pwalter83 (12/8/2015)

---

Sean Lange (12/8/2015)

---

pwalter83 (12/8/2015)

---

ben.brugman (12/8/2015)

---

pwalter83 (12/8/2015)

Thanks for your suggestion. However, it still doesn't help with my basic requirement. I have to convert the time...

Sean Lange (12/8/2015)

---

pwalter83 (12/8/2015)

---

Sean Lange (12/8/2015)

---

pwalter83 (12/8/2015)

---

ben.brugman (12/8/2015)

---

pwalter83 (12/8/2015)

Thanks for your suggestion. However, it still doesn't help with my basic requirement. I have to convert the time duration column in...

Sean Lange (12/8/2015)

---

pwalter83 (12/8/2015)

---

ben.brugman (12/8/2015)

---

pwalter83 (12/8/2015)

Thanks for your suggestion. However, it still doesn't help with my basic requirement. I have to convert the time duration column in excel specifically where...

yb751 (12/8/2015)

---

pwalter83 (12/8/2015)

---

Thanks for your suggestion. However, it still doesn't help with my basic requirement. I have to convert the time duration column in excel specifically where values like 100:20:30...

ben.brugman (12/8/2015)

---

pwalter83 (12/8/2015)

Thanks for your suggestion. However, it still doesn't help with my basic requirement. I have to convert the time duration column in excel specifically where values like 100:20:30...

ben.brugman (12/8/2015)

---

Examples of a computed column in a table.

Source for the computed column in this case is varchar or datetime.

In excel time and/or date is just presented as the number...

John Mitchell-245523 (12/8/2015)

---

Yes. Take the example given on that page and modify it with your table name, columns names and computation....

Can somebody help on this please ? I have already gone through tutorials and links and really need a straight forward answer to this if possible.

I have already gone through this link and it doesn't mention anything about using the convert function in the create table. I don't even know if its possible to...

Thanks Gail. Yes, I want to add a computed column in...