Lynn,

Yeah, they can be deployed to the Company - if someone screws up. They should theoretically always be deployed to an enduser, so we audit now & then to...

OK, thanks for the tip about IFCodes. I checked out some of the posts on that subject, and will use in future. That CONVERT works with my test...

Lynn,

The CONVERT function just wasn't doing anything, so I went back to what I usually use, which is DATEADD. I had forgotten that it was failing only in my...

That looks like it may work. I'll have to wait until I can try it on the Prod DB in the morning. Thanks again.

Lynn,

Did I mention that this Date stuff drives me crazy? I checked out BOL and looked at examples here & elsewhere and figured I had the right idea, but...

Will do. Many thanks for your help.

Lynn,

That is terrific, it works. The only thing now is that it's displaying a UNIX date, and I need to convert that to a human-readable format. The usual...

Sorry, I forgot to specify what I expected. I want to see only records in To_Status = Deployed, and just the latest instance.

In the code you sent me, where...

Lynn, thank you for pointing out the post that describes the correct format for posting to the forum. I've attempted to get it right this time, but now have...

Excellent. I'll plug some test data into a query cloned off of yours & see what happens. I will search for some more examples, also.

Thanks, David.

David,

I'm familiar with the idea of saving text in an editor, so that's not a problem. I actually did the procedure described by Anatol Romanov in a discussion of...

Thanks for the replies. To clarify, I would like to execute the query in QA.

I'm too much of a SQL newbie to understand the OPENROWSET examples I saw in...

Anatol,

I used your method to prepare text input to use in a WHERE clause with an IN ( ) list. If I have a lot more data to input,...