Forum Replies Created

Viewing 15 posts - 1,096 through 1,110 (of 8,731 total)

  • RE: Are the posted questions getting worse?

    Thom A - Thursday, July 20, 2017 10:02 AM

    jasona.work - Thursday, July 20, 2017 9:51 AM

    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

    July 20, 2017 at 11:57 am

    #1951932

  • RE: use exec(@sql) in if exists and get output parameters dynamic sql

    mnr123 - Thursday, July 20, 2017 8:10 AM

    I have result set from @runtimequery like below .I want to set 2 parameters according...

    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

    July 20, 2017 at 9:36 am

    #1951885

  • RE: Extracting specific data range

    Take a look at the DATEADD() function.

    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

    July 20, 2017 at 9:12 am

    #1951874

  • RE: Distinct query with all columns

    Is there an additional column (or columns) that might make the duplicate rows unique?
    If so, you could normalize the table to reduce the duplication of data.
    I hope the...

    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

    July 19, 2017 at 11:09 am

    #1951707

  • RE: How to get top and bottom rows from where condition

    Will you have gaps in your Id column?

    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

    July 19, 2017 at 6:35 am

    #1951598

  • RE: Are the posted questions getting worse?

    Sergiy - Wednesday, July 19, 2017 1:53 AM

    I wonder if anyone can explain me the difference between DBA and SQL developer.I clear...

    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

    July 19, 2017 at 6:20 am

    #1951593

  • RE: Call Stored Procedure From Another Stored Procedure

    I don't know if I missed a change in the syntax, but the parameters shouldn't be in parenthesis when calling a procedure.
    You also have a ELSE BEGIN...END block without...

    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

    July 18, 2017 at 11:19 am

    #1951469

  • RE: Year, Month and Days from date of birth table

    EasyBoy - Tuesday, July 18, 2017 10:56 AM

    Luis Cazares - Tuesday, July 18, 2017 9:35 AM

    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

    July 18, 2017 at 11:07 am

    #1951464

  • RE: Year, Month and Days from date of birth table

    I wonder if something like this would work.

    DECLARE @Date datetime = '20150702'

    SELECT YEAR( DATEDIFF(DD, @Date, GETDATE())) - 1900,
      MONTH( DATEDIFF(DD, @Date, GETDATE())) - 1,

    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

    July 18, 2017 at 9:35 am

    #1951437

  • RE: Add where clause after a stored procedure.

    adonetok - Tuesday, July 18, 2017 6:35 AM

    No, this stored procedure is coming a product purchased by company.

    Can you copy it to...

    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

    July 18, 2017 at 7:02 am

    #1951386

  • RE: Question on CASE statement

    melinda.savoy - Tuesday, July 18, 2017 6:30 AM

    Thank you, Luis!!  That got it.  Again I appreciate your time and help.

    You're welcome....

    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

    July 18, 2017 at 6:40 am

    #1951373

  • RE: DevOps

    DBA_007 - Tuesday, July 18, 2017 6:03 AM

    This is not a interview Q.
    I just wanted to know is Devops really needed for...

    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

    July 18, 2017 at 6:29 am

    #1951364

  • RE: Question on CASE statement

    melinda.savoy - Tuesday, July 18, 2017 6:03 AM

    In the pic above of the SQL results above I am needing...

    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

    July 18, 2017 at 6:21 am

    #1951360

  • RE: Max. Degree or Parallelism

    alex.sqldba - Tuesday, July 18, 2017 5:57 AM

    The configuration for the instance is correct in as much as out of 600 or...

    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

    July 18, 2017 at 6:07 am

    #1951355

  • RE: Max. Degree or Parallelism

    alex.sqldba - Monday, July 17, 2017 11:43 AM

    Hi Luis,

    I was asking if there is a way to determine from looking at 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

    July 18, 2017 at 5:48 am

    #1951344

Viewing 15 posts - 1,096 through 1,110 (of 8,731 total)