Forum Replies Created

Viewing 15 posts - 541 through 555 (of 921 total)

  • RE: Random record set selection

    quote:

    1. A temp table matching your spec is created, with a number from 1 to 25, and a question.

    2. I...



    --Jonathan

    November 5, 2003 at 5:48 am

    #480869

  • RE: Backup

    quote:

    Thanks Jonathan.

    Does that mean that the backup, when restored (with recovery), is a snapshot in time at the instant the backup job...



    --Jonathan

    November 3, 2003 at 3:52 pm

    #480709

  • RE: Backup

    This changed between versions 6 and 7. The method was changed to a "fuzzy" backup where there is no "snapshot" synchonization but instead extents are backed up serially and...



    --Jonathan

    November 3, 2003 at 3:18 pm

    #480707

  • RE: Win2003 Enterprise (32 bit) and SQL 2k ENT(64bit)

    quote:

    I think you can't.

    I know you can't.

    --Jonathan



    --Jonathan

    November 3, 2003 at 2:04 pm

    #480701

  • RE: Please help...

    Use TOP 1 with your query as a derived table:

    

    SELECT TOP 1 MaxStep, CaseNum, StepEndDt

    FROM

    (SELECT max(StepNum) AS MaxStep, CaseNum, StepEndDt

     FROM Loan_Step

     WHERE CaseNum = '200668'

    ...



    --Jonathan

    November 3, 2003 at 8:10 am

    #480654

  • RE: cross tabs quesry?

    quote:

    After saying or supporting all of this, how can you now say that SQL Server would be doing the grouping and aggregation?...



    --Jonathan

    November 3, 2003 at 6:47 am

    #480632

  • RE: cross tabs quesry?

    quote:

    While Schiller is certainly a class of its own, Dilbert is more intuitive to the majority of people.



    --Jonathan

    October 31, 2003 at 4:27 pm

    #480545

  • RE: cross tabs quesry?

    quote:

    "Against stupidity the gods themselves struggle in vain."

    An indeed true sentence from one of the greatest germans ever...



    --Jonathan

    October 31, 2003 at 3:04 pm

    #480538

  • RE: cross tabs quesry?

    quote:

    Looking beyond this example and considering a typical crosstab query...

    Are you saying that the grouping and aggregation done in a typical crosstab...



    --Jonathan

    October 31, 2003 at 2:54 pm

    #480533

  • RE: cross tabs quesry?

    quote:

    I agree, it's amazing how often this question or something very similar is asked. And more and more I come to the...



    --Jonathan

    October 31, 2003 at 2:06 pm

    #480506

  • RE: Using variables with IN clause

    http://www.algonet.se/~sommar/arrays-in-sql.html

    --Jonathan



    --Jonathan

    October 31, 2003 at 11:51 am

    #480475

  • RE: Transaction Log and STOPAT !!

    quote:

    Now, is there a way to roll back to 6:15PM when I first applied the transaction log with a STOPAT of 6:19PM?



    --Jonathan

    October 31, 2003 at 11:48 am

    #480474

  • RE: Conversion from SQL Server 6.5 to 2000

    It is still supported . However (from the SQL Server 20000 BOL):

    quote:

    Any statements using the Transact-SQL outer joins should be changed...



    --Jonathan

    October 31, 2003 at 8:27 am

    #480462

  • RE: Can we change licensing mode in Sqlserver 2000 ??

    Removing and then reinstalling SQL Server is the supported method. I'd hack the registry.

    --Jonathan



    --Jonathan

    October 31, 2003 at 6:13 am

    #480431

  • RE: UTC Dates

    quote:

    Sorry that I'm coming into this a little late, but why don't you store the dates in UTC format. Then create a...



    --Jonathan

    October 31, 2003 at 5:26 am

    #480426

    • Viewing 15 posts - 541 through 555 (of 921 total)