Grant Fritchey (12/5/2014)

---

You should be able to set a switch that outputs as a report. Here's the documentation showing how that works. You would want /Report.

I didn't know we had...

It all makes total sense now. The biggest problem I had was missing the bit about setting the date one day forward. As soon as I spotted that...

Thanks Don, I'm completely with you now. We do a lot of date\time queries here and most of the time we either include the time or cast values as...

I'm really not following you here.

declare @startdate datetime = '2014-12-04'

declare @enddate datetime = '2014-12-05'

create table #EventHeader(

HistoryIDint primary keynot null

,DateTimeHappened datetimenot null

)

insert into #EventHeader

select 100001, '2014-12-01' union all

select 100002, '2014-12-01'...

Thanks Grant. It's not massively obvious but you need to generate an interactive html report to see the differences. It's actually pretty straightforward when you know that!

I've just returned to a project I was working on some months ago about comparing stored procs and everything I found brought me to Red Gate Compare.

@Grant, seeing...

ScottPletcher (12/3/2014)

---

BWFC (11/27/2014)

---

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

Gary Varga (12/3/2014)

---

ccd3000 (12/2/2014)

---

I put a premium on passion but not over talent. Take Joe DiMaggio for example, he hated baseball and never liked it, but was one of it's...

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