Forum Replies Created

Viewing 15 posts - 2,266 through 2,280 (of 8,731 total)

  • RE: return single value from order of other columns in one query

    Here you go:

    https://msdn.microsoft.com/en-us/library/ms189463.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

    August 23, 2016 at 1:57 pm

    #1897030

  • RE: Are the posted questions getting worse?

    Gail, you just made my day with this answer. http://www.sqlservercentral.com/Forums/FindPost1811748.aspx

    I can't stop laughing. 😀

    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

    August 23, 2016 at 12:28 pm

    #1896998

  • RE: Today's Random Word!

    Ed Wagner (8/23/2016)

    Y.B. (8/23/2016)

    Grumpy DBA (8/23/2016)

    Ed Wagner (8/23/2016)

    Kaye Cahs (8/23/2016)

    Revenant (8/22/2016)

    whereisSQL? (8/22/2016)

    Antacid

    Tums

    Chalk

    Blackboard

    Blackbeard

    Pirate

    Caribbean

    Royal

    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

    August 23, 2016 at 8:59 am

    #1896937

  • RE: Need Guidance On Query

    If you ask me, the adequate option for this is to use EXCEPT. I have to change the name of a column due to the internet filter configuration in my...

    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

    August 22, 2016 at 1:36 pm

    #1896757

  • RE: stored procedure issue

    My post is marked as an answer. But I still would like some feedback to make sure that you understand how and why the code was simplified.

    Also that you understand...

    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

    August 22, 2016 at 12:23 pm

    #1896731

  • RE: help with SQL syntax for SELECT stmt

    In that case, you don't need your CASE statement, the LEFT function alone will work fine. 😉

    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

    August 22, 2016 at 11:17 am

    #1896716

  • RE: stored procedure issue

    You're probably looking for something like this:

    ALTER PROC [dbo].[SupplierStats]

    @a nvarchar(50),

    @b-2 nvarchar(50)

    AS

    SET NOCOUNT ON;

    INSERT INTO dbo.wanado(

    ContactName,

    CompanyName)

    SELECT CompanyName,

    ContactName

    FROM Suppliers

    WHERE ContactName LIKE @a + '%'

    OR ContactName...

    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

    August 22, 2016 at 11:04 am

    #1896713

  • RE: help with SQL syntax for SELECT stmt

    That won't return what you asked.

    To be sure about the correct formula:

    - Will the strings always start with a slash(/)?

    - What should be returned if there's only one?

    -...

    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

    August 22, 2016 at 10:09 am

    #1896699

  • RE: Today's Random Word!

    Ed Wagner (8/22/2016)

    TomThomson (8/20/2016)

    SQLBill (8/19/2016)

    Manic Star (8/19/2016)

    Kaye Cahs (8/19/2016)

    Hugo Kornelis (8/19/2016)

    Ed Wagner (8/19/2016)

    Luis Cazares (8/19/2016)

    Ed Wagner (8/19/2016)

    Chainsaw

    Massacre

    Texas

    Dallas

    Cowboy

    Cheerleader

    Debby

    Ryan

    Jack

    Coke

    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

    August 22, 2016 at 8:52 am

    #1896677

  • RE: Still Confused about the difference between varchar(max) and varchar(8000)

    Jeff Moden (8/22/2016)

    RonKyle (8/19/2016)

    Also, use numeric data types when appropriate (FYI, telephones and zip codes are not numeric data).

    Social Security numbers are also not numeric. Once had a...

    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

    August 22, 2016 at 8:49 am

    #1896673

  • RE: Are the posted questions getting worse?

    Sean Lange (8/19/2016)

    Ed Wagner (8/19/2016)

    Sean Lange (8/19/2016)

    Ed Wagner (8/19/2016)

    RBarryYoung (8/19/2016)

    Jeff Moden (8/19/2016)

    Heh... Cross out the "S" and the "E" and it makes a word that comes from the same animal...

    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

    August 19, 2016 at 1:56 pm

    #1896448

  • RE: Using round, isnull, and sum in the same select

    You're missing the second parameter and closing parenthesis to either ROUND or ISNULL.

    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

    August 19, 2016 at 12:28 pm

    #1896419

  • RE: Today's Random Word!

    Ed Wagner (8/19/2016)

    Chainsaw

    Massacre

    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

    August 19, 2016 at 12:26 pm

    #1896417

  • RE: Still Confused about the difference between varchar(max) and varchar(8000)

    joshua 15769 (8/18/2016)

    Can you tell us a little about your database? Is it something you are in the process of constructing or is it something you have inherited? What 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

    August 19, 2016 at 8:25 am

    #1896359

  • RE: How do I flatten this data out to one row?

    kawi6rr (8/18/2016)

    I’m totally lost, I think it can be done with a union query but I can’t get it to work. Any help is greatly appreciated, thanks in advance.

    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

    August 18, 2016 at 1:47 pm

    #1896243

Viewing 15 posts - 2,266 through 2,280 (of 8,731 total)