Forum Replies Created

Viewing 15 posts - 5,371 through 5,385 (of 15,381 total)

  • RE: RecursiveHierarchyCTE

    Can you post ddl and sample data in a consumable format? I am not a big fan of opening up rar files from the internet. You can post the information...

    March 28, 2014 at 7:41 am

    #1701089

  • RE: Are the posted questions getting worse?

    dwain.c (3/28/2014)

    Ville-Pekka Vahteala (3/27/2014)

    Luis Cazares (3/27/2014)

    How is it possible that someone writes a cursor instead of using SUM()?

    I'm afraid that this database is full of these pieces of sh code...

    March 28, 2014 at 7:33 am

    #1701084

  • RE: What is (Null='Hello') in Sql Server

    mikesyd (3/27/2014)

    I appreciate the replies. I understand the explanation. What I do not understand is why and/or how it would be useful to have the result of comparing...

    March 28, 2014 at 7:26 am

    #1701082

  • RE: Adding dummy values

    Golden_eye (3/28/2014)

    Sean Lange (3/27/2014)

    Yeah this is pretty much exactly what Scott already posted.

    I changed the name Case to MyCase because I hate working with reserved words and typing brackets around...

    March 28, 2014 at 7:22 am

    #1701080

  • RE: sql dynaminc and aggregate functions

    To me the bigger question is why are you using dynamic sql at all? From what you posted there is absolutely no need for it whatsoever.

    March 27, 2014 at 2:41 pm

    #1700890

  • RE: What is (Null='Hello') in Sql Server

    mikesyd (3/27/2014)

    When and why would it be useful to have ANSI_NULLS on?? Something is either null or it isn't to me. Having the system say "I can't tell...

    March 27, 2014 at 12:53 pm

    #1700847

  • RE: Adding dummy values

    Yeah this is pretty much exactly what Scott already posted.

    I changed the name Case to MyCase because I hate working with reserved words and typing brackets around table names.

    insert...

    March 27, 2014 at 12:10 pm

    #1700840

  • RE: I need differences between Roles, Schemas, Users and Logins. Can anyone help me. Thanks in advance

    robin.pryor (3/27/2014)

    Ah but the question "What landed me on this post in the 1st place?"

    I'm a SQL DBA and I've never given a crap about schemas. I know what they...

    March 27, 2014 at 10:49 am

    #1700796

  • RE: Simple Inner Join Question

    Seems that Luis was posting as I was typing. 😛

    March 27, 2014 at 10:31 am

    #1700783

  • RE: Simple Inner Join Question

    John Mitchell-245523 (3/27/2014)

    The first one is ANSI compliant and so is usually preferred. I prefer it also because it keeps the join predicate separate from the WHERE clause.

    Actually both...

    March 27, 2014 at 10:29 am

    #1700781

  • RE: Adding dummy values

    Golden_eye (3/27/2014)

    Sean Lange (3/27/2014)

    Golden_eye (3/27/2014)

    Correct, I want to create rows in the SubCase table when a Case has no SubCase. This is permanent, not during a query.

    Then you will need...

    March 27, 2014 at 9:39 am

    #1700757

  • RE: Specific Sprocs vs general get all sprocs

    JKSQL (3/27/2014)

    So I/O outweighs procedure cache?

    Not sure what you mean by that?

    There is no reason to create a stored proc to return all the rows of the table when all...

    March 27, 2014 at 9:37 am

    #1700755

  • RE: Adding dummy values

    Golden_eye (3/27/2014)

    Correct, I want to create rows in the SubCase table when a Case has no SubCase. This is permanent, not during a query.

    Then you will need to insert these...

    March 27, 2014 at 9:32 am

    #1700748

  • RE: I need differences between Roles, Schemas, Users and Logins. Can anyone help me. Thanks in advance

    robin.pryor (3/27/2014)

    MarkusB (1/7/2009)

    SQL DBA (1/7/2009)

    I need differences between Roles, Schemas, Users and Logins. Can anyone help me. Thanks in advance

    You call yourself SQL DBA and ask such a basic question...

    March 27, 2014 at 9:30 am

    #1700746

  • RE: Adding dummy values

    Golden_eye (3/27/2014)

    I have 2 related tables Case c and Subcase s (c.Case ID = s.Case ID: Case columns: CaseID Resolution

    Subcase Columns: Case ID Subcase ID SerialNumber

    Some CaseIDs do not have...

    March 27, 2014 at 9:27 am

    #1700742

Viewing 15 posts - 5,371 through 5,385 (of 15,381 total)