Ed Wagner (12/12/2014)

Sky

I'm looking at this from a very different angle. This is my first tech job, to which I came 18 months ago on a long route through tourism, retail,...

Ed Wagner (12/12/2014)

Deep

Ed Wagner (12/12/2014)

Panther

D'OH!!!!!!!!!!!!!!!! :pinch:

The answer might be in the title, but as a newbie I went through my usual process of reading the question, picking...

Have a look at this page[/url] it'll point you in the right direction. We can't do much else without some input from you though. Can you post some...

The script file works fine and exporting to a csv works fine for the other columns I tried it on, it just seems not to like the binary data for...

Grant Fritchey (12/5/2014)

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)

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