Viewing 8 posts - 16 through 23 (of 23 total)
Perhaps this is a dumb question, but have you tried:
EXEC SP_WHO2
September 29, 2010 at 6:55 am
Yeah, if you are still having trouble, please do describe the process your attempting to complete. Though double quotes are the usual, you could really use any character in...
August 10, 2010 at 1:29 pm
Well, you should always be prepared by the form of backups. The justification of course being for what you are dealing with now and the loss of time and...
July 20, 2010 at 8:57 am
I'm not sure exactly where to start here. So I don't mean to offend... hopefully I can help you get started and other people helping for your answer.
Are...
July 19, 2010 at 11:12 pm
For ease, I believe a trigger is the route you should go. You can trigger it on update without any modifications to end users or applications.
July 19, 2010 at 1:20 pm
So you want the days of the week with the count of information below it? (pivot)
July 19, 2010 at 12:52 pm
This looks like id, parent_id to me. If so, you just need to use a recursive script.
http://www.sqlservercentral.com/articles/Development/recursivequeriesinsqlserver2005/1760/
July 19, 2010 at 6:40 am
I guess it would depend on how you are reading the file, but usually double quotes (") are what you use to wrap a string column on a CSV.
July 19, 2010 at 6:30 am
Viewing 8 posts - 16 through 23 (of 23 total)