Viewing 15 posts - 14,701 through 14,715 (of 26,486 total)
GSquared (2/25/2011)
JP Dakota (2/23/2011)
I was once asked for the absolute value of Pi. There isn't one.
You wasted a perfect opportunity to spend the rest of the interview spewing out...
March 14, 2011 at 1:01 am
It isn't the number of columns that determines how much spacea row takes in the database, but the size of each row plus the fill factor used on the table.
March 14, 2011 at 12:54 am
visweswaran28 (3/14/2011)
I am using sql server 2005, in that I am directly running my sql queries. Now I want to know that how can I rollback if I did anything...
March 14, 2011 at 12:50 am
Jeff Moden (3/13/2011)
Lynn Pettis (3/13/2011)
Jeff Moden (3/13/2011)
March 13, 2011 at 8:48 pm
Jeff Moden (3/13/2011)
March 13, 2011 at 8:13 pm
Jeff Moden (3/13/2011)
pietlinden (3/13/2011)
Now all I gotta do is get my head around how it all works. Thanks, Jedi master!
Me too. I always seem to lose my mind...
March 13, 2011 at 4:23 pm
Without seeing the code for the trigger, it is a bit hard to know why you can't delete it. Sounds like it may be keeping you from doing the...
March 13, 2011 at 11:44 am
Two alternatives to Ian's code as well (minor tweaks) still using his setup:
WITH msgHierarchy AS (
SELECT msg.MessageID, msg.ParentID, msg.[Message], msg.PostedDate
...
March 13, 2011 at 11:21 am
kp81 (3/13/2011)
I've been playing with the code (works great btw), however I have one issue. I'd like to order the items by messages DESC, but comments ASC - if that's...
March 13, 2011 at 11:17 am
The following code returns what you are looking for based on the sample data provided. Please let us know if it works for you in your particular application.
select
...
March 13, 2011 at 11:00 am
Glad I was able to help. Also, thank you for posting your final solution.
March 13, 2011 at 10:09 am
Hard to say since we can't see what you can see. Please read the first article I reference below in my signature block regarding asking for help. It...
March 13, 2011 at 5:18 am
Here is what I cam up with based on your sample data:
with CoursePrereqs (
CourseName,
CourseNo,
reqCourseNo,
nextCourseNo
)as...
March 13, 2011 at 5:12 am
What will really help is to provide the information I requested. Based on what you have given us, we can only provide very basic guidance. If you provide...
March 8, 2011 at 10:17 am
It would actually help if you would provide the DDL (CREATE TABLE statement), sample data (as a series of INSERT INTO statements) that reflects the problem you are attempting to...
March 8, 2011 at 6:46 am
Viewing 15 posts - 14,701 through 14,715 (of 26,486 total)