Gary Varga (12/3/2014)

ccd3000 (12/2/2014)

Ed Wagner (12/3/2014)

Jim_K (12/2/2014)

djj (12/2/2014)

Ed Wagner (12/2/2014)

djj (12/2/2014)

Ed Wagner (12/2/2014)

whereisSQL? (12/2/2014)

Ed Wagner (12/2/2014)

SQLRNNR (12/2/2014)

Ed Wagner (12/2/2014)

SQLRNNR (12/2/2014)

Stuart Davies (12/2/2014)

Ed Wagner (12/2/2014)

crookj (12/1/2014)

SQLRNNR (12/1/2014)

No...

I'm using BIDS but I probably should have said before that I'm actually working on a jumpbox. Everything's hunky-dory when I build cubes locally but I'm trying to build...

Are you modifying the view or updating the source tables?

If you're just modifying the results returned in the view, and assuming the the phone column is a varchar the code...

Fair enough, I was just wondering if'd missed something 🙂 I think that QUOTENAME is going to be something that will make my life easier though.

select yearMonth

,BariatricSurgery

,BISurgeries

,EDTransfersToBI

,GYNOncProcedures

,GYNOncVisits

,InpatientTransfersToBI

,OPVisitsByBI

,PercentAdmitsFromED

,ThoracicSurgery

from

(

select

YearMonth

,metric

,data

from

dbo.test t

) p

pivot

(

max(data)

for metric

in (

BariatricSurgery

,BISurgeries

,EDTransfersToBI

,GYNOncProcedures

,GYNOncVisits

,InpatientTransfersToBI

,OPVisitsByBI

,PercentAdmitsFromED

,ThoracicSurgery

)

) pvt

A common or garden pivot will do the same too. As a genuine question on...

If you can post some sample data and examples of what you've already tried it'll be easier to see want you want and give you an answer. Have a...

I'm really not sure what you mean by 'doing it in one select'. As far as I can see you'll have to check the preceding row in order to...

This will do what you want but I have assumed that the sample will be taken consistently every minute. If this isn't the case another approach will be needed....

When an ex-manager of mine told me they's speak to me offline about something I couldn't help help replying that I wasn't...

In true Columbo fashion, just one more thing...

You could use

AverageHolding= avg([Total Clients Value Holding])

rather than

AverageHolding=sum([Total Clients Value Holding])

/(

Select

COUNT([Fund Code])

from

[#Table]

Where 1=1

and [Client No_] = @client

AND

[Date]...

You're welcome.

One other thing, be careful using BETWEEN for date range queries. You're usually better using

where

[Date] >= @startdate

and

[Date] <= @enddate

Have a look at this article...

I've had a second look and you need to declare the length of your @client and @fund variables. If you declare them like so

DECLARE @client as varchar(n)

DECLARE @StartDate as...

Can you post some sample data please?

What do you mean by 'not working'? I've taken a guess at what your data looks like and I'm getting a 'divide...

It's a 2008 forum so I took a guess on that 😉