No, that's...

Scientific notation is just the display of the value. The value is still 0.00004 or something very similar as float is an approximate numeric data type.

Who has the crystal ball? Mine's not working.

http://www.sqlservercentral.com/Forums/Topic1791754-3077-1.aspx

Copying and pasting the same information won't help. As explained on the other threads, post DDL and insert statements to generate sample data.

Explain how you go from 3 rows to...

Have you ever heard of ISNULL() or COALESCE()?

Much easier to write than a CASE statement.

Use the Parameters Mapping tab and use a question mark (?) where the parameter goes. This is if you're using an OLEDB connection.

Further information:

https://www.simple-talk.com/sql/ssis/passing-variables-to-and-from-an-ssis-task/

Please pay attention on how you post and don't simply copy and paste everything everywhere.

Read the links on my signature to get better help. Right now, I don't understand the...

DK13 (6/2/2016)

---

Luis C that was exactly what I was trying to do and exactly the issue I ran into. Below is some sample data and expected output. Hope...

What I get from your query.

It's creating one row for each date in your calendar table from the first logdate until '03-31-2016', this for each id. Then multiply all those...

I agree,...

Mine 😀

TheSQLGuru (6/2/2016)

---

Sadly my experience has been that clients have a tough time or don't know proper use...

After leaving the office after 8pm everyday for 2 years, I've been celebrating this everyday...

TheSQLGuru (6/2/2016)

---

Luis Cazares (6/2/2016)

---

I prefer to use QUOTENAME which will escape quotes and brackets correctly, as well as handle weird names.

DECLARE

@dbname sysname,

...

Leonardo