Forum Replies Created

Viewing 15 posts - 2,761 through 2,775 (of 8,731 total)

  • RE: Today's Random Word!

    Ed Wagner (6/3/2016)

    djj (6/3/2016)

    Beer

    Friday

    Weekend

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 3, 2016 at 7:37 am

    #1883085

  • RE: Cast Varchar to Float Resulting In (Scientific) E Notation

    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...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 3, 2016 at 7:34 am

    #1883084

  • RE: Cast Varchar to Float Resulting In (Scientific) E Notation

    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.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 3, 2016 at 7:21 am

    #1883080

  • RE: Are the posted questions getting worse?

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

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

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 2, 2016 at 1:40 pm

    #1882934

  • RE: Create or update rows on the basis of time interval

    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...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 2, 2016 at 1:13 pm

    #1882922

  • RE: Syntax help needed for UPDATE Statement

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

    Much easier to write than a CASE statement.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 2, 2016 at 1:04 pm

    #1882918

  • RE: Passing a parameter value to Stored Proc in SSIS 2008

    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/

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 2, 2016 at 1:02 pm

    #1882914

  • RE: Create or update rows on the basis of time interval

    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...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 2, 2016 at 12:54 pm

    #1882907

  • RE: Help with conditional joins

    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...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 2, 2016 at 12:40 pm

    #1882898

  • RE: Help with conditional joins

    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...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 2, 2016 at 10:56 am

    #1882876

  • RE: Guess the RTM Build

    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,...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 2, 2016 at 10:23 am

    #1882871

  • RE: Today's Random Word!

    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 😀

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 2, 2016 at 9:30 am

    #1882864

  • RE: Query not executing dynamic way

    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...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 2, 2016 at 9:17 am

    #1882862

  • RE: Are the posted questions getting worse?

    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...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 2, 2016 at 8:53 am

    #1882850

  • RE: Query not executing dynamic way

    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,

    ...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    June 2, 2016 at 8:39 am

    #1882840

Viewing 15 posts - 2,761 through 2,775 (of 8,731 total)