Forum Replies Created

Viewing 15 posts - 256 through 270 (of 567 total)

  • RE: Query hangs on table variable

    christopher_rogala (7/31/2013)


    Let me start off by saying, I agree that temp tables are much more efficient that variable tables; and try to exclusively use temp tables. That said, you...

  • RE: Find the last 6 Tuesdays or Wed or Whatever day.

    Alan.B (7/29/2013)


    Using this sample data:

    <snipped>

    This would give you the sales for the last 6 Tuesdays. You could adjust @day and @wks_back as needed.

    Alan.B's code only works when there is...

  • RE: Find the last 6 Tuesdays or Wed or Whatever day.

    tdanley (7/29/2013)


    I have a sales report that shows the previous days sales. I need to modify to a rolling report that shows the previous 6 of that day of...

  • RE: Are the posted questions getting worse?

    Jeff Moden (7/26/2013)


    L' Eomot Inversé (7/24/2013)


    I haven't got enough hair to have bad hair days 🙂

    BWAAA-HAAA!!! I've got tons of hair. I'm just not allowed to show it...

  • RE: Problem with Data source, Pls help me

    A data source has to be able to access the metadata to expose its output columns. I haven't verified this, but I don't think the metadata of a data source...

  • RE: Indexing in views

    Hugo Kornelis (7/25/2013)


    wolfkillj (7/25/2013)


    Andrew Diniz (7/25/2013)


    I supposed (incorrectly) that the ALTER VIEW would fail due to the addition of the non-determinitic column, CurrentDate, to the indexed view.

    Learned lots this morning!...

  • RE: Job STep with multiple commands

    Janda Nel (7/24/2013)


    Good day

    I want to make a job step,but it must do various commands.The steps is as follows.

    1.Copy a file over to another file location

    2.Insert a records into a...

  • RE: Indexing in views

    Andrew Diniz (7/25/2013)


    I supposed (incorrectly) that the ALTER VIEW would fail due to the addition of the non-determinitic column, CurrentDate, to the indexed view.

    Learned lots this morning! Nice question!

    Even if...

  • RE: Are the posted questions getting worse?

    dwain.c (7/23/2013)


    Wolfy (may I call you Wolfy?) -

    I'd say you nearly hit the nail on the head. Except for this:

    wolfkillj (7/23/2013)


    That would be unfortunate, since those who wrongly...

  • RE: Are the posted questions getting worse?

    jasona.work (7/23/2013)


    /me, munching on popcorn and enjoying the calm, reasoned, rational discourse on writing and expectations of the reader...

    😎

    "calm, reasoned, rational discourse" on the interwebs . . . does not...

  • RE: Dumb question about data types

    Sean Lange (7/22/2013)


    I realize that my example above is not really accurate because once a foreign key is established you can't change the datatype and the datatypes must match when...

  • RE: do I need to use case explicily

    Sean Lange (7/22/2013)


    sqlfriends (7/22/2013)


    I have a database that imported some students' info from a text file.

    When importing into the raw table, the studentID is set as varchar(9).

    Then we select from...

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (7/23/2013)


    dwain.c (7/23/2013)


    1. There is a concept called (and forgive me for making this sound so formal) illusory superiority.

    I don't know why you're making this reference in regards to...

  • RE: Client does not want to pay overtime. How to deal with it ?

    mmartin1 (7/22/2013)


    mmartin1 (7/21/2013)This issue may have more than meets the eye. Depending on the exact work that you do and the money you make, the company may be able to...

  • RE: Data Transfer - data not transfered in order

    GilaMonster (7/22/2013)


    wolfkillj (7/22/2013)


    So strictly speaking, the data for rows in a clustered index will not always be physically stored in key order, although the data can only be out of...

Viewing 15 posts - 256 through 270 (of 567 total)