Forum Replies Created

Viewing 15 posts - 5,776 through 5,790 (of 26,490 total)

  • RE: How to Calculate Costed Bill Of Material

    mpdillon (11/18/2014)

    Lynn,

    You are correct. My posted data is incorrect. Please see below.

    MMartin1 and Serg-52, Thank you and I will review your comments more closely this evening.

    thanks,

    pat

    Still looks the same as...

    November 18, 2014 at 10:25 am

    #1759353

  • RE: dot notation where all columns are not referenced

    GilaMonster (11/18/2014)

    Lynn Pettis (11/17/2014)

    Even in single table queries I recommend using table aliases in the FROM clause and using that alias on the columns in the select list.

    I would...

    November 18, 2014 at 10:23 am

    #1759351

  • RE: dot notation where all columns are not referenced

    mcinvalek (11/17/2014)

    Much appreciated. This is a corporate environment and you know how sloppy some coders can be.

    Thanks for the info

    Not limited to corporate environments. I call it lazy coding...

    November 17, 2014 at 12:54 pm

    #1759071

  • RE: How to Calculate Costed Bill Of Material

    mpdillon (11/16/2014)

    Further testing on more complicated BOM's show that the above response does not return the correct results.

    Creating a BOM listing or an indented BOM is well documented on this...

    November 16, 2014 at 1:33 pm

    #1758843

  • RE: Memory

    Ozzmodiar (11/14/2014)

    So...do we have a way to report these questions for review? The question is clearly a bad post. We should be given our points.

    No where did it...

    November 14, 2014 at 9:00 am

    #1758650

  • RE: Having issue with implementing CTE in Stored Procedure. Please help!!

    Jason-299789 (11/14/2014)

    Gail/Lynn/Ed,

    I don't disagree, and as Lynn states maybe if MS enforced it so that code wouldn't compile without the use of the statement terminators, like they do in C#/C++...

    November 14, 2014 at 8:56 am

    #1758647

  • RE: FTP on SQL Server

    Damian-167372 (11/14/2014)

    Thanks,

    how about having a seperate server to handel all the FTP upload and download stuff and then SQL server access a shared folder on that server over the...

    November 14, 2014 at 7:41 am

    #1758586

  • RE: Memory

    The Gug (11/14/2014)

    Lynn Pettis (11/14/2014)

    Yes, poorly worded. As for getting points back? You didn't lose any points, you just didn't get any for a correct answer. Anyway,...

    November 14, 2014 at 7:27 am

    #1758575

  • RE: FTP on SQL Server

    Going to start with "It depends." Personally, if I can get a dedicated FTP server I 'd go that route. They really aren't that expensive to setup and...

    November 14, 2014 at 7:18 am

    #1758565

  • RE: Having issue with implementing CTE in Stored Procedure. Please help!!

    Jason-299789 (11/14/2014)

    Koen Verbeeck (11/13/2014)

    The CTE should be followed by a SELECT, INSERT, UPDATE or DELETE statement, not by an IF statement.

    ps: the semicolon is a statement terminator, it has no...

    November 14, 2014 at 7:13 am

    #1758563

  • RE: Memory

    Yes, poorly worded. As for getting points back? You didn't lose any points, you just didn't get any for a correct answer. Anyway, the points don't really...

    November 14, 2014 at 7:03 am

    #1758560

  • RE: Primary Key datatype Bigint vs uniqueidentifier:

    I use SID's in my database designs. Even if I don't use them as a primary key I use them as an alternate key to ensure I have another...

    November 7, 2014 at 12:29 pm

    #1757251

  • RE: Create a view in sql with a column that counts

    windcent (11/5/2014)

    yes that was a good start,

    The sorting is

    (ROW_NUMBER() OVER(ORDER BY ol.OrdNo, ol.LnNo)

    But the problem, it should start on 1 for each break in ol.OrdNo.

    Example: see attached image.

    Here is...

    November 5, 2014 at 3:57 pm

    #1756845

  • RE: Just a question...sort of a strange find

    Keyboard shortcut, ran the procedure sp_lock. Check out Tools -> Options -> Keyboard -> Query Shortcuts.

    November 5, 2014 at 11:20 am

    #1756804

  • RE: Do you keep looking for a permanent job while you are on a 6 month contract?

    It sounds like that there may be an opportunity here. You may want to give the position a month or two to see how the position goes. If...

    November 5, 2014 at 11:09 am

    #1756801

Viewing 15 posts - 5,776 through 5,790 (of 26,490 total)