Forum Replies Created

Viewing 15 posts - 106 through 120 (of 582 total)

  • RE: @Local_Variable 8k Limit

    declare

    @null varchar, @concat varchar(8000)

    --

    exec

    ('select ''first try''' + @null

    Tim Wilkinson

    "If it doesn't work in practice, you're using the wrong theory"
    - Immanuel Kant

    July 5, 2006 at 11:52 am

    #647584

  • RE: Bank Holiday issues

    It sounds like you are overwriting the data every night. You could retain data from the previous Monday, so people can query 'previous week' as well as 'week to date'.

    (might they not...

    Tim Wilkinson

    "If it doesn't work in practice, you're using the wrong theory"
    - Immanuel Kant

    July 5, 2006 at 11:33 am

    #647575

  • RE: Easiest query to find start of month

    I have advice for egg collectors. Stop killing off rare species.

    For those who don't know, the saying is an old one, and refers to sucking eggs for food, a...

    Tim Wilkinson

    "If it doesn't work in practice, you're using the wrong theory"
    - Immanuel Kant

    July 5, 2006 at 10:41 am

    #647557

  • RE: Rewriting an update statement without using a cursor

    Nearly there, but you don't and never did need the left join (Jeff!). Your initialisation query may be once only, but the minatenance of the data isn't once only, is it. The web...

    Tim Wilkinson

    "If it doesn't work in practice, you're using the wrong theory"
    - Immanuel Kant

    July 5, 2006 at 10:15 am

    #647553

  • RE: An oppertunity to get a new SQL Comparison tool for free

    Don't reply to these except when first posted (or freshly replied to). It puts them back at the top of the list.

    Tim Wilkinson

    "If it doesn't work in practice, you're using the wrong theory"
    - Immanuel Kant

    July 5, 2006 at 9:49 am

    #647541

  • RE: Functions with internal Sorting - is it cached?

    You are right that each time the function is called, it will undertake a sort operation.

    I'll reiterate. The sort process involves only a small number of 'child' records (as restricted...

    Tim Wilkinson

    "If it doesn't work in practice, you're using the wrong theory"
    - Immanuel Kant

    July 5, 2006 at 9:39 am

    #647537

  • RE: rotate a table

    >he knows all the columns, I do not. It will be passed into procedure and vary at all the time.

    Eric knows the columns in the 'before' recordset, but not the...

    Tim Wilkinson

    "If it doesn't work in practice, you're using the wrong theory"
    - Immanuel Kant

    July 5, 2006 at 9:16 am

    #647529

  • RE: Primary Key Column

    /*this is designed for v8, but written on v9.
    I'm fairly certain it's v8-compatible.*/
    --

    select

    u.name tabowner

    Tim Wilkinson

    "If it doesn't work in practice, you're using the wrong theory"
    - Immanuel Kant

    July 5, 2006 at 8:50 am

    #647517

  • RE: @Local_Variable 8k Limit

    BTW, surprisingly but conveniently, "+" used in the EXEC() function (unlike, say, the LEN() function) is a param delimiter, not a concatenation operator!

    declare

    @null

    Tim Wilkinson

    "If it doesn't work in practice, you're using the wrong theory"
    - Immanuel Kant

    July 5, 2006 at 6:12 am

    #647478

  • RE: Identifying which schedule initiated Job to run

    sysjobservers must have been a view on MSDB tables. I can't be sure because I haven't got a SQL8 instance to hand. See what I mean about it being easier...

    Tim Wilkinson

    "If it doesn't work in practice, you're using the wrong theory"
    - Immanuel Kant

    July 5, 2006 at 4:52 am

    #647463

  • RE: How does one select EVERY Nth row from a table?

    If you literally want precisely every Nth row, then you would also need to do something similar to Ryan's suggestion if the table with the identity column has had deletions.

    If you...

    Tim Wilkinson

    "If it doesn't work in practice, you're using the wrong theory"
    - Immanuel Kant

    July 5, 2006 at 4:42 am

    #647461

  • RE: Identifying which schedule initiated Job to run

    You can get that info from poking around in MSDB.

    But it might be easier and the code clearer just to have table which the monthly proc writes to, specifying the...

    Tim Wilkinson

    "If it doesn't work in practice, you're using the wrong theory"
    - Immanuel Kant

    July 5, 2006 at 4:01 am

    #647446

  • RE: Updating rows in table from Select query

    You only need the nested inline views (derived tables) because you are using

    (select 'A' as col1, 101 as col3

    union all select 'B', 203

    union all select 'C', 204

    union...

    Tim Wilkinson

    "If it doesn't work in practice, you're using the wrong theory"
    - Immanuel Kant

    July 4, 2006 at 6:20 pm

    #647400

  • RE: rotate a table

    http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=291926

    Tim Wilkinson

    "If it doesn't work in practice, you're using the wrong theory"
    - Immanuel Kant

    July 4, 2006 at 6:05 pm

    #647399

  • RE: Create procedure conditionally

    A person might have an environment which contains new versions of a only a subset of the procedures required. Perhaps only the procs from a particular functional area of a db app exist...

    Tim Wilkinson

    "If it doesn't work in practice, you're using the wrong theory"
    - Immanuel Kant

    July 4, 2006 at 5:49 pm

    #647398

    • Viewing 15 posts - 106 through 120 (of 582 total)