Forum Replies Created

Viewing 15 posts - 45,946 through 45,960 (of 59,062 total)

  • RE: Date Range of Week

    bdewulf (1/13/2009)

    I'm getting an incorrect syntax error when I do From dbo.Calendar. I am using MS Sql 2000 and I don't see this table.

    Just to clarify my original post....

    January 13, 2009 at 8:39 am

    #925943

  • RE: The T-SQL Quiz

    Grant Fritchey (1/13/2009)

    Jeff Moden (1/13/2009)

    True enough, 2000 is out of support... now, tell me it's out of use. Hmmm... that would make a good survey question... I'll think there's...

    January 13, 2009 at 8:33 am

    #925930

  • RE: Inserting a value in an ordered string

    Mark,

    VERY clever code... I obviously never thought of using PatIndex and a variable for the first character of a range... And, it's about twice as fast as the Tally table...

    January 13, 2009 at 7:07 am

    #925847

  • RE: Inserting a value in an ordered string

    Mark, if you do a final replace of ")" with "& # 0 4 1 ;" (without the spaces), then your code wil show correctly without all those...

    January 13, 2009 at 6:45 am

    #925819

  • RE: Don't Let the Economic Downturn Get You Down

    James Stover (1/10/2009)

    Plus, I don't have to put up with the inane performance review. A truly evil piece of work devised by some twisted HR megalomaniac. My only measure of...

    January 13, 2009 at 6:40 am

    #925814

  • RE: Don't Let the Economic Downturn Get You Down

    Steve Jones - Editor (1/11/2009)

    I'd like to think that's the minority, but who knows. When you're struggling to find a job, you can really be driven to do things. At...

    January 13, 2009 at 6:25 am

    #925803

  • RE: The T-SQL Quiz

    How odd... here we're talking about portability between releases of SQL Server... the ANSI-only folks would have a ball with this. Of course, then I'd have to launch some...

    January 13, 2009 at 6:13 am

    #925792

  • RE: The T-SQL Quiz

    Grant Fritchey (1/13/2009)

    Jack Corbett (1/12/2009)

    Sergiy (5/28/2007)

    If you don't specify the version that means it must work on EVERY version, not only the one you know.

    Of course these means that CTE's...

    January 13, 2009 at 6:09 am

    #925789

  • RE: Virtualization forum section

    GilaMonster (1/12/2009)

    That was about a week before he referred to me as a "clueless idiot" in a mail to my manager after I had requested RAID 10, dedicated disks for...

    January 12, 2009 at 1:28 pm

    #925546

  • RE: Separate full name into diff fields

    Steve Jones - Editor (1/12/2009)

    You could grab the prefix like this

    case

    when substring( namefield, 1, charindex(' ', namefield) = 'Mr'

    then prefix = 'Mr'

    when substring( namefield, 1,...

    January 12, 2009 at 1:26 pm

    #925541

  • RE: Where 1 = 1

    GSquared (1/12/2009)

    Agree with you on most points.

    I like the Inner Join syntax. Makes it easier for me to read (not for you, but it does for me).

    That would...

    January 12, 2009 at 1:14 pm

    #925532

  • RE: Inserting a value in an ordered string

    Sergei Ely (1/12/2009)

    John,

    The code worked perfectly. 😀 Thanks again.

    Sergei

    Heh... actually, it's "Jeff" but I appreciate the feedback anyway. Thanks, Sergei. 🙂

    January 12, 2009 at 12:48 pm

    #925504

  • RE: One database per customer or One DB for all customers

    On the other hand, Backups and Restores work very well for individual databases and also allows for a multi-server environment which has both it's own pains and advantages.

    The bottom line...

    January 12, 2009 at 9:57 am

    #925380

  • RE: How to get start and end value from a sequence of numbers - Grouped by a different field.

    gvsriramakrishna (1/11/2009)

    Oops.. there seems to be an error in th SQL query at the over keyword.

    Incorrect syntax near the keyword 'OVER'.

    No... I wanted to know how the UPDATE solution works....

    January 12, 2009 at 6:32 am

    #925223

  • RE: highest unused ID

    Grant Fritchey (1/11/2009)

    Beating accepted. 😀

    I just remember seeing the solution in his book. It's not something I played with a lot myself, mainly because I long stopped worrying about gaps...

    January 12, 2009 at 6:24 am

    #925215

Viewing 15 posts - 45,946 through 45,960 (of 59,062 total)