Viewing 15 posts - 1 through 15 (of 51 total)
Ian Elliott (9/11/2008)
I think the wording could have been better e.g. specifically saying using SSMS would've been more accurate. I don't like questions that make assumptions for you.
I agree,...
September 11, 2008 at 3:20 am
ALZDBA (9/10/2008)
And off course you'll need to have the default 'go' for batch...
September 10, 2008 at 4:06 am
Christian Buettner (9/1/2008)
So how about including the author in the QOTD description?...
September 1, 2008 at 4:15 am
Michael Kipp (8/28/2008)
Please don't confuse "database files" with "data files".A database is more than just a data file.
According to the link provided with the QOD, .mdf, .ndf and .ldf all...
August 28, 2008 at 4:28 am
dgvsbabu (8/28/2008)
It should be 1,5,2,3,3,2
I don't think it should be, can you explain why?
August 28, 2008 at 1:45 am
Aleksandr Furman (8/27/2008)
skyline666 (8/27/2008)
Yes thats a good point, temporary tables only exist for the life of the stored procedure (when prefixed with one #), I temporarily forgot about that ;).
That's...
August 27, 2008 at 7:46 am
I don't know if its just me or not, but the picture's aren't there. Good article by the way.
August 27, 2008 at 7:07 am
Yes thats a good point, temporary tables only exist for the life of the stored procedure (when prefixed with one #), I temporarily forgot about that ;).
August 27, 2008 at 7:04 am
YeshuaAgapao (8/26/2008)
You forgot to put drops for you temp tables (#data, #category) at the end of the code block.
That doesn't affect the end result tho ;).
August 26, 2008 at 11:47 am
Thats good saurabh.k.singh.
May I suggest that if you changed the declaration @NumPart from int to float, and @AddNum from int to float, then you will be able to add decimal...
August 26, 2008 at 8:39 am
That points to vb.net, whereas im using vb6 :). I had solved it before, was really simple actually:
Private Sub lstRiskDescription_Click()
Me.RiskID = Me.lstRiskDescription.SelectedItem
End Sub
Ive come to...
August 26, 2008 at 3:56 am
ian treasure (8/26/2008)
Shouldnt this beSELECT C.CATID, COUNT(*)
FROM #DATA DINNER
JOIN #CATEGORY C ON (C.VAL1 = DINNER.VAL1) OR (C.VAL1 IS NULL)
GROUP BY C.CATID
(was ON C.VAL1 = D.VAL1)
Nope, its this:
SELECT C.CATID,...
August 26, 2008 at 3:07 am
Actually I do have one more query. I have an unbound text box on the form the listview is on, and when I click an item in the listview,...
August 22, 2008 at 4:45 am
Solved it. You need to have column headers set up, so that you can actually put data into that column, who'd of thought it :hehe:!. There is an...
August 22, 2008 at 3:04 am
Viewing 15 posts - 1 through 15 (of 51 total)