Forum Replies Created

Viewing 15 posts - 5,446 through 5,460 (of 8,731 total)

  • RE: First Day and Last day of the previous month in ssis expression

    I believe that this should do it. You should test it adequately.

    "A_"

    + RIGHT( "0" + (DT_STR, 2, 1252) MONTH(DATEADD("MM", -1, GETDATE())), 2)

    + "01_"

    + RIGHT( "0" + (DT_STR,...

    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

    December 3, 2014 at 2:43 pm

    #1762517

  • RE: SQL DBA knowing user passwords

    Ville-Pekka Vahteala (12/3/2014)

    BTW how do you use windows login from Java EE application with application server on DMZ and database on LAN?

    Does this help? http://www.developertutorials.com/single-sign-on/

    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

    December 3, 2014 at 12:46 pm

    #1762502

  • RE: What will be the output message?

    Figured out that the missing quote had nothing to do with the question but missed the part where text data type is used.

    Are people still using those horrible data types?...

    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

    December 3, 2014 at 8:26 am

    #1762407

  • RE: Timer in T - SQL

    Robert klimes (12/3/2014)

    seems to me that an idle timeout could be handled better via the web app directly (example). Keeping the session state in the database would require your app...

    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

    December 3, 2014 at 8:18 am

    #1762405

  • RE: Using Variables in SSIS Tasks

    You're missing the output clause in your SQL Task. I'm not sure that it solves the problem but it's part of it.

    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

    December 2, 2014 at 2:23 pm

    #1762228

  • RE: Pivoting without agreegation???

    Thank you Sean, this wasn't the first time I did it. Fortunately, this has only been a request in the forums.

    This is an alternate way of doing it, depending on...

    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

    December 2, 2014 at 12:56 pm

    #1762213

  • RE: Running a script in a specific database.

    That seems over complicated when you're just adding the database to sp_executesql which can be done directly instead of calling an additional procedure and you remove the functionality of using...

    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

    December 2, 2014 at 10:21 am

    #1762162

  • RE: Creating Pivot Table for SSRS report

    Duplicate post.

    All answers in here: http://www.sqlservercentral.com/Forums/Topic1640806-3412-1.aspx

    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

    December 2, 2014 at 10:11 am

    #1762160

  • RE: Pivoting without agreegation???

    It's weird how this comes from time to time. A report with no relation between the columns in the same row.

    Here's an example using basic sample data. It might get...

    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

    December 2, 2014 at 10:00 am

    #1762158

  • RE: Are the posted questions getting worse?

    Sean Lange (12/2/2014)

    David Burrows (12/2/2014)

    Luis Cazares (12/2/2014)

    ...it can be easier to start from scratch if we can understand the problem, than fix a complete piece of s...

    I have this problem...

    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

    December 2, 2014 at 9:42 am

    #1762149

  • RE: Are the posted questions getting worse?

    Sean Lange (12/2/2014)

    Ed Wagner (12/2/2014)

    SQLRNNR (12/2/2014)

    <sarcasm>EFW is the bomb and must be worshiped because it saves certain dev types a ton of time to develop. </sarcasm>

    And reading that makes...

    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

    December 2, 2014 at 9:10 am

    #1762133

  • RE: Need to get 1st day of week from isowk

    I use the following formula to calculate the previous monday. Just change GETDATE() for any date you need to use.

    DATEADD(WK, DATEDIFF(WK, 0, GETDATE() - 2), 0)

    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

    December 1, 2014 at 5:01 pm

    #1761904

  • RE: STUFF Function

    You're missing a WHERE clause in your correlated subquery to differentiate each vendor.

    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

    December 1, 2014 at 4:58 pm

    #1761903

  • RE: Compare Rows in sample Table - T-SQL help

    myjobsinus (12/1/2014)

    Awesome. That worked like a charm. Thank you so much for your help!

    Thank you for the feedback.

    The question is, do you understand how does it work?

    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

    December 1, 2014 at 12:36 pm

    #1761844

  • RE: SELECT a String

    Answers in here:

    http://www.sqlservercentral.com/Forums/Topic1640410-392-1.aspx

    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

    December 1, 2014 at 11:57 am

    #1761832

Viewing 15 posts - 5,446 through 5,460 (of 8,731 total)