carmellabanker (3/6/2012)

---

TIP

If you want to keep a Desktop Alert visible so that you can take more time to read it, rest the pointer on the alert...

Mmm..... SPAM...

Sean Lange (3/6/2012)

---

HOLY!!!!!!!!!

There are over 30 subselects and somewhere around 5-6 scalar functions. Even if you got that to work you might as well go out for lunch while it...

that's a bit much for me to take on. It is really "dirty" and complex. The error means that something in the view is returning more than one...

ard5karthick (3/6/2012)

---

The Way SQL Server Works is like this...

It will First Fetch The Rows Having ItemID = 1;

On This Result It will search for Rows Having ItemID = 3

So The...

Try this:

--ComputeSizeDescription

CREATE FUNCTION dbo.ComputeSizeDescription

(

@itemForm INT,

@width FLOAT,

@len FLOAT

) RETURNS VARCHAR(128)

WITH EXECUTE AS CALLER

AS

BEGIN

DECLARE @descr varchar(128)

SELECT @descr = CASE @itemForm

-- @Width Only Items

WHEN 2 THEN CAST(@Width AS VARCHAR(128)) + '"'

WHEN 3 THEN...

It is the RETURN. You are returning a VARCHAR when the value is a FLOAT.

siva 20997 (3/6/2012)

---

I agree that my code is little bit heavier on execution

but there are a few reasons

1) I come from a windows programming background and making the execution plan...

DBA Rafi (3/6/2012)

---

Dear All,

I have two tables in my OLTP.

Table1 with C1, C2 columns. and

Table2 with D1, D2 columns.

Mostly, when i SELECT Table2, I will join with Table1...

Jeff Moden (3/6/2012)

---

SQLKnowItAll (3/5/2012)

---

I like to describe my descriptions 🙂 (Sorry, I couldn't figure out a better way.) So, in a Product table I may use a column name...

MR@SD (3/5/2012)

---

Then just run two SELECT statements, insert both result sets into the same temp table (make the column match) and output it via another SELECT in the order of...

Well, being that by typing in the text here it will automatically change the display,...

shannonjk (3/5/2012)

---

Greetings 😀

So there has to be a file somewhere that stores your SSMS options. Like when you copy/paste to include headers, font colors/types etc. Does anyone know where this...

I like to describe my descriptions 🙂 (Sorry, I couldn't figure out a better way.) So, in a Product table I may use a column name of prodDesc, product_description,...

guerillaunit (3/5/2012)

---

Hi Eugene,

I'd like to divide the statement into separate subscripts because the subscripts need to be processed in sequence. I was opening to use the GO command so...