Viewing 15 posts - 841 through 855 (of 3,221 total)
Jeff - you have summed it up perfectly........ I have been in situations as you described, unfortunately going to hell in a hand basket all to fast and way too...
November 27, 2011 at 4:21 pm
The only thing I can suggest is, have you looked at the use of the PIVOT statement? I would suggest reading:
November 26, 2011 at 7:11 pm
First order of business. Why is the T-SQL statement passing the following parameters
The stored procedure has the following input parameters
--Your parameters ...
November 26, 2011 at 6:11 pm
As Sherlock Holmes said to Dr. Watson ................ Very interesting
November 26, 2011 at 5:08 pm
From Books On Line (The TSQL help file). It this this thing you are attempting?
sp_executesql supports setting of parameter values separately from the Transact-SQL string:
DECLARE @IntVariable INT;
DECLARE @SQLString...
November 26, 2011 at 11:08 am
I take it this is a home work question.
But here is a very simple example
CREATE PROCEDURE [dbo].[_AATT_Find_entry]
@LookFor VARCHAR(50)
AS
SELECT entryid,entry,RTRIM(description)+CHAR(10)+char(13),(snippet)
+CHAR(10)+char(13),[type],Version.sqlname+CHAR(10)+char(13)
FROM logentries
JOIN Version ON
logentries.sqlid =...
November 26, 2011 at 10:08 am
If you are using as SP or even a dynamic T_SQL statement to do the insert, I suggest that you modify it to include a TRY CATCH block, so if...
November 26, 2011 at 9:27 am
Jeff Moden (11/22/2011)
Multiply QUANTITY in Ron's answer by 100000 first, convert it to an INT, and then apply Ron's answer.
Thanks Jeff - I goofed reading the OPs question and I...
November 22, 2011 at 10:27 pm
Is this what you require?
DECLARE @Quantity AS DECIMAL(20,5)
SET @Quantity = -3.45
IF @Quantity < 0
BEGIN
SET @Quantity = @Quantity * -1
...
November 22, 2011 at 10:15 pm
Posted Today @ 2:23 PM
By the time I was driving down that far on the Parkway, there was the high bridge, but then I remember that from going down the...
November 22, 2011 at 1:34 pm
Stefan Krzywicki
I'm used to NJ and Boston traffic. One of my first jobs was driving a truck route in Manhattan. Columbus's traffic isn't, or at least shouldn't be, in that...
November 22, 2011 at 11:35 am
Stefan Krzywicki (11/22/2011)
jcrawf02 (11/22/2011)
Stefan Krzywicki (11/22/2011)
November 22, 2011 at 10:59 am
Ninja's_RGR'us (11/22/2011)
What do you guys think of this as a first house?http://passerelle.centris.ca/Redirect2.aspx?CodeDest=I2V&NoMls=MT8619554&Source=
Fantastic house, location seems perfect.
Only one drawback that I can think of, and that drawback is when sitting at...
November 22, 2011 at 7:44 am
hkflight (11/21/2011)
Hi Ron,I follow your logic perfectly and expect the same results. Could this issue have to do with the fact that I am querying a view?
Once again I...
November 21, 2011 at 6:36 pm
Viewing 15 posts - 841 through 855 (of 3,221 total)