Jacob, this looks very very promising. I am going to play with it and see if I can adjust it to the real life scenario, but conceptually this looks like...

This is pretty close but does not identify the ones that have been removed. I feel like this should be relatively simple but I can't figure out the right kind...

Where I started is this:


select s1.Id, s1.snapshotdate, s1.ProjectName, ISNULL(s1.ProjectValue,0)-ISNULL(s2.ProjectValue,0) as Change from snapshots s1 LEFT OUTER JOIN snapshots s2
on s1.SnapshotDate=dateadd(d,7,s2.snapshotdate) and s1.ProjectName=s2.ProjectName,

but...

Hi Lynn,

excellent question. I tried two different solutions one using standard left outer join (self join) and a second one with two CTEs and joins using current and...

yep sure is

there are none, which I know is where the problem is. But I am not sure how to change the query to translate no rows in the source table into...

I have actually ended up doing it exactly that way. I kept trying to use Alvin's method and could not get it to work so I brought them into a...

@Eirikur Eiriksson LOL, this was a good one!

I believe that this query will get you started:

SELECT * FROM dbo.log_shipping_monitor_primary

you would alter it for secondary if needed.

This will get you the file name and the date. I don't...

I am pretty confused by your requirement too. Can you, please, maybe describe the scenario? Otherwise, I would agree with ZZartin on his solution. It could get fairly tedious if...

This sounds like a sub-report where you are passing a parameter to other data regions.

Petr

Please, post DDL and the query that you currently have. That will help all of us in troubleshooting,

Petr

The only way to do this that I know of is to use sp_purge_jobhistory and assign either job name or job id and oldest datetime (you would have to figure...

glad that you did not get discouraged!

Petr

@ SQL TRYER

this happens everywhere. I just went through a major clean up where the previous developer defined a classic datetime field as nvarchar(50) and over the years people typed...