Forum Replies Created

Viewing 15 posts - 541 through 555 (of 8,731 total)

  • RE: Is there a maximum number of joins allowed in SQL 2016?

    Lynn Pettis - Thursday, May 17, 2018 2:27 PM

    That can kill your performance.  If you are joining between them, each must...

    May 17, 2018 at 2:37 pm

    #1990933

  • RE: Is there a maximum number of joins allowed in SQL 2016?

    GBimberg - Thursday, May 17, 2018 12:41 PM

    I have reports that are between 6 and 100 User DefinedFunctions joined...

    May 17, 2018 at 12:55 pm

    #1990915

  • RE: Using sp_executesql with nvarchar parameters: incorrect syntax near '='

    ktrammen - Thursday, May 17, 2018 10:42 AM

    Joe, yes, that will of course be another issue when the issue with "

    May 17, 2018 at 10:48 am

    #1990884

  • RE: Set default permissions for new stored procedures?

    vnatt - Thursday, May 17, 2018 5:20 AM

    Is there a way to configure it so that any new stored procedures that get...

    May 17, 2018 at 10:19 am

    #1990875

  • RE: Does derived value not exist in another column?

    This might be an option if more than one day is mentioned in Notes.

    CREATE TABLE Logs( Date DATETIME, Notes VARCHAR(100))

    INSERT INTO dbo.Logs
    (
     ...

    May 17, 2018 at 8:32 am

    #1990849

  • RE: Msg 102, Level 15, State 1, Procedure AuditView, Line 1 Incorrect syntax near 'AS'

    The procedure might be in a trigger for one (or all) of the tables that you're deleting.
    BTW, we're in 2018, use TRY...CATCH blocks instead of that horrible error handling...

    May 16, 2018 at 7:43 am

    #1990660

  • RE: Stored procedure running in loop is taking time to load . Is there any alternate way to run in a single execution ?

    ScottPletcher - Tuesday, May 15, 2018 10:52 AM

    For testing a datetime/datetime2 column for the current day, you should do this:

    --good way
    cr.CreatedDate >=...

    May 15, 2018 at 11:28 am

    #1990567

  • RE: Stored procedure running in loop is taking time to load . Is there any alternate way to run in a single execution ?

    If most of your code looks like this, I suggest that you hire a consultant that can not only improve the code but that will teach you how to fix...

    May 14, 2018 at 1:59 pm

    #1990411

  • RE: Return 2 lines of text from a row

    jamesstirling01 - Friday, May 11, 2018 9:01 AM

    My SQL query is: SELECT * FROM [Support_DB].[dbo].['Job info$'] WHERE [Job Completed?]= 0 AND [Attended...

    May 11, 2018 at 12:20 pm

    #1990237

  • RE: Can I do this in SQL? maybe SSIS or Stored Procedure?

    You can do it with either SSIS or T-SQL (stored procedures).
    First you need to import into a staging table using SSIS data flow or T-SQL bulk insert. For...

    May 8, 2018 at 8:37 am

    #1989698

  • RE: Table Variable Parameters, Stored Procedures and Performance

    pef - Friday, May 4, 2018 4:53 PM

    Lynn Pettis - Friday, May 4, 2018 4:05 PM

    May 7, 2018 at 11:28 am

    #1989549

  • RE: Friday the 13th

    Luis Cazares - Monday, May 7, 2018 8:28 AM

    ibraheem.alkilanny - Monday, May 7, 2018 12:02 AM

    May 7, 2018 at 8:34 am

    #1989514

  • RE: Friday the 13th

    ibraheem.alkilanny - Monday, May 7, 2018 12:02 AM

    The value of