Forum Replies Created

Viewing 15 posts - 3,991 through 4,005 (of 8,731 total)

  • RE: SQL Server to Oracle

    I can't remember on basic admin stuff, but this can help you for differences between SQL implementations of Oracle and SQL Server:

    http://troels.arvin.dk/db/rdbms/

    Of course, the same advise as the ones coming...

    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 22, 2015 at 9:47 am

    #1834953

  • RE: Dynamic Pivot, Passing Temp Table Variables to Dynamic SQL

    farfel (10/22/2015)

    I have searched the internet for this situation to no avail, but we believe that starting in some version of SQL2008+ that if you define the @columns variable as...

    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 22, 2015 at 9:41 am

    #1834951

  • RE: Password error in SSIS

    If you wanted to stay in the past, you could have followed this: https://www.virtualobjectives.com.au/sqlserver/dts_sql2005.htm

    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 22, 2015 at 9:10 am

    #1834937

  • RE: The Dangers of Travel

    eric.notheisen (10/22/2015)

    Once you cross the border you need to consider that you are on a network controlled by another government. Anything you transmit whether it is email or an web...

    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 22, 2015 at 8:46 am

    #1834926

  • RE: Dynamic Pivot, Passing Temp Table Variables to Dynamic SQL

    Is great to know that you're sharing your real life experience. As commented above, the cross tabs approach has been way back before pivot and is more flexible. That doesn't...

    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 22, 2015 at 8:24 am

    #1834913

  • RE: TSQL Error: Invalid object name 'LastSevenDays'.

    Without actual sample data, I can't ensure that this will work, but it should give you an idea. It reduce the code and the work done.

    SELECT [GCM_CLIENT_CD],

    ...

    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 21, 2015 at 1:42 pm

    #1834762

  • RE: Query on a large database

    SQLCurious (10/21/2015)

    I store my dates as integers (in YYYYMMDD format) and have an index on them. I have another DimDate table that has YYYYMMDD as clustered PK, and the remaining...

    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 21, 2015 at 1:24 pm

    #1834757

  • RE: Cursor written for complex condition is running forever.

    Why do you think you need a cursor? You're not even using the variable inside the cursor.

    I'm not sure about your requirements as they're confusing and your sample data won't...

    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 21, 2015 at 1:17 pm

    #1834754

  • RE: Hyphen delimited string manipulation

    As John said, the problem is that your splitter function is at least 4 times slower than the one we suggested. It might actually be worse by using varchar(max).

    Read 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

    October 21, 2015 at 6:52 am

    #1834619

  • RE: replace same more then one character in one column sql query

    mr.addikhan (10/20/2015)

    Sir, i am junior developer i am learning sql server, your professional i need only help..:crying:

    That's even a better reason to stop and understand what you're...

    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 20, 2015 at 4:14 pm

    #1834512

  • RE: replace same more then one character in one column sql query

    You forgot to create the splitter in your system. You need to use it inside the function and call the function using your table.

    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 20, 2015 at 2:46 pm

    #1834502

  • RE: replace same more then one character in one column sql query

    Alan, your idea is good, but if order is important a tweak might be needed.

    CREATE FUNCTION dbo.RemoveDupes(@string varchar(8000))

    RETURNS TABLE AS

    RETURN

    WITH CTE AS(

    SELECT MIN( ItemNumber)...

    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 20, 2015 at 2:10 pm

    #1834487

  • RE: SQL syntax help please ( to drop all tables )

    Why not just drop and recreate the database?

    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 20, 2015 at 2:00 pm

    #1834482

  • RE: How to find the first, last and the Highest (Peak Value) in a list

    If you can't create data that accurately represents your problem, then you might not understand your real problem or your data.

    We can't help you with that and we can't understand...

    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 20, 2015 at 7:49 am

    #1834367

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (10/20/2015)

    Ed Wagner (10/20/2015)

    Alvin Ramard (10/19/2015)

    From: http://www.sqlservercentral.com/Forums/Topic1720717-1292-4.aspx#bm1729123

    ITU_dk2012 (10/19/2015)

    ... I think I should post this into another SSC forum because I am not getting any help over here.

    Thanks.

    Oh...

    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 20, 2015 at 7:47 am

    #1834364

Viewing 15 posts - 3,991 through 4,005 (of 8,731 total)