Manic Star (9/23/2015)

---

patricklambin (9/23/2015)

---

I don't think so. These functions have been introduced only to make easier the translation...

This can certainly be performance tuned but will work:

-- easily consumable sample data

DECLARE @table TABLE(ID int, value decimal (3,1))

INSERT @table

SELECT 1111,14.0 UNION ALL

SELECT 1111,14.0 UNION ALL

SELECT 2222,13.0 UNION ALL

SELECT 2222,13.0...

@Wayne

Was this your intended 2012 solution:

-- SQL SERVER 2012 version:

SET STATISTICS IO ON;

SELECT

RowID,

CODE,

COLUMN1,

COLUMN2,

RunningTotal =

...

kdejan87 (9/23/2015)

---

What do you think about this:

DECLARE @t1 TABLE (

CODE nvarchar(20),

COLUMN1 numeric(18, 2),

COLUMN2 numeric(18, 2)

)

INSERT INTO @t1 (CODE, COLUMN1, COLUMN2)

VALUES ('432',...

Sean Lange (9/21/2015)

---

WayneS (9/21/2015)

---

Alan.B (9/21/2015)

---

The homework assignment may dictate that the problem be solved with a cursor. Anyone who is good with cursors want to take a look at this?...

The homework assignment may dictate that the problem be solved with a cursor. Anyone who is good with cursors want to take a look at this?

ITU_dk2012 (9/20/2015)

---

@Alan,

Thank you for the code example. I am just learning T-SQL and don't know the advanced stuff in T-SQL. I am using Cursors to get the first value, the...

The Data warehouse toolkit that Louis mentioned is awesome - that has been the best book I have read about the whole data warehouse/BI life cycle. It's a shame that...

No problem.

Koen Verbeeck (9/11/2015)

---

Did you read Star Schema The Complete Reference...

Just ran across this script - it works quite nicely for me.

ITU_dk2012 (9/17/2015)

---

Hi all,

I have a column in a table which holds list of values. I would like to find the first value, the highest value(Peak Value), and the last value...

Here's what you are looking for:

WITH

dataSets AS

(

SELECT

DatasetName = xxx.value('(@Name)[1]','varchar(100)'),

ParameterDatasetReferenceTxt = xxx.value('(.//*:CommandText/text())[1]','varchar(1000)')

FROM (VALUES(@XML)) T(X)

CROSS APPLY X.nodes('//*:DataSet') xxx(xxx)

),

params...

First, welcome to SQLServerCentral. Please note the link in my signature line for the best way to get help here...

I don't know exactly what you are looking for but...

if I understand your question correctly....