Forum Replies Created

Viewing 15 posts - 31 through 45 (of 1,109 total)

  • RE: physicaly Deleted LOG file...want new databse to point to MDF file.

    GilaMonster (8/21/2008)


    Provided the database was shut down cleanly, that is.

    That is correct, thanks Gail. In case the database has not been shut down cleanly, you can still rescue most of...

  • RE: change rows to columns

    Peso (8/21/2008)


    He only has to read the replies here

    http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=109222

    Well spotted :), the answer there (at the time of this post) addresses the problem if the pivot values are static. If...

  • RE: change rows to columns

    What you need (since you are on SQL Server 2005) is pivots with dynamic SQL. I've put some examples on:

    http://www.simple-talk.com/community/blogs/andras/archive/2007/09/14/37265.aspx

    Regards,

    Andras

  • RE: physicaly Deleted LOG file...want new databse to point to MDF file.

    nairsanthu1977 (8/21/2008)


    Dear All,

    I physicaly deleted LOG file of one database. I have the MDF file with me now. I want to create a database to point...

  • RE: Clearing LOD file (126 GB)

    nairsanthu1977 (8/21/2008)


    Hello,

    The problem is that SSMS itself is not opening....Without query analyzer how will I fire the command..?

    You can use sqlcmd from command line for example. Or run...

  • RE: How much longer will Microsoft support SQL 7.0 for?

    onlo (8/21/2008)


    But what is "Extended support" ?

    Does it mean if we have had "Extened support" from Microsoft, we can still have Microsoft technical support services on our SQL 7.0 systems...

  • RE: Clearing LOD file (126 GB)

    And after you follow Hadrian's advice, take a full backup. Then find out if that database had any periodic full/log backups. If yes, try to find the reason for the...

  • RE: Query help needed ...

    PS: thanks for providing table definition, test data and expected results in your question, hope this will get you the best & right answer 🙂

    - Andras

  • RE: Query help needed ...

    Assuming that you want to maintain the ordering, i.e. all the first rows have lower id than the next rows (and I assume the row ordering is by the col1),...

  • RE: Help needed

    mohd.imtiaz (8/21/2008)


    Hi Andras,

    Thanks for your spontaneous reply, it was really kind of you.

    I tried your query in sql 2005 it was woring fine over there.

    Is it possible...

  • RE: Dynamic script

    Carl B. (8/20/2008)


    Thank's Andras,

    Can I get back the result of the execution of @q and use it afterwards?

    Best regards.

    Carl

    You can do this too. One way of doing this is to...

  • RE: Help needed

    mohd.imtiaz (8/20/2008)


    i have a table say for example

    c1 c2 c4

    --------------

    a b 01,05

    z y 10,15,20

    ...

  • RE: Dynamic script

    Carl B. (8/20/2008)


    Hello Everyone,

    We would like to have a T-SQL script to purge some data based on several conditions (not trivial).

    What is the most complicated is that we do not...

  • RE: delete records

    karthikeyan (8/20/2008)


    Andras,

    t would probably be a poor choice if you do not want to get rid of every row in your table.

    You mean we need to use TRUNCATE if we...

  • RE: delete records

    karthikeyan (8/20/2008)


    TRUNCATE may help for your need.

    You have to frame your question better. Also please post your requirement clearly.

    While I agree with Karthik that TRUNCATE may help you, it would...

Viewing 15 posts - 31 through 45 (of 1,109 total)