Forum Replies Created

Viewing 15 posts - 1,456 through 1,470 (of 8,731 total)

  • RE: How do I turn a query with a union into a query that gives 2 seperate columns?

    Something like this might work. It's untested due to lack of sample data.
    Declare @FDate DateTime, @TDate DateTime Select @FDate = min(Q.Refdate) from OJDT Q where...

    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

    March 17, 2017 at 1:53 pm

    #1933831

  • RE: t-sql 2012 display spaces

    As told before in this thread , the order is not guaranteed if defined inside a view. The order should be specified in the query that...

    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

    March 17, 2017 at 6:40 am

    #1933730

  • RE: Drop in performance after archiving database

    deleios - Thursday, March 16, 2017 3:19 PM

    curious_sqldba - Thursday, March 16, 2017 11:59 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

    March 16, 2017 at 3:41 pm

    #1933659

  • RE: Are the posted questions getting worse?

    Sean Lange - Thursday, March 16, 2017 3:10 PM

    Lynn Pettis - Thursday, March 16, 2017 2:59 PM

    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

    March 16, 2017 at 3:16 pm

    #1933647

  • RE: Such a hard time grasping the basics and understanding the logic!!

    Sue_H - Thursday, March 16, 2017 11:56 AM

    I was just coming back to say the same about the Developers Edition. Its...

    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

    March 16, 2017 at 2:28 pm

    #1933626

  • RE: t-sql 2012 sort

    Joe Torre - Thursday, March 16, 2017 12:48 PM

    Why not create a stored procedure or inline table function?

    Why? What's the advantage? Why...

    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

    March 16, 2017 at 2:26 pm

    #1933625

  • RE: Option to SAVE SQL Import as SSIS not available

    Is it possible that you have Express in your local machine and Enterprise on the server?
    That might explain why the option is not there.

    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

    March 16, 2017 at 2:23 pm

    #1933623

  • RE: Such a hard time grasping the basics and understanding the logic!!

    I forgot 3 things.
    1.- Be sure to install SQL Server Developer Edition on your personal computer and get the sample databases. This will give you a nice setup 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

    March 16, 2017 at 11:47 am

    #1933589

  • RE: Are the posted questions getting worse?

    Sean Lange - Thursday, March 16, 2017 8:05 AM

    It seems that today the comments left by Luis and myself have been...

    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

    March 16, 2017 at 11:38 am

    #1933581

  • RE: Do derived tables joins perform better than plain joins? We are using Parallel datawarehousing sql server

    Depending on complexity, the second one might be a bit slower to compile (nothing noticeable). But most of the time, Gail's answer will prevail.

    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

    March 16, 2017 at 11:36 am

    #1933579

  • RE: Such a hard time grasping the basics and understanding the logic!!

    amirmir - Wednesday, March 15, 2017 4:16 PM

    Hello everyone, I am new to TSQL development and well to be honest programming itself. All 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

    March 16, 2017 at 11:13 am

    #1933570

  • RE: Remove all leading zeros from a column of data in SQL?

    frederico_fonseca - Wednesday, March 15, 2017 2:38 PM

    Phil Parkin - Wednesday, March 15, 2017 1:17 PM

    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

    March 15, 2017 at 3:37 pm

    #1933366

  • RE: Are the posted questions getting worse?

    Alan.B - Wednesday, March 15, 2017 12:37 PM

    Luis Cazares - Wednesday, March 15, 2017 12:32 PM

    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

    March 15, 2017 at 12:47 pm

    #1933335

  • RE: SSMS Tricks - Results

    Has anyone lost this (and other) shortcut? In my work laptop I'm not able to hide the results, but I'm not sure if an add-in removed the functionality.

    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

    March 15, 2017 at 12:44 pm

    #1933333

  • RE: Differences in this where statement

    The dates don't match either. One has 7 days and the other one only 6.

    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

    March 15, 2017 at 12:42 pm

    #1933332

Viewing 15 posts - 1,456 through 1,470 (of 8,731 total)