Forum Replies Created

Viewing 15 posts - 5,026 through 5,040 (of 8,731 total)

  • RE: Are the posted questions getting worse?

    Grant Fritchey (4/10/2015)

    Brandie Tarvin (4/10/2015)

    Grant Fritchey (4/10/2015)

    Is everyone OK? Are people ill or something? Because this just happened and it has me concerned:

    Not that I've ever been that high, but...

    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

    April 10, 2015 at 12:16 pm

    #1790252

  • RE: sql syntax issue

    You're missing the SELECT.

    And BTW, I suggest to remove the scalar function if possible. We can help you build a faster option.

    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

    April 10, 2015 at 8:45 am

    #1790194

  • RE: Are the posted questions getting worse?

    That's weird. The image is hosted in here.

    Does anybody else have the same problem?

    EDIT: Original source of the picture in here: http://www.moef.dk/fishfingers/

    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

    April 9, 2015 at 6:09 pm

    #1790060

  • RE: Conversion failed when converting the nvarchar value to INT

    You're assigning a string to an integer variable.

    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

    April 9, 2015 at 4:23 pm

    #1790043

  • RE: Concatenate data from column rows - Gopi

    This article by Wayne Sheffield should help you to get what you want.

    http://www.sqlservercentral.com/articles/comma+separated+list/71700/

    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

    April 9, 2015 at 4:05 pm

    #1790042

  • RE: How to get a substring between two characters?

    Calling a scalar UDF inside another scalar UDF is a call for disaster.

    Sean mentioned that this could be done in a single statement because inline table-valued functions are pretty fast....

    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

    April 9, 2015 at 3:48 pm

    #1790040

  • RE: String Manipulation - Data Between Quotes

    Or maybe like this:

    SELECT String,

    LEFT( Phone.number, CHARINDEX( '''', Phone.number) - 1)

    FROM (VALUES( '@City=''New York'', @Phone=''2035551212'' (10 characters, no dashes)'),

    ...

    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

    April 9, 2015 at 3:33 pm

    #1790035

  • RE: Presentation Advice

    I was expecting an advice from Grant involving a kilt. 😀

    Seriously, now.

    - Try to be very organized as your time is very limited.

    - Measure the time...

    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

    April 9, 2015 at 3:27 pm

    #1790027

  • RE: String Manipulation - Data Between Quotes

    Something like this should help.

    SELECT String,

    SUBSTRING( String, Start.Position, CHARINDEX( '''', String, Start.Position + 1) - Start.Position)

    FROM (VALUES( '@City=''New York'', @Phone=''2035551212'' (10 characters, no dashes)'),

    ...

    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

    April 9, 2015 at 3:08 pm

    #1790018

  • RE: Are the posted questions getting worse?

    I finally found Dwain's secret.

    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

    April 9, 2015 at 12:06 pm

    #1789954

  • RE: Enter today's date etc

    As long as the columns just have DEFAULTs assigned, you can treat them as any other column.

    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

    April 9, 2015 at 10:18 am

    #1789922

  • RE: Dynamic column names for insert statement?

    Just as a suggestion that might not solve anything.

    I'd recommend you to use QUOTENAME() instead of inserting the brackets yourself.

    CREATE TABLE dbo.Areyoukidding(

    My_ID int,

    ...

    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

    April 9, 2015 at 10:03 am

    #1789919

  • RE: backwards/forwards compatibility in ss

    You can connect with SSMS to any version of SQL Server (AFAIK), but you might be missing some options due to compability.

    You can restore a backup from 2 previous versions,...

    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

    April 8, 2015 at 2:21 pm

    #1789696

  • RE: compare dates in rows of a table

    This might get you started.

    WITH SampleData(CustomerID, VisitDate) AS(

    SELECT *

    FROM (VALUES(908,'2012-07-28 00:00:00.000'),

    ...

    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

    April 8, 2015 at 2:19 pm

    #1789695

  • RE: Help with arithmetic formula to "stuff" digits

    Thank you all for your help.

    After a quick speed test, I got the following execution times after 10 executions for one million rows.

    -----------------------------------------------------------------------------------------

    |Version | 1 |...

    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

    April 8, 2015 at 1:03 pm

    #1789678

Viewing 15 posts - 5,026 through 5,040 (of 8,731 total)