Forum Replies Created

Viewing 15 posts - 6,091 through 6,105 (of 7,164 total)

  • RE: Checking Multiple Values In a Precedence Constraint

    GhandiDBA (6/15/2011)

    Thank you very much for your help, that syntax was exactly what I needed!

    Kind regards

    You're very welcome 🙂

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    June 15, 2011 at 10:04 am

    #1339105

  • RE: reading one row less in a job.

    michael wang-201906 (6/15/2011)

    i found the same issue on MSDN, seems 'a file that sometimes contains an extra CRLF at the end of the file' cause the problem.

    The problem is exactly...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    June 15, 2011 at 9:42 am

    #1339093

  • RE: FTP Task in Script Task

    Hi Brandie, I get what you're saying about keeping everything together for manageability and I agree, it's a good practice to keep related pieces of logic that make up what's...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    June 15, 2011 at 8:59 am

    #1339051

  • RE: SQL Server 2008 bit field best design practices

    lfernandesfotos (6/14/2011)

    The analysis is interesting, however, can make life difficult for developers that use the database.

    It depends on the developers 😀

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    June 14, 2011 at 10:32 pm

    #1338751

  • RE: SQL Server 2008 bit field best design practices

    lfernandesfotos (6/14/2011)

    The creation of an index has no problem. What is expected, as said before, is that it can never be used.

    The advantage of using a bit instead, for example,...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    June 14, 2011 at 10:00 pm

    #1338747

  • RE: Checking Multiple Values In a Precedence Constraint

    GhandiDBA (6/13/2011)

    Hello,

    I was wondering if you are able to build an expression for a constraint that will check two variable values before proceeding, or if you have to do some...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    June 14, 2011 at 4:32 pm

    #1338710

  • RE: Best Practices - Variations of the same report (Seniors only)

    What you posted is not technically SQL. It's application code written in the data layer masquerading as SQL.

    Reformatted:

    SELECT @sql2 = @sql2 + CASE WHEN @alias_rede = 'AMAZON' THEN 'and...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    June 14, 2011 at 4:25 pm

    #1338708

  • RE: Finding dates in Dates tally table

    sku370870 (6/14/2011)

    I have an application where everything is about project dates - meeting dates, timeline dates and microtimeline dates - every step in every process has a target date and...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    June 14, 2011 at 4:02 pm

    #1338703

  • RE: data type for decimal

    Please see the section "Mapping Integration Services Data Types to Database Data Types":

    http://msdn.microsoft.com/en-us/library/ms141036.aspx

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    June 14, 2011 at 3:42 pm

    #1338697

  • RE: SQL Server 2008 bit field best design practices

    Craig Farrell (6/14/2011)

    I'll see if I can't dig up some of my older scripts I used.

    I'd be interested in seeing those if you happen to dig them up. It depends...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    June 14, 2011 at 3:39 pm

    #1338695

  • RE: Expression from SSIS to TSQL

    SSIS FINDSTRING becomes CHARINDEX in T-SQL.

    SSIS TRIM becomes LTRIM + RTRIM in T-SQL.

    The rest have the same names between SSIS and T-SQL so you can look them up in...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    June 14, 2011 at 2:53 pm

    #1338676

  • RE: Proc faster when ANSI_WARNINGS is OFF

    Dave Ballantyne (6/14/2011)

    Its not ANSI_WARNINGS , im guessing you are testing with SET STATISTICS TIME ON , that is your difference

    http://sqlblogcasts.com/blogs/sqlandthelike/archive/2009/11/24/the-observer-effect-in-action.aspx

    Thanks for the info but STATISTICS TIME was OFF during...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    June 14, 2011 at 2:07 pm

    #1338657

  • RE: question about INSERT to [N]VARCHAR field

    SELECT 1 AS [No reason to get testy...],

    1.0 AS [unpaid volunteer trying to help you here]

    INTO dbo.[Was it...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    June 14, 2011 at 2:04 pm

    #1338653

  • RE: Proc faster when ANSI_WARNINGS is OFF

    Grant Fritchey (6/14/2011)

    OK. Then the issue still comes back around to what the heck is changing. Well, for what it's worth, statement 7 in one was cheap & quick and...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    June 14, 2011 at 1:53 pm

    #1338643

  • RE: Proc faster when ANSI_WARNINGS is OFF

    I asked the developer to make the following changes so far:

    > Rewrite UDFs used in SELECT column list that were using CURSORs to generate a comma-delimited list to use the...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    June 14, 2011 at 11:35 am

    #1338564

Viewing 15 posts - 6,091 through 6,105 (of 7,164 total)