Forum Replies Created

Viewing 15 posts - 2,296 through 2,310 (of 15,381 total)

  • RE: Multiple queries in the same stored procedure

    Manic Star (9/16/2015)

    ZZartin (9/16/2015)

    Is there a particular reason why your developers want to do this, some weird security reasons that make creating multiple procedures an issue? Or do they...

    September 16, 2015 at 9:59 am

    #1827126

  • RE: Finding NULL in CASE Statement

    Lynn Pettis (9/16/2015)

    Sean Lange (9/16/2015)

    Kristen-173977 (9/16/2015)

    Sean Lange (9/16/2015)

    ClientID is a great name. It can be named ClientID in every table and you shouldn't end up with a name collision.

    I'm never...

    September 16, 2015 at 9:40 am

    #1827120

  • RE: Finding NULL in CASE Statement

    Kristen-173977 (9/16/2015)

    Sean Lange (9/16/2015)

    ClientID is a great name. It can be named ClientID in every table and you shouldn't end up with a name collision.

    I'm never sure where that approach...

    September 16, 2015 at 9:07 am

    #1827107

  • RE: Multiple queries in the same stored procedure

    Manic Star (9/16/2015)

    Our developers have gotten this idea lately that instead of having many small stored procedures that do one thing and have small parameter lists that SQL can optimize...

    September 16, 2015 at 8:24 am

    #1827085

  • RE: Finding NULL in CASE Statement

    Kristen-173977 (9/16/2015)

    Sean Lange (9/16/2015)

    Kristen-173977 (9/16/2015)

    Did I do a better job of conveying what I meant this time?

    Yup, got it! Totally missed it the first time around though, sorry.

    So ID...

    September 16, 2015 at 8:20 am

    #1827082

  • RE: Finding NULL in CASE Statement

    Kristen-173977 (9/16/2015)

    Sean Lange (9/15/2015)

    I absolutely can't stand it when column names change across tables. It isn't a cli_Name it is a ClientName and it is always a ClientName.

    Sorry, just in...

    September 16, 2015 at 7:15 am

    #1827053

  • RE: USER DEFINED DATA TYPES: Used in table creation - What happens if you change just the user defined type to varchar(max) from text?

    sgmunson (9/15/2015)

    Sean Lange (9/15/2015)

    sgmunson (9/15/2015)

    Sean Lange (9/15/2015)

    That could either strengthen the idea of not using the existing type or make the whole process a lot more complicated. Will be interesting...

    September 16, 2015 at 7:14 am

    #1827052

  • RE: USER DEFINED DATA TYPES: Used in table creation - What happens if you change just the user defined type to varchar(max) from text?

    sgmunson (9/15/2015)

    Sean Lange (9/15/2015)

    That could either strengthen the idea of not using the existing type or make the whole process a lot more complicated. Will be interesting to see what...

    September 15, 2015 at 7:44 pm

    #1826954

  • RE: Best idea - summary field

    Kristen-173977 (9/15/2015)

    mike 57299 (9/15/2015)

    The field is currently in use many places and changing all the references from the table to a view is a large time investment.

    Would it be...

    September 15, 2015 at 7:42 pm

    #1826953

  • RE: Finding NULL in CASE Statement

    Kristen-173977 (9/15/2015)

    We have column names that are unique within the database. Each column has a prefix which represents the table. Client table might have columns cli_ID, cli_Name, etc.

    This is by...

    September 15, 2015 at 7:40 pm

    #1826952

  • RE: Finding NULL in CASE Statement

    Lynn Pettis (9/15/2015)

    Not only that, three and four part naming conventions in a SELECT list has been deprecated. Using table alias lets you use two part naming conventions in...

    September 15, 2015 at 2:21 pm

    #1826905

  • RE: Are the posted questions getting worse?

    SQLRNNR (9/15/2015)

    Brandie Tarvin (9/15/2015)

    Alvin Ramard (9/15/2015)

    One question on Ask SQL Server Central is just begging for a smart *** answer!

    Question: Difference between 32 bit and 64 bit?

    Answer: 32 bits.

    😀

    And a...

    September 15, 2015 at 2:18 pm

    #1826903

  • RE: Best idea - summary field

    mike 57299 (9/15/2015)

    Sean Lange (9/15/2015)

    mike 57299 (9/15/2015)

    What is the difference between using a view and creating a calculated virtual column?

    Mike

    The main difference is that to use a computed column you...

    September 15, 2015 at 2:02 pm

    #1826898

  • RE: Best idea - summary field

    mike 57299 (9/15/2015)

    What is the difference between using a view and creating a calculated virtual column?

    Mike

    The main difference is that to use a computed column you would have to create...

    September 15, 2015 at 1:43 pm

    #1826894

  • RE: Best idea - summary field

    Lowell (9/15/2015)

    i would use a view that does the calculation from your post above, and then you can poll the view instead of the base table. that is the easiest...

    September 15, 2015 at 1:22 pm

    #1826888

Viewing 15 posts - 2,296 through 2,310 (of 15,381 total)