Viewing 15 posts - 121 through 135 (of 149 total)
Oh ok gotcha. Probably 100 ways to do it, here's my quick try. Use this and come up with something better. Now that I look at I almost deleted...
February 25, 2009 at 8:57 pm
Maybe this will help get you going???
CREATE TABLE Proj
(ProjId INT
,ProjDt DATETIME
)
go
CREATE TABLE ProjComments
(PCID int
,ProjID int
,Comment varchar (400)
,CommentDt datetime
)
INSERT INTO Proj VALUES (1,GETDATE()), (2, '1/1/09')
INSERT ProjComments VALUES (100,1,'COMMENT', '2/1/09'), (200,1,'COMMENT2',...
February 25, 2009 at 6:40 pm
Cant you simply create a derived table and join back to your main table (correlated subquery), the derived to include top 5 order by the date desc?
February 25, 2009 at 6:02 pm
I agree, not sure why you would ever want the same data in another column; maybe you should make it null or add a placeholder, and then do some calculation...
February 25, 2009 at 5:43 am
I've noticed that they keep removing shortcuts as well (although I haven't gone to see if they're addable...), such as CTL + B in SQL 7 and 2000 to size...
February 25, 2009 at 5:21 am
We have a situation where we have TEMPDB on the same disk as the user databases. Also, we have read the research where the consensus is to put TEMPDB...
February 24, 2009 at 7:02 pm
You may also have to look in SSMS at Query>>Query Options>> Results - Text and change "Maximum number of characters displayed in each column" to 8000. Think that's the max...
February 24, 2009 at 6:54 pm
So try a qdf.Execute and see if it gives you option. qdf won't run by itself I don't believe.
Lee
February 24, 2009 at 11:52 am
February 24, 2009 at 11:49 am
I haven't done access programming in years, but just looking at it, I don't see where you have given a command to actually execute the stored proc. Can you check...
February 24, 2009 at 11:40 am
You would need to add it to a BIDS solution in Visual Studio to edit; options for SQL Server are to save to an SSIS box (a server running integration...
February 24, 2009 at 11:36 am
February 24, 2009 at 11:27 am
Excellent question - a client asked me that today and I couldnt answer so I tried it. Gives an error to run DBCC Checktable to check sysindexes. Definitely cannot go...
April 24, 2008 at 9:59 am
March 7, 2008 at 6:49 am
Viewing 15 posts - 121 through 135 (of 149 total)