Forum Replies Created

Viewing 15 posts - 7,636 through 7,650 (of 8,731 total)

  • RE: JOIN issue

    This could cause you some serious problems. Until you become able to change anything, here are two possible solutions, but try to convince someone to authorize the change.

    SELECT *

    FROM Table1...

    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

    October 4, 2013 at 9:34 am

    #1655940

  • RE: IN statement in a stored procedure

    eobiki10 (10/4/2013)

    What I need to be able to do is change the above to use the IN() statement on the variables @membercode and @Source. Any help will be appreciated.

    EO

    Why would...

    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

    October 4, 2013 at 9:00 am

    #1655927

  • RE: Format Cast INT as Text

    Just another way to do it. The Tally is just to generate the sample data and has nothing to do with the solution.

    WITH Tally AS(

    SELECT TOP 60 ROW_NUMBER() OVER(ORDER BY...

    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

    October 4, 2013 at 8:19 am

    #1655916

  • RE: Format Cast INT as Text

    Are you just using integers with values from 0 to 99? Or Are you going to have values like '01', '12', '123', '57246' ? because you might want to add...

    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

    October 3, 2013 at 7:12 pm

    #1655725

  • RE: ssis question

    You need a variable that has scope for the whole package. Assign the filename to the variable look for the Property "Expressions" in the connection properties. In there you can...

    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

    October 3, 2013 at 1:59 pm

    #1655684

  • RE: SQL Select Case

    You need to add an ELSE to your CASE statement. I'm sure you don't need separate conditions even if it becomes more readable.

    SELECT name,

    address,

    ...

    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

    October 3, 2013 at 10:01 am

    #1655624

  • RE: Concatenating several row columns into one

    Check the following article. It explains the method you might need.

    http://www.sqlservercentral.com/articles/comma+separated+list/71700/

    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

    October 2, 2013 at 3:28 pm

    #1655347

  • RE: Question Regarding Store Procedure

    You should better use TRY...CATCH which is available since 2005

    TRY...CATCH (Transact-SQL)

    Using TRY...CATCH in Transact-SQL

    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

    October 2, 2013 at 12:59 pm

    #1655307

  • RE: Question Regarding Store Procedure

    What's your problem? I don't understand what you need.

    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

    October 2, 2013 at 12:41 pm

    #1655302

  • RE: Using SSIS 2012 to read data from Oracle 11g R2

    Installing the Oracle Client and adding the service to TNSNAMES.ORA was all that I needed to connect to an Oracle db. Other problems involved network/firewall permissions.

    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

    October 2, 2013 at 12:04 pm

    #1655295

  • RE: I need help Please :(

    Please post DDL, sample data and expected results so we can give you better responses by working on something that will actually look like your real data.

    For guidance, please read...

    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

    October 1, 2013 at 8:13 am

    #1654930

  • RE: get a specific time window across the night between two days

    I'm giving a shot in the dark here, based on many assumptions. Please post DDL and sample data as explained on the article linked in my signature for better help.

    WITH...

    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

    September 30, 2013 at 7:16 pm

    #1654759

  • RE: get a specific time window across the night between two days

    Does this example helps you?

    WITH Time_Windows(StartTime, EndTime) AS(

    SELECT DATEADD( HH, 20, DATEADD(DD, DATEDIFF(dd, 0, GETDATE()) - 7, 0)),

    DATEADD( HH, 11, DATEADD(DD, DATEDIFF(dd, 0, GETDATE()) - 6, 0))

    UNION ALL

    SELECT DATEADD( HH,...

    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

    September 30, 2013 at 5:24 pm

    #1654740

  • RE: Can you please let me know the link to download the tool named as - DBHammer?

    Here you go

    DBHammer

    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

    September 30, 2013 at 1:18 pm

    #1654697

  • RE: could not understand what the error is

    Have you tried 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

    September 30, 2013 at 1:16 pm

    #1654695

Viewing 15 posts - 7,636 through 7,650 (of 8,731 total)