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...

    Jason Wolfkill

    July 31, 2013 at 7:59 am

    #1637396

  • 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...

    Jason Wolfkill

    July 30, 2013 at 9:13 am

    #1637033

  • 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...

    Jason Wolfkill

    July 30, 2013 at 8:50 am

    #1637022

  • 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...

    Jason Wolfkill

    July 26, 2013 at 10:14 am

    #1636231

  • 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...

    Jason Wolfkill

    July 25, 2013 at 12:28 pm

    #1635862

  • 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!...

    Jason Wolfkill

    July 25, 2013 at 12:00 pm

    #1635858

  • 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...

    Jason Wolfkill

    July 25, 2013 at 11:45 am

    #1635853

  • 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...

    Jason Wolfkill

    July 25, 2013 at 10:26 am

    #1635824

  • 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...

    Jason Wolfkill

    July 23, 2013 at 8:59 am

    #1634994

  • 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...

    Jason Wolfkill

    July 23, 2013 at 8:47 am

    #1634988

  • 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...

    Jason Wolfkill

    July 23, 2013 at 8:28 am

    #1634978

  • 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...

    Jason Wolfkill

    July 23, 2013 at 8:02 am

    #1634962

  • 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...

    Jason Wolfkill

    July 23, 2013 at 7:40 am

    #1634943

  • 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...

    Jason Wolfkill

    July 22, 2013 at 11:40 am

    #1634602

  • 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...

    Jason Wolfkill

    July 22, 2013 at 11:37 am

    #1634600

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