I rewrote it so that it's only a single query with just the subquery in the WHERE clause. Damn thing took me all day to write with triple nested case...

I guess if I had to guess, it's that the WHERE clause is applied after everything else. So the outer query has context in a subquery referenced in a WHERE...

Thank you very much!

You guessed correctly. I checked the logs and it logged the recovery process every step of the way allowing me to notify my users how long it would be down....

Fair enough Steve, that makes sense.

Yes the answer is that SQL Compare and SQL Data Compare do have a feature that allows you to "Map Owner". It really should...

No it turns out you can do it and it works great.

I tried to delete this post an hour after I created it and before anyone could reply because...

I got it working. Disregard above post.

The problem was actually DNS. I was using a file share but for some reason DNS wasn't resolving for the server the file...

If I understand what you are after correctly, then you just need to join from that table to itself like this:

SELECT a.TransactionDate, a.AccountID, a.PointsEarnedTotal, b.PointsEarnedTotal as 'YesterdayPointsEarnedTotal'

FROM #PointBalTotal a

JOIN...

Thanks to both of you, that was the solution to my problem. I failed to enable outbound transactions on the server I am pulling the data into.

I apologize, I had something in my head that doesn't work: I was thinking you could put the dynamic sql in a user defined function, then make a view that...

I'm thinking something like this:

ALTER FUNCTION [dbo].[dateSinceString]

(

@pastDate DATETIME

)

RETURNS VARCHAR(100)

AS

BEGIN

DECLARE @returnString VARCHAR(100)

DECLARE @timeUnitCount INT

SET @returnString = ''

SET @timeUnitCount = 0

DECLARE @numYearsAgo INT

SET @numYearsAgo = DATEDIFF(YEAR, @pastDate, GETDATE())

IF @numYearsAgo > 0...

You can create a string, and then create if statements that check if the datediff for each unit of time you are interested in is greater than zero. If it...

Carla, I use this all the time but I didn't know you could have it refresh automatically when they open the excel file. Currently I have it such that you...

I don't know your exact problem, but I just wanted to say, I've never encountered any relational database problem that absolutely had to be solved by a stored procedure that...

So to get how many minutes ago the post was, you'd use something like this:

DATEDIFF(minute, @dateOfPost, GETDATE())