Forum Replies Created

Viewing 15 posts - 5,401 through 5,415 (of 8,731 total)

  • RE: Help with splitting data between two columns

    How do you define that PR-10-01004-2 relates with CC-09-00032-D and not with CC-09-00113-A? Or is that irrelevant? Do you need some kind of order whatsoever?

    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 15, 2014 at 5:58 pm

    #1764836

  • RE: Trying to figure out how to implement nested tables

    Note how the duplicates in the column Tdl_Id generate more rows with your code. You can also check the difference between execution plans (which correlates directly to the 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

    December 15, 2014 at 5:31 pm

    #1764833

  • RE: Trying to figure out how to implement nested tables

    Based on the logic that I can understand from your query, you wouldn't even need derived tables. Look at how I'm posting DDL and sample data, you're supposed to post...

    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 15, 2014 at 5:28 pm

    #1764832

  • RE: SQL Server replace cursor that iterates through X Accounting DBs

    There's a different method but with up to 200 databases the validations can become complex and the improvement is unnoticeable. This is one of those occasions where a cursor is...

    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 15, 2014 at 5:13 pm

    #1764831

  • RE: Year summary report

    You mean like cross tabs?

    http://www.sqlservercentral.com/articles/T-SQL/63681/

    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 15, 2014 at 5:09 pm

    #1764830

  • RE: Trying to figure out how to implement nested tables

    You can try using common table expressions.

    However, your example shows that you're using the same table over and over again joined by the same key. That's only a recipe for...

    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 15, 2014 at 4:18 pm

    #1764821

  • RE: Need help with query, count and union... I think

    This is an idea on how to do it. It's not perfect as the NULLS will be sorted first. I'm sure that you'll be able to handle that.

    DECLARE @RowCount ...

    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 15, 2014 at 4:12 pm

    #1764819

  • RE: Conversion failure varchar to int

    Why do you want to count before truncation? That would only slow you down. Additionally to that, you can't use variable values as table names unless you use dynamic 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

    December 15, 2014 at 11:23 am

    #1764772

  • RE: Help with SQL Cursor

    It seems to me that you don't need a cursor (or worse, nested cursors). This could be accomplished with direct queries.

    However, as Steve told you, we need DDL and sample...

    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 15, 2014 at 10:30 am

    #1764768

  • RE: this query runs to long how can I speed it up????

    Yet another version taking the advantage of preaggregation used by Jason and single table scan from Michael.

    WITH preAggregation AS(

    SELECT WIP_master.uompScheduleNumber

    ,CASE WIP_master.uompScheduleColor

    ...

    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 15, 2014 at 10:22 am

    #1764765

  • RE: Convert column data into row data

    You can read the following articles about cross tabs:

    Part 1[/url]

    Part 2[/url]

    You might need to use ROW_NUMBER() to create "constant" values and MAX() to "aggregate" the data.

    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 12, 2014 at 4:59 pm

    #1764583

  • RE: STUFF Function

    mhildebrand (12/12/2014)

    One voucher paying several vendors and invoices is quite normal. The problem is that you have 2 tables, one defines a relationship between voucher, vendor and invoice and 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

    December 12, 2014 at 12:31 pm

    #1764560

  • RE: STUFF Function

    mhildebrand (12/12/2014)

    Luis, in our environment we may have 1 voucher that pays several vendors and several invoices among those vendors. The reason this all started is I wanted to...

    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 12, 2014 at 11:49 am

    #1764552

  • RE: STUFF Function

    Help me out here. You posted several rows with the same voucher number on both tables. That would create a cartesian product and give incorrect results. Is this correct? You...

    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 12, 2014 at 11:30 am

    #1764545

  • RE: STUFF Function

    mhildebrand (12/12/2014)

    This is not the kind of response a new person on this forum finds helpful, you are basically giving me the finger when I thought I was giving you...

    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 12, 2014 at 10:36 am

    #1764518

Viewing 15 posts - 5,401 through 5,415 (of 8,731 total)