Forum Replies Created

Viewing 15 posts - 3,001 through 3,015 (of 8,731 total)

  • RE: Byte Me: Inadequate Cooling

    Gary Varga (4/21/2016)

    BWFC (4/20/2016)

    Gary Varga (4/20/2016)

    Picasso did surrealist paintings where items looked as though they had melted. The artist is matching this with the IT issue of cooling.

    Maybe it is...

    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 21, 2016 at 12:20 pm

    #1873763

  • RE: Comma Separated Result

    This article should help you:

    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 21, 2016 at 12:12 pm

    #1873761

  • RE: Are the posted questions getting worse?

    In other news, Prince died today.

    If Ramsey scores today, his curse might have become more effective.

    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 21, 2016 at 11:51 am

    #1873752

  • RE: Guess the RTM Build

    My guess

    13.0.1500.21

    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 21, 2016 at 8:10 am

    #1873650

  • RE: Are the posted questions getting worse?

    BLOB_EATER (4/21/2016)

    Luis Cazares (4/21/2016)

    Brandie Tarvin (4/21/2016)

    Okay, this is weird. I went searching for an error I got in SSIS 2012 and the first thread that pops up in Google is...

    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 21, 2016 at 7:30 am

    #1873622

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (4/21/2016)

    Okay, this is weird. I went searching for an error I got in SSIS 2012 and the first thread that pops up in Google is a thread I...

    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 21, 2016 at 7:25 am

    #1873618

  • RE: Adding single quotes in a string

    Luis Cazares (4/21/2016)

    Phil Parkin (4/21/2016)

    Luis Cazares (4/21/2016)

    You just need to use REPLACE and escape the single quotes.

    DECLARE @Codes nvarchar(500) = 'AZJ,CLC,AZF,DDD'

    SELECT REPLACE(@Codes, ',', ''',''')

    Are you doing this for dynamic sql...

    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 21, 2016 at 6:46 am

    #1873589

  • RE: Adding single quotes in a string

    Phil Parkin (4/21/2016)

    Luis Cazares (4/21/2016)

    You just need to use REPLACE and escape the single quotes.

    DECLARE @Codes nvarchar(500) = 'AZJ,CLC,AZF,DDD'

    SELECT REPLACE(@Codes, ',', ''',''')

    Are you doing this for dynamic sql coding? Are...

    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 21, 2016 at 6:37 am

    #1873580

  • RE: Adding single quotes in a string

    You just need to use REPLACE and escape the single quotes.

    DECLARE @Codes nvarchar(500) = 'AZJ,CLC,AZF,DDD'

    SELECT REPLACE(@Codes, ',', ''',''')

    Are you doing this for dynamic sql coding? Are you aware of sql...

    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 21, 2016 at 6:28 am

    #1873570

  • RE: Max value in Case Statements

    Just to add timing to the performance tests.

    CREATE TABLE temp (ID int, [Date] DATE);

    WITH

    E(n) AS(

    SELECT n FROM (VALUES(0),(0),(0),(0),(0),(0),(0),(0),(0),(0))E(n)

    ),

    E2(n) AS(

    SELECT a.n FROM...

    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 20, 2016 at 12:15 pm

    #1873430

  • RE: MSG 444 - Select statements included within a function cannot return data to a client.

    Scalar functions are usually a performance problem because they execute row by row. The best option for performance when you need parameters is an inline table valued function which is...

    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 20, 2016 at 9:01 am

    #1873374

  • RE: Primary key and foreign key relationship.

    Just a small note on your nice suggestion.

    You offered first a solution for a many to many relationship. This is useful when a product can have different categories. But you...

    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 20, 2016 at 7:27 am

    #1873320

  • RE: Max value in Case Statements

    A different version.

    WITH Table1(ID,Date) AS

    (SELECT ID,Date FROM (

    VALUES

    (1 ,'1/1/1900')

    ,(2 ,'1/1/1900')

    ,(3 ,getdate() )

    ,(4 ,Getdate() )

    ) AS X(ID,Date))

    SELECT

    T1.ID

    ,T1.Date

    ,CASE

    WHEN MAX(T1.Date) OVER()...

    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 20, 2016 at 7:16 am

    #1873313

  • RE: BULK INSERT seems not to recognise line terminators

    Mark Dalley (4/19/2016)

    8.0

    6

    1SQLCHAR08000"\""0DUMMY ""

    2SQLCHAR08000"\",\""1CODE ""

    3SQLCHAR08000"\",\""2MEANING ""

    4SQLCHAR08000"\",\""3DESCRIPTION ""

    5SQLCHAR08000"\",\""4TYPE ...

    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 19, 2016 at 12:41 pm

    #1873160

  • RE: BULK INSERT seems not to recognise line terminators

    Mark Dalley (4/18/2016)

    Hi Jeff and Luis

    OK, used a format file as suggested in Jeff's article, works smoothly. Since some of the fields contain embedded commas, I have changed the real...

    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 19, 2016 at 11:57 am

    #1873148

Viewing 15 posts - 3,001 through 3,015 (of 8,731 total)