vinu512 (6/18/2012)

---

You can do it like this as well:

--Creating Temporary Table

CREATE TABLE #Test

(

DateTimeStamp datetime,

Value int

)

--Inserting Sample Data

INSERT INTO #Test SELECT '2012-06-15 16:00:00.000',4

INSERT INTO #Test SELECT '2012-06-15 2:05:00.000',5

INSERT INTO #Test...

That's because I didn't notice that Horse is the exception where it should be < while the others are greater than.

You can change the logic on the INNER JOIN to...

Presumably so but IMHO it is messier.

Personally, I like to pass as...

Like this:

DECLARE @Result1 NVARCHAR(100),

@ResultValue1 NVARCHAR(100),

@Result2 NVARCHAR(100),

@ResultValue2 NVARCHAR(100),

@Result3 NVARCHAR(100),

@ResultValue3 NVARCHAR(100),

@Result4 NVARCHAR(100),

@ResultValue4 NVARCHAR(100)

SET @Result1 = 'Cat'

SET @ResultValue1 = 200--(Greater Than...

etirem (6/17/2012)

---

The below values need to be passed as parameters from SSRS report and these values may change everytime the report is ran. So they cannot be put into a...

Thomas Stringer (6/17/2012)

---

For what it's worth, at least for me, the light bulb really comes on with XML and it's much easier to understand when you actually practice with it....

I...

No need to pass 4 parameters. Below, I haven't created your SP but have given you everything you need to do so.

DECLARE @XML1 XML, @XML2 XML

IF object_id ('Tempdb..#pTable') IS...

I believe that this will also produce satisfactory results:

;WITH CTE AS (

SELECT DateTimeStamp, Value

,n=ROW_NUMBER() OVER (

...

On the other hand, perhaps the solution is as simple as this:

DECLARE @t TABLE (column1 VARCHAR(20))

INSERT INTO @t

SELECT 'p = 30'

UNION ALL SELECT 'q = 50'

UNION ALL SELECT 'r =...

Lowell (6/15/2012)

---

dwain.c (6/14/2012)

---

Lowell - Another nice learning experience from you. That's now 2 in as many days!

I see this was introduced in SQL 2005. Any idea if it...

Lynn Pettis (6/15/2012)

Not running your code, but what do you return if the mobility indicator is not 1? The OP indicated that it should be blank.

Plus, I find the...

Kingston Dhasian (6/15/2012)

---

dwain.c (6/15/2012)

---

Kingston Dhasian (6/15/2012)

---

Yes, the OP's statement actually...

My findings were overall (multiple runs) about 3% decrease in execution time on a single UNPIVOT. CPU savings were about 30% though.

Double UNPIVOT was 30% and 30%.

Kingston Dhasian (6/15/2012)

---

Yes, the OP's statement actually made us feel...