Viewing 15 posts - 2,761 through 2,775 (of 8,731 total)
RonMexico (6/3/2016)
I probably phrased my original question incorrectly. Is there a way to display the value as 0.00004 instead of 4E-05 while still casting it as a float?
No, that's...
June 3, 2016 at 7:34 am
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.
June 3, 2016 at 7:21 am
Who has the crystal ball? Mine's not working.
http://www.sqlservercentral.com/Forums/Topic1791754-3077-1.aspx
June 2, 2016 at 1:40 pm
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...
June 2, 2016 at 1:13 pm
Have you ever heard of ISNULL() or COALESCE()?
Much easier to write than a CASE statement.
June 2, 2016 at 1:04 pm
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/
June 2, 2016 at 1:02 pm
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...
June 2, 2016 at 12:54 pm
DK13 (6/2/2016)
June 2, 2016 at 12:40 pm
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...
June 2, 2016 at 10:56 am
Adam.galfskiy (6/2/2016)
Not that I mind (was way, way off with my guess) but I think there were several closer guesses depending on how you classify the closest guess 😉
I agree,...
June 2, 2016 at 10:23 am
eccentricDBA (6/2/2016)
ZZartin (6/2/2016)
Luis Cazares (6/2/2016)
Ed Wagner (6/2/2016)
Manic Star (6/2/2016)
crookj (6/2/2016)
Ballad (of Irving the 142nd fastest gun in the west)Minstrel
Renaissance
Leonardo
Pizza
Luigi's
Mine 😀
June 2, 2016 at 9:30 am
TheSQLGuru (6/2/2016)
Luis Cazares (6/2/2016)
No, that's why we use parametrized queries for filter values using sp_executesql.
Sadly my experience has been that clients have a tough time or don't know proper use...
June 2, 2016 at 9:17 am
jasona.work (6/2/2016)
Happy National Leave the Office Early Day!!![/url]So, who's going to celebrate this day today?
😀
After leaving the office after 8pm everyday for 2 years, I've been celebrating this everyday...
June 2, 2016 at 8:53 am
TheSQLGuru (6/2/2016)
Luis Cazares (6/2/2016)
DECLARE
@dbname sysname,
...
June 2, 2016 at 8:39 am
Ed Wagner (6/2/2016)
Manic Star (6/2/2016)
crookj (6/2/2016)
Ballad (of Irving the 142nd fastest gun in the west)Minstrel
Renaissance
Leonardo
June 2, 2016 at 8:16 am
Viewing 15 posts - 2,761 through 2,775 (of 8,731 total)