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...

The only thing I can suggest is, have you looked at the use of the PIVOT statement? I would suggest reading:

http://www.sqlservercentral.com/scripts/T-SQL/70819/

First order of business. Why is the T-SQL statement passing the following parameters

The stored procedure has the following input parameters

--Your parameters ...

As Sherlock Holmes said to Dr. Watson ................ Very interesting

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...

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 =...

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...

Thanks Jeff - I goofed reading the OPs question and I...

Is this what you require?

DECLARE @Quantity AS DECIMAL(20,5)

SET @Quantity = -3.45

IF @Quantity < 0

BEGIN

SET @Quantity = @Quantity * -1

...

Thanks for the question

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...

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...

Stefan Krzywicki (11/22/2011)

---

jcrawf02 (11/22/2011)

---

Stefan Krzywicki (11/22/2011)

---

I lived in Columbus, OH for awhile, they're too small to have traffic with the road system they have, but they still manage to create...

Fantastic house, location seems perfect.

Only one drawback that I can think of, and that drawback is when sitting at...

Once again I...