Viewing 15 posts - 31 through 45 (of 217 total)
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...
November 12, 2009 at 7:21 am
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...
November 11, 2009 at 11:50 am
you know what? I think you are right...now there is no reason for this to be a temp table!
Thanks!
October 30, 2009 at 8:45 am
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...
October 29, 2009 at 8:30 am
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...
October 29, 2009 at 7:22 am
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...
October 28, 2009 at 2:32 pm
No, it was the full code...should I put an order by in there?
Thanks
September 22, 2009 at 11:16 am
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...
September 22, 2009 at 8:20 am
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!
February 24, 2009 at 8:10 am
Ok, all I see is FULL in the backup_type. How do I turn on transactional logs?
Thanks!
February 16, 2009 at 8:34 am
How do I know if I have any transaction logs?
Thanks for all the input!
February 16, 2009 at 8:23 am
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...
February 13, 2009 at 8:49 am
Thanks...I figured that the best way to do this was just add the needed table to the full text catalog. 🙂
February 4, 2009 at 12:43 pm
How can I add a partition Count column to my big query? Is that possible?
Thanks!
January 21, 2009 at 11:40 am
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,...
January 21, 2009 at 8:56 am
Viewing 15 posts - 31 through 45 (of 217 total)