Forum Replies Created

Viewing 15 posts - 5,776 through 5,790 (of 8,731 total)

  • RE: sys.sql_modules truncating definition

    SSMS won't return more than 8000 chars. You could use substring to review the complete code.

    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 26, 2014 at 1:17 pm

    #1748589

  • RE: Problem on Dynamic Pivot

    If you're already using sp_executesql, you should parametrize your query to avoid SQL Injection. You might have a Bobby Tables[/url] in your 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

    September 26, 2014 at 11:26 am

    #1748575

  • RE: Need to Join two tables based on Nearest Date

    Any solution would be slow, you should really fix this issue.

    To solve your problem as it is, you could try with a correlated subquery using CROSS APPLY. For better assistance,...

    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 24, 2014 at 3:42 pm

    #1747998

  • RE: Trigger in sql200

    Inserted and Deleted tables are virtual tables that exist only under the scope of each trigger. They contain the rows affected and have the same structure as the table used...

    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 24, 2014 at 12:48 pm

    #1747950

  • RE: SSIS How to make one task flow wait for another

    My non-expert idea is to create a dummy task between C and D with 2 constraints. One constraint expecting Success from C and one coming from the start expecting @Variable...

    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 24, 2014 at 10:18 am

    #1747897

  • RE: Testing in Production

    Sean Lange (9/24/2014)

    djackson 22568 (9/24/2014)

    andrew gothard (9/24/2014)

    Luis Cazares (9/23/2014)

    ...

    Every time a new iOS is released, it seems to consume a lot of battery.

    ...

    Bwahaa, that's apparently fixed now with their express...

    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 24, 2014 at 9:41 am

    #1747887

  • RE: Testing in Production

    andrew gothard (9/24/2014)

    Luis Cazares (9/23/2014)

    ...

    Every time a new iOS is released, it seems to consume a lot of battery.

    ...

    Bwahaa, that's apparently fixed now with their express recharge process (google iPhone...

    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 24, 2014 at 9:05 am

    #1747879

  • RE: EXEC does not require quotation marks?

    Why don't you try it on SSMS?

    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 24, 2014 at 8:48 am

    #1747866

  • RE: SQL

    Why do you want to change a value daily?

    If you want to keep track of the departures, you need one row per departure. If you don't care about history 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

    September 24, 2014 at 8:45 am

    #1747863

  • RE: Ordering the String Value possibly by using PARSENAME function

    farooq.hbs (9/24/2014)

    Thank you!

    But we are not suppose to use functions.

    But PARSENAME is a function. :hehe:

    Even if you could decide to use the DelimitedSplit8k function, I guess it would be unnecessary...

    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 24, 2014 at 8:36 am

    #1747858

  • RE: Finding the most recent live balance for an account

    This kind of problems are usually addressed using ROW_NUMBER() with a CTE.

    WITH CTE AS(

    SELECT A.ACCID,

    b.balance,

    ...

    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 23, 2014 at 7:04 pm

    #1747691

  • RE: Need help on a query in SQL 2005

    As Chris said in the comments, the quirky update should be a lot faster. I've been bitten by the rCTEs ' performance when using a lot of information. 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

    September 23, 2014 at 3:56 pm

    #1747671

  • RE: Query to split difference (number of nights) between 2 dates into respective "Month" column

    I can't see your images because dropbox is blocked at work. That's why we usually ask for DDL, sample data and expected results as a runnable script. If 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

    September 23, 2014 at 2:13 pm

    #1747646

  • RE: How to remove string

    In SQL Server 2012, you can use TRY_PARSE(), TRY_CONVERT() or TRY_CAST().

    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 23, 2014 at 1:44 pm

    #1747634

  • RE: Seems like my SQL database is corrupted

    It seems unlikely that someone can help you here. It's not that we're not willing to, it's only that most of us don't have the technical knowledge to do so.

    http://forums.mysql.com/

    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 23, 2014 at 10:18 am

    #1747569

Viewing 15 posts - 5,776 through 5,790 (of 8,731 total)