Forum Replies Created

Viewing 15 posts - 31 through 45 (of 217 total)

  • RE: sessionID and query

    Oh ok,

    Well each table will have a sessionID column that identifies which session the data belongs to.

    A table row cannot exist without a sessionID entry.

    So maybe I...

  • RE: sessionID and query

    I guess I should have stated that the sessionID is inserted into every table when the stored procedure is called.

    So there would be no chance of a sessionID be...

  • RE: Tables and Stored Procedures

    you know what? I think you are right...now there is no reason for this to be a temp table!

    Thanks!

  • RE: Tables and Stored Procedures

    Oh ok, so basically I could get the sessionID in asp.net, and then pass that to the SPROC. And inside my "temp" table, I could add another column for...

  • RE: Tables and Stored Procedures

    Thanks everyone!

    I don't think I would be able to use a .NET session or state table, because I need it to be in SQL Server.

    Reason being, is...

  • RE: Tables and Stored Procedures

    Thanks!

    Would 2 or more users then be able to run this stored procedure without "bumping" into each other?

    I think the way I have it setup now, is that...

  • RE: Help with group by

    No, it was the full code...should I put an order by in there?

    Thanks

  • RE: Help with group by

    Well it didn't group by group, institution, and then user. They are still all mixed up in the search results. I should have been more clear in what...

  • RE: stupid stupid stupid restore problem

    No, I never did find a backup. It wasn't too terrible because the system was only a development system. But it definitely taught me a lesson!

  • RE: stupid stupid stupid restore problem

    Ok, all I see is FULL in the backup_type. How do I turn on transactional logs?

    Thanks!

  • RE: stupid stupid stupid restore problem

    How do I know if I have any transaction logs?

    Thanks for all the input!

  • RE: Restore options

    but it is the correct backup file. I even tested it again...and the files in the restore as option are always different from the actual name of the database.

    Here...

  • RE: help with query

    Thanks...I figured that the best way to do this was just add the needed table to the full text catalog. 🙂

  • RE: Get count of each ID in query

    How can I add a partition Count column to my big query? Is that possible?

    Thanks!

  • RE: Get count of each ID in query

    Here's what I have so far. As you can see, I tried adding a column that COUNTs the nodeIds. But I just get 1 for every row.

    SELECT nl.nodeId,...

Viewing 15 posts - 31 through 45 (of 217 total)